Instances - MySQL - How To

Topics | How To | Related Topics

Create an Instance

Modify an Instance

Delete an Instance

Change the Home Directory

Change the Archive Log Index File

Change the Configuration File

Change the Socket File

Change Account for Accessing Instances

Select a Storage Policy for Log Backups

Create an Instance

You must create a MySQL instance for each MySQL server that you want to back up. Ensure that you have a user account with full DBA and SYSDBA privileges to create a new instance.

Use the following steps to create a new instance on an Unix client:

From the CommCell Browser, navigate to Client Computers | <Client> | MySQL Server. Right-click MySQL Server, point to All Tasks and then click New MySql Server. In the Server Name box, type the name of the MYSQL Server instance that you want to assign to this instance. In the SA User Name box, type the user name that you used to create an instance. In the SA Account Password box, type the password that you want to assign to this instance. In the SA Confirm Password box, type the password again to confirm the assigned password to this instance. In the Binary Directory box, enter the path or click Browse to select the directory where the mysql binaries are stored. In the Log Data Directory box, enter the path or click Browse to select the directory where the log files are stored. In the Config File box, enter the path or click Browse to select the directory where the configuration (.cnf) file exist. In the Socket File box, enter the path or click Browse to select the directory where the socket file exist.   If you have a multiple instances installed on the client computer, make sure that the Binary Directory, Log Data Directory, Config File and Socket File locations are different for each instance that you want to backup. Select a storage policy from the Log Backup Storage Policy drop down list. Click OK.

Use the following steps to create a new instance on a Windows client:

From the CommCell Browser, navigate to Client Computers | <Client> | MySQL Server. Right-click MySQL Server, point to All Tasks and then click  New MySql Server. In the Server Name box, type the name of the MySQL Server instance that you want to assign to this instance. In the SA User Name box, type the user name that you used to create an instance. In the SA Account Password box, type the password that you want to assign to this instance. In the SA Confirm Password box, type the password again to confirm the assigned password to this instance. In the Binary Directory box, enter the path or click Browse to select the directory where the mysql binaries are stored. In the Log Data Directory box, enter the path or click Browse to select the directory where the log files are stored. In the Config File box, enter the path or click Browse to select the directory where the configuration (.cnf) file exist. In the Port box, type or select the TCP/IP port number to open the communication between MySQL server and clients.   If you have a multiple instances installed on the client computer, make sure that the Binary Directory, Log Data Directory, Config File locations and Port number are different for each instance that you want to backup. Select a storage policy from the Log Backup Storage Policy drop down list. Click OK.

Modify an Instance

Required Capability: See Capabilities and Required Actions

To modify an Instance

1. From the CommCell Browser, right-click the instance you want to modify, and then click Properties from the shortcut menu.
2. Click the General tab of the Instance properties box to change the required access information for this instance.
3. For MySQL iDataAgent, use this Accounts tab to specify the MySQL Server user account.
4. If your agent uses the Restore View Names tab, use this tab to enter or modify a list of text patterns for the view through which the system displays a database's data documents when you browse.
5. If your agent has the Security tab, you can view CommCell resource associations to enable or disable user groups that can perform system operations on associated resources.
6. Click the Details tab, and type or select values for the fields at the bottom of the dialog box as appropriate.
7. From the Storage Device tab(s), select the storage policy for the log backups from the Log Backups tab.
8. If your agent uses the Software Compression tab, and you want to enable software compression for the selected backups, click the tab and select the appropriate option.
9. If you want to enable data encryption, from the Encryption tab select encryption settings for third-party or RMAN command line backups.
10. Click OK to save the configuration changes.
11. A message advises you to schedule backups for your new instance. It is recommended you elect to set a schedule now. If you click No, this procedure is now complete. If you click Yes, a dialog box prompts you to back up all subclients of this instance.
12. Click Yes. The Backup Options dialog box appears, which allows you to create the necessary schedules.
13. From the Backup Options dialog box, select the type of backup that you want to schedule.
14. If you want to access Advanced Backup Options, click Advanced.
15. After selecting the backup type and any advanced options, click OK. The Schedule Details dialog box appears.
16. From the Schedule Details tab of the Schedule Details dialog box, select the scheduling options that you want to apply, then click OK.

Delete an Instance

Before You Begin

