Re: Mysqlconnector/J for PXC cluster
Posted by: Yasser Param
Date: March 08, 2016 09:18AM

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.


Options: ReplyQuote

Written By
Re: Mysqlconnector/J for PXC cluster
March 08, 2016 09:18AM

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.