Adding new nodes to PXC 8.0

1

Hi,

I have a 3 node cluster and we are planning to migrate to new network with minimum downtime.
So we have to add 3 more nodes to the existing PXC cluster.
It is possible to use xtrabackup to take a full backup and restore on the new nodes and then start mysql so that the new nodes get added to the existing cluster.
Could you please suggest if this approach will work?
Has anyone done like this?

2

Hello @ulka01,
You have two options.

  1. Start node #4 in the new network. Have it join existing cluster. This will automatically copy data to node 4 and it will join. Repeat for node #5, and #6. Then shut down node #3, then node #2, then node #1. By shutting down the original nodes gracefully, you will correctly reduce the expected quorum size back to 3 in the new network.

  2. Use PXB to backup node1. Restore to node4, and create a separate, new PXC in new network. Configure async replication between node1 and node4. Once the two clusters are sync’d, move applications to new cluster, then shut down old cluster.

3

Super, I tried solution1, and it didn’t work.
I will try the solution 2.
So to clarify.
Shall I make any changes to my.cnf like add 4th node to the percona gcomm.

4

Hi,
Could you please explain how do I configure async replication between node1 and node4.

5

It’s the typical, standard CHANGE REPLICATION SOURCE TO …