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
MySql JS>Cluster.status()
The status of the created cluster is displayed as ONLINE which indicates that the cluster is created successfully.
Figure 39. Conrmation screen
Add server instance to MySQL InnoDB cluster
Prerequisite
• Before you add servers or nodes to the clusters, change the server id to either 2 or 3 in the my.conf
le in the secondary MySQL servers at C:\ProgramData\MySQL\MySQL Server 5.7.
• Only the primary MySQL server must have server ID as 1.
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.
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