MySQL Forums
Forum List  »  InnoDB clusters

Re: Discrepancy between mysqlsh and performance_schema with 8.0.11
Posted by: Grant Gavares
Date: May 15, 2018 04:46PM

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Discrepancy between mysqlsh and performance_schema with 8.0.11
770
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.