Bug #60204 CHANGE MASTER TO command gives error with MASTER_HEARTBEAT_PERIOD params
Submitted: 22 Feb 2011 12:08 Modified: 22 Feb 2011 12:31
Reporter: Vimalesh S Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.1.36 OS:Solaris (Soalris 8)
Assigned to: CPU Architecture:Any

[22 Feb 2011 12:08] Vimalesh S
CHANGE MASTER TO command always gives error if the command has MASTER_HEARTBEAT_PERIOD params .

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_HEARTBEAT_PERIOD=90' at line 1

How to repeat:
Install 5.1.36 version Mysql in unix 8 and execute CHANGE MASTER TO  with MASTER_HEARTBEAT_PERIOD params.

Suggested fix:
I would like to modify the heartbeat interval in slave  using MASTER_HEARTBEAT_PERIOD but it doesn't help, we neeed fix for this issue.

Please help us.
[22 Feb 2011 12:31] Valeriy Kravchuk
Please, read the manual, http://dev.mysql.com/doc/refman/5.1/en/change-master-to.html:

"The next two options (MASTER_BIND and MASTER_HEARTBEAT_PERIOD) are available in MySQL Cluster NDB 6.3 and later, but are not supported in mainline MySQL 5.1"