Hi Team,
We are using MaxScale version 2.4.9 for load balancing the request made to Galera Cluster(3 nodes)
The write operation is only take care by the master node and read operation by all the 3 nodes of the cluster.
We are having the 2 Galera Cluster behind the MaxScale which are listening the required on two different listeners.
The Maxscale Configuration in our environment is attached to this ticket.
Problem Statement:
Maxscale is not sending the traffic on all the 3 nodes equally. The 3rd node of Galera Cluster is not having ample amount of load in comparison to other nodes in the cluster.
Question is why maxscale is not utilizing the 3rd node in read-write split router configuration?
How to fix the issue?