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:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.1.36 OS:Solaris (Soalris 8)
Assigned to: CPU Architecture:Any
Tags: CHANGE MASTER

[22 Feb 2011 12:08] Vimalesh S
Description:
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"

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.