Configuration for MySQL

Once the MySQL Agent is installed, configure the MySQL Server and subclient as follows:

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.

   Ensure that the instance name that you type is unique. There should not be any other MySQL instance with the same name in that client.

3. Perform one of the following steps, depending on the operating system that you are using

   • For Windows, to enter the NT UserName, click Change.

     The User name and password dialog box appears.

     Enter the user name and password. Click OK.

   • For UNIX, in the Unix UserName box, type the Linux operating system user name.

4. In the SA User Name box:

   • For Windows, to enter the MySQL user name, click Change. Enter the user name and password. Click OK.

   • For UNIX, to enter the MySQL user name, click Change. Enter the user name and password. Click OK.

     Note

     Following are the prerequisites to run backup and restore as a MySQL user, and not as an administrator or a root user:

     • For Windows, type the user name as MySQL during instance creation.

     • For UNIX, MySQL user should be a part of the Commvault group.

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

   For example:

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

   UNIX: /usr/bin

   Alternatively, click Browse to select the location.

6. In the Log Data Directory box, type the directory name where the log files are stored.

   For example:

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

   UNIX: /var/lib/mysql

   Alternatively, click Browse to select the location.

7. In the Config File box, type the path to the configuration file.

   For example:

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

   UNIX: /etc/my.cnf

   Alternatively, click Browse to select the location.

8. For Windows, select the TCP/IP port number 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.

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

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

10. Click OK.

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

    Right-click the default Subclient, and then click Properties.

12. Click the Storage Device tab.

    • In the Storage Policy box, select the storage policy.

    • Click OK.

    Proceed to the next page.

    If you do not have Storage Policy created, follow the step given below to create a storage policy.

13. Perform the following steps to create a storage policy.

    1. Click Create Storage Policy.

    2. Follow the prompts displayed in the Storage Policy Wizard. The required options are mentioned below:

       1. Select the Storage Policy type as Data Protection and Archiving and click Next.

       2. Enter the name in the Storage Policy Name box and click Next.

       3. From the Library list, click the name of a disk library to which the primary copy should be associated and then click Next.

          Ensure that you select a library attached to a MediaAgent operating in the current release.

       4. From the MediaAgent list, click the name of a MediaAgent that will be used to create the primary copy and then click Next.

       5. For the device streams and the retention criteria information, click Next to accept default values.

       6. Select Yes to enable deduplication for the primary copy.

       7. From the MediaAgent list, click the name of the MediaAgent that will be used to host the Deduplication database (DDB).

          In the Location box, type the name of the folder in which the DDB must be located or click the Browse to select the folder, and then click Next.

       8. Review the details and click Finish to create the Storage Policy.