O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

  1. On Server C: Stop slave and note the Relay_Master_Log_File and Exec_Master_Log_Pos positions in the SHOW SLAVE STATUS\G command:
mysql> STOP SLAVE;Query OK, 0 rows affected (0.01 sec)mysql> SHOW SLAVE STATUS\G*************************** 1. row ***************************               Slave_IO_State:                   Master_Host: xx.xxx.xxx.xxx                  Master_User: binlog_user                  Master_Port: 3306                Connect_Retry: 60              Master_Log_File: server_A-bin.000023          Read_Master_Log_Pos: 2604               Relay_Log_File: server_C-relay-bin.000002                Relay_Log_Pos: 1228        Relay_Master_Log_File: server_A-bin.000023~          Exec_Master_Log_Pos: 2604              Relay_Log_Space: 1437              Until_Condition: None               Until_Log_File:                 Until_Log_Pos: 0~1 row in set (0.00 sec)
  1. On Server B: Stop slave and note the Relay_Master_Log_File ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required