Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

Obtaining MySQL InnoDB Cluster Information

  1. Log in to the primary node using MySQL Shell.
    mysqlsh --uri root@127.0.0.1:3306

    After the command is executed, enter the password for logging in to the database of the primary node.

  2. Use the existing MGR to create an InnoDB cluster.
    var fandercluster = dba.createCluster('fandercluster')

  3. Check the status of the InnoDB cluster and exit.
    fandercluster.status()

    127.0.0.1:3306 is in R/W mode and is the primary node. 127.0.0.1:3307 and 127.0.0.1:3308 are in R/O mode and are secondary nodes. MGR works properly. It can be concluded that MySQL InnoDB Cluster is deployed successfully.