Configuration - MySQL iDataAgent

Once the MySQL iDataAgent 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. In the SA User Name box, type the MySQL administrator user name.

    In the Account Password box, type the account password for the administrator user account.

    In the Confirm Password box, retype the password.

  4. 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.

  5. 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.

  6. 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.

  7. 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. Alternatively, click Browse to select the location.

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

    Click OK.

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

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

  10. 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.

  11. 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.