Bug #90461 Change group_replication_single_primary_mode online
Submitted: 17 Apr 2018 4:58 Modified: 16 Nov 2018 11:45
Reporter: Kenny Gryp Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Group Replication Severity:S4 (Feature request)
Version:8.0.4 OS:Any
Assigned to: CPU Architecture:Any

[17 Apr 2018 4:58] Kenny Gryp
Description:
I want to change my running production cluster to a multi-writer group replication setup. But when I try to do this online, I get an error

How to repeat:
mysql> set global group_replication_single_primary_mode=off;
ERROR 3093 (HY000): Cannot change into or from single primary mode while Group Replication is running.

Suggested fix:
I want to be able to change group_replication_single_primary_mode online without downtime.
[2 May 2018 12:31] MySQL Verification Team
Hello Kenny,

Thank you for the feature request!

Thanks,
Umesh
[16 Nov 2018 11:45] Nuno Carvalho
Implemented in 8.0.13
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-online-group.html
[22 Nov 2018 10:19] David Moss
Posted by developer:
 
Thanks for your feedback, as mentioned by Nuno this was implemented in 8.0.13. See docs at:
http://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-online-group.html