Re: Mysqlconnector/J for PXC cluster
Posted by: Filipe Silva
Date: March 02, 2016 10:56AM

Hi Yasser,

The situation you described is not very clear. Please provide some more information about what you are expecting to happen so that I can help you.

In the meanwhile please mind that in this fail-over setup, an active connection may switch to a different server only in one of these two cases:
1. The server to which the connection object is currently connected to ceases to respond (operation throws a connection exception). This triggers a fail-over which will either try to connect to the next server in the list or to the primary server (1st in the list of servers), depending on the conditions defined in the properties 'queriesBeforeRetryMaster' and/or 'secondsBeforeRetryMaster'.
2. The connection object is connected to a secondary server (not the 1st in the list of servers) AND one of the conditions to retry master is met AND this is a transaction boundary operation (every single query if 'auto-commit=true' or at commit/rollback otherwise).
Apart from that no other connection switches should happen.

Please check the documentation ( for more details about the failover process.

Regarding your second question, I'd say yes, but you still should confirm this with the vendors/providers you are using.

Options: ReplyQuote

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

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.