Not all 3 xtradb cluster nodes are receiving connections

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello Here,

Sorry for the double post. I have currently posted on DB stackexchange https://dba.stackexchange.com/questions/274545/percona-xtradb-cluster-5-7-solution-on-aws-and-on-premise-not-all-nodes-are-con and looking at the number of views etc it looks like I should have posted it here.

For a little context on those here. The cluster seems to be fine and working well but , the “last” one doesn’t seem to be used at all by anything and I found that a bit odd so I am asking for a little guidance and help.

Thanks in advance.

2

Cross-posting answer for double points :slight_smile:

According to [the documentation][1], the JDBC connector will use the servers listed in the connectstring in order, while always reattempting to connect to the server before it. So, if you have A,B,C and A goes down, the connector will use B and will continue to use B until A comes back up. When A comes back online, the connector will resume using A. C will only get used if both A and B are down.

[1]: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-config-failover.html