Reference Guide

Figure 19. MySQL command prompt

To check that the MySQL InnoDB is created on all the three cluster nodes, run the following commands at the command prompt:

•

mysql-js> dba.checkInstanceConfiguration('root@IPAddress1:3306')

•

mysql-js> dba.checkInstanceConfiguration('root@IPAddress2:3306')

•

mysql-js> dba.checkInstanceConfiguration('root@IPAddress3:3306')

Create a cluster instance for MySQL InnoDB

After you have installed MySQL InnoDB instance on the servers, create a cluster instance.

To create a cluster for MySQL InnoDB, do the following:

1 Login as administrator user from the command prompt. This user account should have administrative privileges. For example,

DBadmin. The following screen shows an example of logging in as root user.

Figure 20. Login prompt

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.

Achieve high availability for MySQL InnoDB