Users Guide

• mysql-js> dba.checkInstanceConfiguration('root@IP Address3')

Figure 37. 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')

The instance "IPAddress:3306" is valid for InnoDB cluster usage; 'Status': 'ok' message is displayed.

Create a cluster instance for MySQL InnoDB

Prerequisites

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

About this task

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

Steps

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 38. 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')

Achieve high availability for MySQL InnoDB