Reference Guide
Table Of Contents
- Dell Wyse Management Suite Version 1.4 High Availability Guide
- Introduction
- High availability architecture
- High availability on Windows Server 2012/2016
- Achieve high availability on Windows Server 2012/2016
- Achieve high availability for MySQL InnoDB
- Achieve high availability on MongoDB
- Achieve high availability for Teradici devices
- Install Wyse Management Suite on Windows Server 2012/2016
- Upgrade Wyse Management Suite version 1.3 to 1.4
- Post installation checks
- Troubleshooting
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
Prerequisite
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')
3 Run the following command to check the status of the cluster.
Achieve high availability for MySQL InnoDB
43