0

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

mysql select statements gives three nodes in the group

However, the MySQL shell gives only one node in the cluster:

mysql shell shows 1 node in the cluster

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

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

1 Answer 1

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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