Bug #92878 CHANGE MASTER TO MASTER_DELAY
Submitted: 22 Oct 2018 9:44 Modified: 22 Oct 2018 9:56
Reporter: Sandeep Kumar Maharana Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.5.61 OS:Ubuntu
Assigned to: CPU Architecture:Any

[22 Oct 2018 9:44] Sandeep Kumar Maharana 
Description:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER_DELAY =180'.

SQL_Delay not setup.

How to repeat:

SQL_Delay not activated while setting the replication.
[22 Oct 2018 9:56] MySQL Verification Team 
HI Sandeep,

Thank you for the report.
I see you are trying to use MASTER_DELAY with 5.5 but MASTER_DELAY is available since 5.6. Quoting from manual/change log - Replication: MySQL now supports delayed replication such that a slave server deliberately lags behind the master by at least a specified amount of time. The default delay is 0 seconds. Use the new MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds:

CHANGE MASTER TO MASTER_DELAY = N;

More details https://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-0.html

Also, https://dev.mysql.com/doc/refman/5.6/en/replication-delayed.html

regards,
Umesh