Reference Guide

2. Run the following command to create a cluster with a unique name. For example, MySQLCluster.
MySql JS> var cluster = dba.createCluster('MySQLCluster')
3. Run the following command to check the status of the cluster.
MySql JS>Cluster.status()
The status of the created cluster is displayed as ONLINE which indicates that the cluster is created successfully.
Figure 39. Confirmation screen
Add server instance to MySQL InnoDB cluster
Prerequisites
● Before you add servers or nodes to the clusters, change the server id to either 2 or 3 in the
my.conf file in the secondary MySQL servers at C:\ProgramData\MySQL\MySQL Server 5.7.
● Only the primary MySQL server must have server ID as 1. The server ID should be unique across the SQL cluster.
About this task
You must add server instance to the MySQL InnoDB cluster as primary or secondary.
Do the following to add a server instance to the MySQL InnoDB cluster:
1. Log in as DB Admin user from the command prompt on the primary server.
2. Run the following command to add a server instance to the MySQL InnoDB cluster:
cluster.addInstance('root@IPAddress2:3306')
cluster.addInstance('root@IPAddress3:3306')
NOTE:
The IP address and the port numbers are only examples and varies based on the system that you are using at
your work place.
3. Run the following command to check the status of the server instance:
cluster.status()
NOTE:
● If the server IDs are same in all the nodes, and if you try to add instances in the Cluster, the error message Server_ID
is already in used by the peer node, Result<Runtime Error> is displayed.
● All the nodes should display the status as ONLINE which indicates that the nodes have been added successfully to the
MySQL InnoDB cluster setup.
44 Achieve high availability for MySQL InnoDB