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 ?
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.
yes, we are in azure, so we have a load balancer where the cluster exist
Hi, you should review the load balancer configuration, what are the health checks in use?
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
@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.