Not the answer you need?
Register and ask your own question!

Not all 3 xtradb cluster nodes are receiving connections

blacksenseiblacksensei EntrantLegacy User Role Contributor

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.

Answers

  • matthewbmatthewb Senior [email protected] Percona Staff Role

    Cross-posting answer for double points :)

    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

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.