Re: Mysqlconnector/J for PXC cluster

[Yasser Param]

Hi Filipe,

Thank you for the ideas.

I was able to meet my requirement with --skip-networking and secondsBeforeRetryMaster.

Here is the sequence of events -
1) Node 1 goes down
2) Connector/J is able to failover to node 2
3) Bring back node 1 with --skip-networking - this makes the node available to the cluster for data replication but no connections on 3306 is allowed. Connections are still on node 2 now.
4) After data sync on node 1 is complete, restart node 1 normally
5) secondsBeforeRetryMaster is set to 5 seconds, so connections move from node 2 to node 1

Using the above technique I was able to have connections to one node only at given point in time.

Hope this helps others looking for something similar.

Thanks,