MySQL 5.7

可以通过global statusgroup_replication_primary_member确定


root@db20:59:[mgr]>SELECTVARIABLE_VALUE->FROMperformance_schema.global_status->WHEREVARIABLE_NAME='group_replication_primary_member';+--------------------------------------+|VARIABLE_VALUE|+--------------------------------------+|f8da6826-328a-11e9-8e54-000c29d7ca48|+--------------------------------------+1rowinset(0.00sec)


可以结合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|+-------------+-------------+1rowinset(0.00sec)


或者获取全部成员信息:


root@db21:05:[mgr]>SELECT->MEMBER_ID,->MEMBER_HOST,->MEMBER_PORT,->MEMBER_STATE,->IF(global_status.VARIABLE_NAMEISNOTNULL,->'PRIMARY',->'SECONDARY')ASMEMBER_ROLE->FROM->performance_schema.replication_group_members->LEFTJOIN->performance_schema.global_statusONglobal_status.VARIABLE_NAME='group_replication_primary_member'->ANDglobal_status.VARIABLE_VALUE=replication_group_members.MEMBER_ID;+--------------------------------------+-------------+-------------+--------------+-------------+|MEMBER_ID|MEMBER_HOST|MEMBER_PORT|MEMBER_STATE|MEMBER_ROLE|+--------------------------------------+-------------+-------------+--------------+-------------+|f8da6826-328a-11e9-8e54-000c29d7ca48|mgr1|3306|ONLINE|PRIMARY||030930d7-32b2-11e9-8298-000c292aafc5|mgr2|3306|ONLINE|SECONDARY||202bdcd5-32b3-11e9-9f4f-000c29322d33|mgr3|3306|ONLINE|SECONDARY|+--------------------------------------+-------------+-------------+--------------+-------------+3rowsinset(0.01sec)

MySQL 8.0.2 and Later

MySQL 8.0.2开始,Performance Schema被扩展

SELECTMEMBER_HOST,MEMBER_PORTFROMperformance_schema.replication_group_membersWHEREMEMBER_ROLE='PRIMARY';




或者获取全部成员信息:

mysql>SELECTMEMBER_ID,MEMBER_HOST,MEMBER_PORT,MEMBER_STATE,MEMBER_ROLE,MEMBER_VERSIONFROMperformance_schema.replication_group_members;