---
title: MGR角色切换
description: "1. 确定要切换成员的member_id。"
url: https://www.hikunpeng.com/document/detail/zh/kunpengdbs/ecosystemEnable/MySQL/kunpengmysqlmgr_03_0043.html
sourcePath: /source/zh/kunpengdbs/ecosystemEnable/MySQL/kunpengmysqlmgr_03_0043.html
indexId: 5a3aa7cbf892ea145cb2cc26364af3e022699692406bd12d220109db04663fd572
---
# MGR角色切换

1. 确定要切换成员的member_id。
  1 2 show variables like '%server_%'; SELECT * FROM performance_schema.replication_group_members;

2. 执行切换。
  1 SELECT group_replication_set_as_primary('换成目标主库的member_id');

  例如：

  1 SELECT group_replication_set_as_primary('e44f902b-bf50-11ea-89d7-000000536bb6');

  1 2 3 4 5 6 +--------------------------------------------------------------------------+ | group_replication_set_as_primary('e44f902b-bf50-11ea-89d7-000000536bb6') | +--------------------------------------------------------------------------+ | Primary server switched to: e44f902b-bf50-11ea-89d7-000000536bb6 | +--------------------------------------------------------------------------+ 1 row in set (1.00 sec)

  确认切换进度： 1 SELECT event_name, work_completed, work_estimated FROM performance_schema.events_stages_current WHERE event_name LIKE "%stage/group_rpl%";