MySQL Bugs: #60204: CHANGE MASTER TO command gives error with MASTER_HEARTBEAT

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

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.

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"