Rate This Document
Findability
Accuracy
Completeness
Readability

Obtaining MySQL InnoDB Cluster Information

  1. Log in to the primary node using MySQL Shell.
    1
    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.
    1
    var fandercluster = dba.createCluster('fandercluster')
    

  3. Check the status of the InnoDB cluster and exit.
    1
    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.