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;
+---------------------------+--------------------------------------+--------------+-------------+--------------+-------------+