Rate This Document
Findability
Accuracy
Completeness
Readability

Creating a MySQL InnoDB Cluster

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

    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.