Problem in the distrubution of traffic in PXC cluster

MySQL & MariaDB Percona Server for MySQL 5.7
1

we have a cluster PXC that have 5 nodes, and those nodes does not share the same traffic only 2 of them that has the traffic, so what could be the problem, is there any algorithme that does this distrubution, is it based on something ?

1 Like
2

Hello @MAGGI,
Do you have a load-balancer or proxy between application and PXC? If you do not, then you will only see data going to those nodes that the application connects.

1 Like
3

yes, we are in azure, so we have a load balancer where the cluster exist

1 Like
4

Hi, you should review the load balancer configuration, what are the health checks in use?

1 Like
5

hello, in the health probe of Load balancer we have two health checks, one with xinetd-mysql in port 9500 with protocol http, and the other mysql in port 3306 with protocol TCP

1 Like
6

@MAGGI What is the configuration of the load balancer? Can you see all nodes in healthy state through the LB? Is the LB configured to round-robin style? All the applications go through this LB? If so, then it sounds like you have a misconfiguration in your LB that does not spread the load evenly across all of the pool members.

1 Like