Creating a New MySQL Server Instance
Whenever a new MySQL server is created on the client, you must add the server to the CommCell. To create a MySQL instance, the MySQL user should have DBA and SYSDBA privileges.
- From the CommCell Browser, navigate to Client Computers | <Client>.
Right-click MySQL, point to All Tasks, and then click New MySql Server.
- In the Server Name box, enter the MySQL server name.
- In the SA User Name box, enter the MySQL administrator user name.
In the Account Password box, enter the account password for the administrator user account.
In the Confirm Password box, reenter the password.
- In the Binary Directory box, enter the path to the directory where the MySQL application files are stored.
For example: /usr/bin
- In the Log Data Directory box, enter the directory name where the log files are stored.
For example: /var/lib/mysql
- In the Config File box, enter the path to the configuration file.
For example: /etc/my.cnf
- Depending on which platform you use, enter the TCP/IP port number or the pathname to the socket file.
- For Windows, enter the TCP/IP port number into the Port box to open the communication between MySQL server and clients.
- For Unix, enter the pathname to the socket file in the Socket File box.
If you have multiple instances installed on the client computer, make sure that the Binary Directory, Log Data Directory, and the Config File locations, and the Port number or Socket file path are different for each instance that you want to back up.
- In the Log Backup Storage Policy box, select the storage policy name.
- Click OK.
Last modified: 6/5/2019 6:08:56 AM