Re: Mysqlconnector/J for PXC cluster

[Filipe Silva]

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 (http://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html) 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.