Adding a MySQL Database Server

You can add a new database server so that you can protect MySQL databases.

Procedure

1. From the navigation pane, go to Protect > Databases.

   The database Overview tab appears.

2. From top-right corner of the page, click Add server.

   The Configure Database Server page appears.

3. Select MySQL and click Next.

4. In the Add Database Server section, click Add.

   The Add database server dialog box appears.

5. In the Host name box, enter the host name of the database.

6. Select an OS type from the following:

   • Unix

   • Windows

     Note

     Unix is selected by default.

7. To connect to the server using saved credentials, move the Use saved credentials toggle key to the right, and enter the following credentials:

   1. In the Username and Password boxes, enter the credentials to connect to the server.

      For a Windows server, enter the username as domain_nameusername.

   2. To grant write access to a UNIX group, such as the dba group, in the UNIX group box, enter the name of the group to give permissions to.

8. If you do not move Use saved credentials toggle to right, from Credential list, you can select a saved credential or add a new credential.

   Steps to add a credential

   1. Click +.

      The Add Credential dialog box appears.

   2. In the Account type box, the Linux account is selected by default.

   3. From the Credential Vault list, select a credential vault to store, share, and update account credentials with shared resources in your environment.

   4. In the Credential name box, enter a unique name to access the credential.

   5. In the User account box, enter the user account that has access to the MySQL server.

   6. In the Password/Passphrase box, enter the password for the user account.

   7. In the Description box, enter a brief description for the credential.

   8. Click SAVE.

   Note

   If you select OS as Windows.

   • From Credential list, select a saved credential or add a new credential.

   • Click SAVE.

9. To grant write access to a UNIX group, such as the dba group, in the UNIX group box, enter the name of the group.

10. In the SSH port number box, enter the port number.

11. To use an SSH key, do the following:

    • Move the Use SSH key toggle key to the right.

    • In the SSH key path box, enter the path for the SSH key. Alternatively, you can click SELECT FILE button to define a path.

12. To use a passphrase for the SSH key, do the following:

    • Move the Use SSH key file passphrase toggle key to the right.

    • In the Passphrase box, enter the passphrase for the SSH key.

13. In the Advanced options section, enter the following details:

    • Installation path: Define the installation path of the server.

    • Index Cache: Define an index cache for the server.

      Note

      It is recommended that the index cache folder must have a free space of at least 400GB.

    • Log file path: Define a log file storage path.

14. Click SAVE.

Results

• Installs the appropriate Commvault software packages on the server.

• Discovers the database instances, and adds them to the Commvault software.

• Creates the appropriate subclients for the instance.