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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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?
--
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