0

I followed docker innodb cluster manual method to create an innodb cluster. Now in mysql server instance, by running select * from performance_schema.replication_group_members, I can see the group contains 3 nodes:

mysql select statements gives 3 nodes in the group

However, mysql shell gives only 1 node in the cluster:

mysql shell shows 1 node in the cluster

Why they are not identical? I think the replication group is the same thing as an innodb cluster in this example.

  • well, it has to be manually added into the cluster. by running dba.getCluster().addInstance() in mysql shell. – Tiina Mar 10 at 10:36
0

The unofficial docker innodb cluster manual does not use MySQL Shell to set up and configure the MySQL InnoDB cluster.

If you want/need to use the MySQL Shell to manage your InnoDB cluster then you must "adopt" the running Group Replication group. To do so, use the adoptFromGr option of dba.createCluster():

dba.createCluster("testcluster", {adoptFromGr: true})

For more information, please consult the official userguide:

https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-from-group-replication.html

Cheers,

Miguel

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.