Adding a MySQL Database Instance

Updated

When you need to manage a MySQL database, add an instance for the database.

When you add an instance, a default database group is automatically created. The default database group includes all the data in the MySQL database.

Note: You cannot delete the default database group.

About This Task

When you discover instances, the newly discovered instances are assigned a plan as follows:

  • If the server is installed from the Command Center, then the newly discovered instances inherit the plan of the server.

  • If the server is not installed from the Command Center, then you must set a plan for the newly discovered instances.

Procedure

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

    The Instances page appears.

  2. Click Add instance > MySQL.

    The Add MySQL instance dialog box appears.

  3. From the Server name list, select the server where you want to create the instance.

  4. In the Instance name box, type a name for the instance.

  5. From the Plan list, select a server plan.

  6. In the Database user box, type the user name to access the MySQL application.

  7. In the Password box, type the password to access the MySQL application.

  8. If you are using a Linux platform, then in the UNIX username box, type the Linux operating system user name.

  9. In the Socket file box, enter the path to the socket file.

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

  11. In the Log Data Directory box, enter the path to the directory where the log files are stored.

  12. In the Configuration file box, enter the path to the configuration file as shown in the following examples:

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

    • UNIX: /etc/my.cnf

  13. In the SSL CA file box, enter the SSL CA file path in the client computer.

  14. To enable XtraBackup or Enterprise Backup on a Linux client, move the Enable hot backup toggle key to the right.

  15. Complete one of the following steps to enable XtraBackup or Enterprise Backup:

    • To use the XtraBackup utility for backup operations, select XtraBackup, and then enter the path to the folder that contains XtraBackup binaries.

    • To run a MySQL Enterprise Backup using SBT, select Enterprise backup, and then enter the path to the MySQL utility files that are required to enable enterprise backup. To avoid locking the non-InnoDB tables, select the No lock check box.

  16. Click Add.

Note: To avoid inconsistencies in the non-InnoDB data, lock the non-InnoDB tables while running a backup operation.