Home > Mobile >  How to do Delayed Replication on MySQL 8?
How to do Delayed Replication on MySQL 8?

Time:08-09

I made replication for MySQL 8 just like in the documentation: https://dev.mysql.com/doc/refman/8.0/en/replication.html But I cant make a 17.4.11 Delayed Replication. I suppose before it was easy: 17.3.10 Delayed Replication, before you just need to change CHANGE MASTER TO MASTER_DELAY = N; and that is all. Can someone help me understand how to do Delayed Replication on MySQL 8? Thank you!

CodePudding user response:

stop slave;

change master to MASTER_DELAY=60;

start slave;

  • Related