Instances - MySQL

Overview

As MySQL instances reference a MySQL server, you must create a MySQL instance for each of the MySQL servers that you want to back up. In order to create a MySQL instance, the MySQL User should have DBA and SYSDBA privileges.

See Instances for an overview of Instances. Given below is a list of what you need to provide before creating a MySQL instance.

A name for the MySQL server instance
The MySQL User account which will be used to perform all system operations
The path to the MySQL server Home directory. For example, /usr/bin.
The path to the Log File index file. For example, /var/lib/mysql/mysql_bin.index.
The path of the configuration file for the instance. For example, /etc/my.cnf.
The path to the socket file For example, /var/lib/mysql/mysql.sock.

Configurable Properties

Once installed, the agent is configured and is therefore able to manage the data or volumes on the client computer. However, you can change certain aspects of the instance configuration to manage the data in the manner that best suits your needs.

You can view or change the instance configuration from the Instance Properties dialog box. The following information can be configured.

Enable Automatic Discovery of Databases

For the MySQL iDataAgent, you can assign the system to search the instance for unconfigured databases and add them to the system. See Modify an Instance for step-by-step instructions.

Change the Designated Home Directory

For the Oracle, Oracle RAC, and SAP for Oracle iDataAgents, you can change the Oracle Home directory. Similarly, you can change the Informix (Home) directory for the Informix iDataAgent, the Sybase Home directory for the Sybase iDataAgent, the MySQL Home directory for the MySQL iDataAgent, and the Instance Home directory for the DB2 DPF pseudo-client.

See Change the Home Directory for step-by-step instructions.

Change the Archive Log Index File

For the MySQL iDataAgent, you can change the path of the archive log index file for the instance. See Change the Archive Log Index File for step-by-step instructions. You can specify the log staging location by enabling the sLogStagingPath Registry Key.

Change the Configuration File

You can change the path of the configuration file for the instance. See Change the Configuration File for step-by-step instructions.

Change the Socket File

For the MySQL iDataAgent, you can change the path of the socket file for the instance. See Change the Socket File for step-by-step instructions.

User Accounts

Use the Accounts tab to identify the account that the system uses to access the associated instance.

See MySQL iDataAgent section in User Accounts and Passwords for more information.

For step-by-step instructions on changing the user accounts for the instance, see Change Account for Accessing Instances.

View and Change Instance-level Storage Policies

From the Log Backups tab, you can change the storage policy for backing up the logs on the selected instance. (See Storage Policies for an overview.) For step-by-step instructions, see Select a Storage Policy for Log Backups.

User Security

You can perform the following functions:

Identify the user groups to which this CommCell object is associated.
Associate this object with a user group.
Disassociate this object from a user group.

For more information, see User Administration and Security.