Re: Discrepancy between mysqlsh and performance_schema with 8.0.11
More details. If I create a cluster with 3 configured seed nodes but only two of the seed nodes available and then run:
dba.createCluster('test')
The cluster is created with the two healthy machines as a part of the cluster:
{
"nodes": {
"mysql-1.local:3306": {
"status": "ONLINE",
"role": "HA",
"mode": "R/W"
},
"mysql-3.local:3306": {
"status": "ONLINE",
"role": "HA",
"mode": "R/O"
}
},
"primary": {
"host": "mysql-1.local",
"port": "3306"
}
}
The missing node (mysql-2) is started with the same set of seed nodes and, according to the logs, believes it has joined the replication group:
2018-05-15T22:36:27.935787Z 0 [Note] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to mysql-2.local:3306, mysql-3.local:3306, mysql-1.local:3306 on view 15264235362398542:3.'
2018-05-15T22:36:27.935958Z 0 [Note] [MY-011490] [Repl] Plugin group_replication reported: 'This server was declared online within the replication group.'
The host doesn't show up in the output of 'dba.getCluster().status()' which still looks exactly as pasted above.
The performance_schema.replication_group_members table does show mysql-2 is online and is registered as a SECONDARY:
mysql> select * from performance_schema.replication_group_members;
+---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION |
+---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+
| group_replication_applier | 60b49200-5890-11e8-9b8f-0242ac120003 | mysql-2.local | 3306 | ONLINE | SECONDARY | 8.0.11 |
| group_replication_applier | caa25534-588f-11e8-b478-0242ac120004 | mysql-3.local | 3306 | ONLINE | SECONDARY | 8.0.11 |
| group_replication_applier | cacd3971-588f-11e8-b480-0242ac120002 | mysql-1.local | 3306 | ONLINE | PRIMARY | 8.0.11 |
+---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+
3 rows in set (0.00 sec)
Subject
Views
Written By
Posted
1905
May 14, 2018 10:47PM
Re: Discrepancy between mysqlsh and performance_schema with 8.0.11
835
May 15, 2018 04:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.