The traffic doesn't distributed evenly among nodes - (Galera Cluster)

54 views
Skip to first unread message

kamal desouky

unread,
Jul 16, 2023, 9:47:31 AM7/16/23
to codership
I have a mariadb galera cluster with 3 nodes. The issue is that one node in a Galera Cluster has more connections than the others, even though they have the same resources and same config.
The load balancer is a weighted round robin with the same weight for each one, the sticky session is enabled.
also wsrep_local_recv_queue_avg results with a high value and sometime lead to mysql crash. 

Colin Charles

unread,
Aug 17, 2023, 6:25:30 AM8/17/23
to kamal desouky, codership
Hi!

What is the load balancer in question and what is the configuration? Isn’t sticky session being enabled, i.e. session affinity, the reason you’re facing issues where one node has more connections that the others?

-c
> --
> You received this message because you are subscribed to the Google Groups "codership" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to codership-tea...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/codership-team/caa0a5b7-2ab7-49c7-a563-498a0fd81643n%40googlegroups.com.

--
Colin Charles, http://bytebot.net/blog/
twitter: @bytebot | skype: colincharles
"First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

Reply all
Reply to author
Forward
0 new messages