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 B: Stop the slave and note down the master status:
mysql> STOP SLAVE;Query OK, 0 rows affected (0.04 sec)mysql> SHOW MASTER STATUS;+---------------------+----------+--------------+------------------+-------------------+| File                | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |+---------------------+----------+--------------+------------------+-------------------+| server_B-bin.000003 | 44627878 |              |                  |                   |+---------------------+----------+--------------+------------------+-------------------+1 row in set (0.00 sec)
  1. On server C: Make sure that the slave delay is caught up.  Relay_Master_Log_File and Exec_Master_Log_Pos should be equal to the output of the master status on server B. Once the delay is ...

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