まず、レプリケーションを停止。
STOP SLAVE;
停止を確認したら下記コマンドを実行
CHANGE MASTER TO MASTER_DELAY=86400;
※上記の例だと24時間遅延
レプリケーションを再開
START SLAVE;
レプリケーションの遅延を確認
SHOW SLAVE STATUS \G
下記の様になっていれば成功
SQL_Delay: 86400
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme
List of users who liked
99