Resynchronization for MySQL

You might need to resynchronize the two nodes under certain conditions. For example, after a failover, if the former secondary has become primary, you might want to force the original primary to be primary again. Follow these instructions to resynchronize the nodes on a MySQL system:

1. Stop MOVEit Automation service on the current secondary node.
2. Stop MOVEit Automation service on the current primary node (using MOVEit Automation Admin's "Shut Down Service" command if tasks could be running).
3. Stop MySQL service on both nodes.
4. On the desired new primary node, run the MOVEit Automation configuration utility and:
   1. Set the startup role to primary.
   2. Choose the "Clear Admin Rep" button.
   3. Choose the "Clear SQL Rep" button.
5. On the desired new secondary node, run the MOVEit Automation configuration utility and:
   1. Set the startup role to secondary.
   2. Choose the "Clear Admin Rep" button.
   3. Choose the "Clear SQL Rep" button.
6. Determine which of the two nodes has the most current database. Generally, this is the last machine to have served as the primary node. Go to the OTHER node (the one with the less current database) and choose the "Copy Database" button to request a complete copy of the most current database. Wait for the copy procedure to complete.
7. Start MySQL service on both nodes.
8. Start MOVEit Automation service on the new primary node.
9. Start MOVEit Automation service on the new secondary node.