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
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