Reference Guide
Table Of Contents
- Dell Wyse Management Suite Version 3.x High Availability Guide
- Contents
- Introduction
- High availability architecture
- High availability on Windows Server 2012 R2/2016/2019
- Achieve high availability on Windows Server 2012 R2/2016/2019
- 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 R2/2016/2019
- Post installation checks
- Upgrade Wyse Management Suite version 1.3 to 1.4
- Upgrading from Wyse Management Suite version 1.4/1.4.1/2.x/2.1 to Wyse Management Suite version 3.x
- Troubleshooting
● mysql-js> dba.checkInstanceConfiguration('root@IP Address2')
● 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
Achieve high availability for MySQL InnoDB
43