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 53. Bootstrap server address
Create database and users on MySQL InnoDB server
You must create the database and user accounts with administrator privileges on MySQL InnoDB server.
To create database on MySQL InnoDB server, run the following SQL commands:
Create Database stratus DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;
CREATE USER 'STRATUS'@'LOCALHOST';
CREATE USER 'STRATUS'@'IP ADDRESS';
SET PASSWORD FOR 'STRATUS'@'LOCALHOST' = PASSWORD <db_password>;
SET PASSWORD FOR 'STRATUS'@ <IP_Address> = PASSWORD <db_password>;
GRANT ALL PRIVILEGES ON *.* TO 'STRATUS'@<IP_Address> IDENTIFIED BY <db_password> WITH GRANT
OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'STRATUS'@'LOCALHOST' IDENTIFIED BY <db_password> WITH GRANT
OPTION;
NOTE
: Instead of IP Address, you can type the Wildcard for Network /Subnet or Multiple Single host entry where Wyse
Management Suite application server will be installed.
58 Achieve high availability for MySQL InnoDB