Mysqlconnector/J for PXC cluster
Posted by: Yasser Param
Date: March 02, 2016 10:08AM

I have three Mysql 5.6.22 nodes in a PXC setup.
I have configured mysqlconnector/J 5.1.38 for automatic fail-over in Jboss servers.

The only problem I see is with fallbacks. The requirement is to not have connections to multiple nodes because of deadlock occurrences.

In my jboss server, I configured jdbc:mysql://nod1,node2,node3/pe2e with the property secondsBeforeRetryMaster set to 5. When node3 goes down, connections immediately failover on node2, but on resurrecting node3, the connections take a while to move back to node 3. In that time period, connections are found on two nodes. Is there a way to speed-up fallback to master?
The other question I have, is mysqlconnector recommended for a PXC setup over F5?

Options: ReplyQuote

Written By
Mysqlconnector/J for PXC cluster
March 02, 2016 10:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.