Steps to stop replication

Products

• CA API Gateway

Issue/Introduction

After upgrading the gateway from 11.0 to 11.1.2, several different on-site teams stop MySQL replication during upgrade and changes are occurring.

What are the steps to stop replication to the secondary during this process?

Environment

Gateway 11.X

Resolution

The commands are documented under Restart Replication

Quick reference commands to stop: 

# mysqladmin stop-replica 

OR from mysql

mysql> STOP REPLICA

Stopped/paused replication: 

# mysqladmin stop-replica

Checked status: 

#  mysql -e "show slave status\G"

*************************** 1. row ***************************

               Slave_IO_State:

                  Master_Host: <master_hostname>

                  Master_User: repluser

                  Master_Port: 3307

                Connect_Retry: 100

              Master_Log_File: ssgbin-log.000014

          Read_Master_Log_Pos: 77532002

               Relay_Log_File: ssgrelay-bin.000046

                Relay_Log_Pos: 77532220

        Relay_Master_Log_File: ssgbin-log.000014

             Slave_IO_Running: No

            Slave_SQL_Running: No

 

Restarted Images will restart replication 

#  mysql -e "show slave status\G"

*************************** 1. row ***************************

               Slave_IO_State: Waiting for source to send event

                  Master_Host: <master_hostname>

                  Master_User: repluser

                  Master_Port: 3307

                Connect_Retry: 100

              Master_Log_File: ssgbin-log.000014

          Read_Master_Log_Pos: 77606267

               Relay_Log_File: ssgrelay-bin.000048

                Relay_Log_Pos: 74728

        Relay_Master_Log_File: ssgbin-log.000014

             Slave_IO_Running: Yes

            Slave_SQL_Running: Yes