MySQL Bugs: #80124: mysqlrpladmin failover does not change the read

Bug #80124	mysqlrpladmin failover does not change the read_only setting
Submitted:	22 Jan 2016 23:30	Modified:	22 Nov 2016 10:25
Reporter:	monty solomon	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Utilities	Severity:	S1 (Critical)
Version:	1.5.6	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
After executing the mysqlrpladmin failover command the new master is still running in read-only mode.

How to repeat:
Create a master/slave cluster with GTID.

Execute the mysqlrpladmin failover command to change a slave to be the master.

Check the read_only settings on the new master and observe that they were not changed.

Suggested fix:
Call set_read_only() on the new master in addition to executing the commands to clean the previous replication settings on the new master.

Hello monty solomon,

Thank you for the bug report.
This is most likely duplicate of Bug #76522, please see Bug #76522.

Thanks,
Chiranjeevi.