如何确认Single-Primary模式下的MGR主节点
发布时间：2022-03-29 04:59:32 所属栏目：MySql教程 来源：互联网
导读：MySQL 5.7 可以通过global status group_replication_primary_member 确定 root@db20:59: [mgr] SELECT VARIABLE_VALUE - FROM performance_schema.global_status - WHERE VARIABLE_NAME = group_replication_primary_member; +----------------------------
|
MySQL 5.7 可以通过global status group_replication_primary_member 确定 root@db20:59: [mgr]> SELECT VARIABLE_VALUE -> FROM performance_schema.global_status -> WHERE VARIABLE_NAME = 'group_replication_primary_member'; +--------------------------------------+ | VARIABLE_VALUE | +--------------------------------------+ | f8da6826-328a-11e9-8e54-000c29d7ca48 | +--------------------------------------+ 1 row in set (0.00 sec) 可以结合 performance_schema.replication_group_members 表 获取主机名和端口信息: root@db21:05: [mgr]> SELECT -> MEMBER_HOST, MEMBER_PORT -> FROM -> performance_schema.replication_group_members -> WHERE -> MEMBER_ID = (SELECT -> VARIABLE_VALUE -> FROM -> performance_schema.global_status -> WHERE -> VARIABLE_NAME = 'group_replication_primary_member'); +-------------+-------------+ | MEMBER_HOST | MEMBER_PORT | +-------------+-------------+ | mgr1 | 3306 | +-------------+-------------+ 1 row in set (0.00 sec) MySQL 8.0.2 and Later MySQL 8.0.2开始, Performance Schema被扩展 SELECT MEMBER_HOST, MEMBER_PORT FROM performance_schema.replication_group_members WHERE MEMBER_ROLE = 'PRIMARY'; 或者获取全部成员信息: mysql> SELECT MEMBER_ID, MEMBER_HOST, MEMBER_PORT, MEMBER_STATE, MEMBER_ROLE, MEMBER_VERSION FROM performance_schema.replication_group_members; （编辑：威海站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
