如何确认Single-Primary模式下的MGR主节点

发布时间：2022-03-28 18:18:28 所属栏目：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;

（编辑：云计算网_泰州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

MySQL之日志管制	如何使用mysql索引
Anemometer图形化显示	mysql数据库explain命