Monday, 7 September 2015

Set mysql delayed replication for mysql old backup

MySQL 5.6 is  adding slave replication delay:

mysql> stop slave;

mysql> CHANGE MASTER TO MASTER_DELAY = 604800;

604800=7days in seconds

mysql> start slave;

mysql> show slave status\G;

         Seconds_Behind_Master: 19
         Master_SSL_Verify_Server_Cert: No
         Last_IO_Errno: 0
         Last_IO_Error: 
         Last_SQL_Errno: 0
         Last_SQL_Error: 
         Replicate_Ignore_Server_Ids: 
          Master_Server_Id: 1
          Master_UUID: 
          Master_Info_File: /data/mysqldata/master.info
          SQL_Delay: 604800

          SQL_Remaining_Delay: 604781



----------------------------------------------------------------------------------------
SQL_Delay=Seconds_Behind_Master+SQL_Remaining_Delay
604800=19+604781
-----------------------------------------------------------------------------------------

No comments:

Post a Comment