CA API Gateway - Stopping MySQL Replication When Relocating Secondary DB Node
search cancel

CA API Gateway - Stopping MySQL Replication When Relocating Secondary DB Node


Article ID: 192040


Updated On:


CA API Gateway


A scenario may arise where the Secondary Clustered Gateway node with MySQL Database Replication established requires relocation to new infrastructure. For this Use Case it is best practices to stop MySQL DB Replication between nodes before any moves are made.

For this use case the hostname and IP address of your affected (relocated) node are not changing. 


Release : 9.x Cluster with MySQL DB Replication enables between Primary and Secondary Nodes

Component : API GATEWAY


A required Infrastructure move of the Secondary DB node in a Gateway Cluster


Before moving your Secondary node it is important to stop MySQL Database Replication between the Primary and Secondary DB nodes of the cluster and then establish proper MySQL DB Replication between nodes.

First:  stop MySQL DB Replication by creating an SSH connection to BOTH the Primary and Secondary Gateway Appliance, dropping into the privileged root shell and running: 

mysql -e "STOP SLAVE\G"

This will stop MySQL Replication Between Nodes and can be checked with command:


A properly stopped replication status will show an output as such:

Now you are ready to power-down and move the Secondary node for relocation

After your Secondary node is relocated to the final infrastructure destination and restarted and both SSG Services and MySQL are up and running (including replication) perform the following step:

On the Primary MySQL DB node run:

mysql -e "START SLAVE\G"

This will restart replication between the Primary and Secondary node.

As a final step please run mysql -e "SHOW SLAVE STATUS\G" from both the Primary and Secondary nodes to ensure healthy MySQL DB Replication, which should output as such: