Configuration for MySQL

Understanding the CommCell Console

The MySQL Server iDataAgent uses the following logical entities to manage backup and restore operations from the CommCell Console.

Agent

Facilitates MySQL instance discovery.

Instance

Defines the MySQL Server instance to be backed up.

Subclient

Defines the MySQL databases to be backed up.

Managing Instances

In the CommCell Console, each instance refers to a MySQL server. Therefore, you must create an instance for each MySQL Server that you need to back up.

This topic describes how to create an instance, and how to manage the instance once it is created.

Once the MySQL Agent is installed, you can configure MySQL instance and subclient.

Creating a New MySQL Instance

Whenever a new MySQL server is created on the client, you must add the server to the CommCell.

1. From the CommCell Browser, navigate to Client Computers | <Client>.

   Right-click MySQL, point to All Tasks, and then click New MySql Server.

2. In the Server Name box, type a name for the new MySQL instance that you are creating.

3. In the Binary Directory box, enter the path to the directory where the MySQL application files are stored.

   For example:

   Windows: C:\Program Files\MySQL\MySQL Server 8.0\bin

   Unix: /usr/bin

   Alternatively, click Browse to select the location.

4. In the Log Data Directory box, enter the directory name where the log files are stored.

   For example:

   Windows: C:\Program Files\MySQL\MySQL Server 8.0\data

   Unix: /var/lib/mysql

   Click OK.

5. In the Config File box, enter the path to the configuration file.

   For example:

   Windows: C:\Program Files\MySQL\MySQL Server 8.0\my.ini

   Unix: /etc/my.cnf

6. 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, type the path to the socket file or provide the endpoint in hostname:port format, where 'hostname' is the hostname of the client and 'port' is where mysql server is running on the client. Alternatively, click Browse to select the location for socket file.

     Note

     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.

7. On the Accounts tab, click the Credential list, and then click Create New to add a new credential.

8. In the Command Line Backup Storage Policy box, select the storage policy name.

9. In the Log Backup Storage Policy box, select the storage policy name.

10. Click OK.

Enabling Automatic Discovery of MySQL Instances

You can automatically discover the new MySQL server instances if you select the Enable Automatic Instance Discovery check box. The automatic discovery ensures that the newly added MySQL instances are regularly accounted for in backup operations.

When you discover MySQL instances, the newly discovered instances are assigned a storage policy as follows:

• If the default subclient of the file system has a storage policy, then the newly discovered instances inherit that storage policy.

• If the default subclient of the file system has no storage policy, then you must set a storage policy for the newly discovered instances.

About This Task

By default, MySQL instances are automatically discovered every 24 hours. Instances are also automatically discovered when the Communications Service (GxCVD) is restarted (for example, after a computer reboot).

Procedure

1. From the CommCell Browser, click Client Computers > client.

2. Right-click MySQL, and then click Properties.

   The MySQL Properties dialog box appears.

3. Select the Enable Automatic Instance Discovery check box.

4. Click OK.

5. After the MySQL instances are automatically discovered, if there is no default file system storage policy, follow these steps to set the default storage policy:

   1. Right-click the newly-discovered instance, and then click Properties.

      The Properties of MySql Server dialog box appears.

   2. To select the storage policies for command line backup operation and log backup operation, on the Storage Device tab, complete the following tasks:

      1. On the Command Line Backup tab, select a storage policy for command line backup operations from the list.

      2. On the Log Backup tab, select a storage policy for log backup operations from the list.

      3. Click OK.

6. Set the user account for the MySQL application at the instance level.

Creating User-Defined Subclients

By default, all databases within each MySQL Server instance are automatically assigned to the default subclient. This subclient backs up the entire instance. However, you can distribute the database content by creating user-defined subclients.

If you want to back up groups of specific databases, you can do so by creating a user-defined subclient containing any number of databases that exist within the instance. This is useful if you want to back up specific databases at certain intervals or with a particular frequency.

1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | <Instance>.

2. Right-click the instance, select All Tasks, and then click New Subclient.

3. On the General tab of the dialog box that appears, enter a name in the Subclient box.

4. Click the Storage Device tab.

5. On the Data Storage Policy sub tab, select the appropriate storage policy from the Storage Policy list.

6. Select the Content tab, and then click Configure.

7. Click Discover on the dialog box that appears.

8. For each database that you want to include, select the name of the appropriate subclient from the Subclient Name list.

9. Click OK to save the content.

10. Click OK.