Rate This Document
Findability
Accuracy
Completeness
Readability

Creating a MySQL InnoDB Cluster

  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()
    

    In multi-primary mode, 127.0.0.1:3306, 127.0.0.1:3307, and 127.0.0.1:3308 are in R/W mode and are all primary nodes. MGR works properly. It can be concluded that the MySQL InnoDB cluster is deployed successfully.