Migration/transfer

• How do I transfer data to a cluster?

• How do I move a cluster to a different folder or cloud?

• External replication error

How do I transfer data to a cluster?How do I transfer data to a cluster?

Follow the steps described in this tutorial.

How do I move a cluster to a different folder or cloud?How do I move a cluster to a different folder or cloud?

To move a cluster:

• To a different folder: Restore the cluster from a backup. Specify the target folder when configuring the new cluster.
• To a different cloud: Follow the steps in this tutorial.

External replication errorExternal replication error

Error message:

Last\_IO\_Error: 
Got fatal error 1236 from source when reading data from binary log: 
'Could not find first log file name in binary log index file'

This error may occur during external replication using the master host's specific FQDN if the master host in the source cluster has changed.

Solution:

1. Restart replication.

2. Run this command once:

   STOP SLAVE;
   CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
   START SLAVE;
   

If the master host in the source cluster changes, the replication will be reconfigured to use the new master host. Read more about the setting in this MySQL® guide.