MGR(组复制)—单主模式与多主模式的切换

MySQL在8.0.13后支持在线切换single primary和multi primary两种模式，本文章讲解 MGR（组复制）的模式切换。

一、更改为单主模式

使用 group_replication_switch_to_single_primary_mode() UDF通过发出以下命令，将以多主要模式运行的组更改为单主要模式：

SELECT group_replication_switch_to_single_primary_mode();

mysql> SELECT group_replication_switch_to_single_primary_mode();
+---------------------------------------------------+
| group_replication_switch_to_single_primary_mode() |
+---------------------------------------------------+
| Mode switched to single-primary successfully.     |
+---------------------------------------------------+
1 row in set (0.01 sec)

mysql> SELECT * FROM performance_schema.replication_group_members;
+---------------------------+--------------------------------------+--------------+-------------+--------------+-------------+