• For most agents except Oracle and SQL Server, you cannot delete an instance if there is only one instance present for an agent. To delete the final instance for most agents except the ones identified, you must first remove the agent software from the client computer. For Oracle RAC, which does not involve agent software, you can delete the instance under the RAC pseudo-client.
• When you delete a specific instance positioned in the level below the corresponding agent or pseudo-client in the CommCell Console, the following actions occur:
  • The corresponding backup data for that instance becomes immediately unavailable, thus making it inaccessible for restore purposes. In effect, the backup data is deleted.
  • All child levels contained within the level are deleted in the CommCell Browser.
  • All job schedules and job histories that pertain to any of the levels within the deleted instance are deleted.
• If you delete an Oracle iDataAgent instance included within an Oracle RAC instance (node), the backup data is not deleted, and it is available for restore by another eligible client.
• You cannot delete an instance if it is being backed up. Attempts to delete an instance under such conditions cause the deletion to fail. If a backup is in progress, either wait for the backup to complete or kill the backup job using the Job Manager. Once the backup is no longer in progress, you can delete the instance level.

Required Capability: See Capabilities and Required Actions

To delete an instance positioned in the level below the corresponding agent or pseudo-client

1. From the CommCell Browser, right-click the instance that you want to delete, click All Tasks and then click Delete.
2. Click Yes to confirm the deletion. (Clicking No cancels the deletion and retains the node.)
3. Type the requested phrase in the Enter Confirmation Text dialog box and click OK. This should delete the instance.

To delete an Oracle iDataAgent instance included within an Oracle RAC instance (node)

1. Right-click the Oracle RAC instance, click Properties, and click Details.
2. Click the instance that you want to delete within Client/Instance/Status and click Delete.
3. Repeat the previous step for each Oracle iDataAgent instance (except the last one remaining) within the Oracle RAC instance that you want to delete.
4. Click OK. This should delete the Oracle iDataAgent instance(s).

Change the Home Directory

Required Capability: See Capabilities and Required Actions

To change the Home Directory:

1. From the CommCell Browser, right-click the icon for any supported instance and then click Properties.
2. For agents other than Oracle RAC, from the General tab of the Properties dialog box, type the path in the Home or Dir (Directory) box or use Browse to locate the path. Then go to Step 6.
3. For the MySQL iDataAgent, from the General tab of the Properties dialog box, type the path in the Binary Directory box or use Browse to locate the path. Also, type the path to the MySQL data directory in the Data Directory box or use Browse to locate the path. Then go to Step 6.
4. For Oracle RAC, from the Details tab of the Properties dialog box, click the appropriate client/instance/status and then click Modify.
5. In the Update Instance dialog box, enter the path in the Home box or use Browse to locate the path.
6. Click OK to save your settings.
7. Continue to make additional settings as desired.

Change the Archive Log Index File

Required Capability: See Capabilities and Required Actions

To change the Archive Log Index file:

1. From the CommCell Browser, right-click the icon for any supported instance and then click Properties.
2. From the General tab of the Properties dialog box, enter the path for the archive index file in the Archive Log Index File field or use Browse to locate the path.
3. Click OK to save your settings.

Change the Configuration File

Required Capability: See Capabilities and Required Actions

To change the configuration file:

1. From the CommCell Browser, right-click the icon for any supported instance and then click Properties.
2. From the General tab of the Properties dialog box, enter the path for the configuration file in the Config File field or use Browse to locate the path.
3. Click OK to save your settings.

Change the Socket File

Required Capability: See Capabilities and Required Actions

To change the Archive Log Index file:

1. From the CommCell Browser, right-click the icon for any supported instance and then click Properties.
2. From the General tab of the Properties dialog box, enter the path for the archive index file in the Socket File field or use Browse to locate the path.
3. Click OK to save your settings.

Change Account for Accessing Instances

Required Capability: See Capabilities and Permitted Actions

To change a user account for accessing an instance:

1. From the CommCell Browser, expand the tree to view the instance for the affected agent. Then right-click the instance, click Properties, and click Accounts.
2. In the Instance Properties (Accounts) tab, enter the MySQL Server user account information.
3. Click OK to save the settings.

Select a Storage Policy for Log Backups

Required Capability: See Capabilities and Required Actions

To select a Storage Policy for Log Backups:

1. From the CommCell Browser, right-click the icon for any supported instance and then click Properties.
2. From the Log Backups tab of the Properties dialog box, select from the list of available storage policies.
3. Click OK to save your settings.

Back to Top