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

[22 Jan 2016 23:30] monty solomon
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.
[22 Nov 2016 10:25] Chiranjeevi Battula
Hello monty solomon,

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

Thanks,
Chiranjeevi.