Subclients - MySQL - How To

Topics | How To | Related Topics


Associate a Subclient to a Storage Policy

Configure a Subclient for Pre/Post Processing of Data Protection Operations

Configure Subclient Content

Configure MySQL Databases

Configure the Subclient for Data Encryption

Create a New Subclient

Delete a User-Defined Subclient

Enable or Disable Operations

Enable Software Compression for a Subclient

Remove a Process from Pre/Post Processing of Data Protection Operations

Rename a Subclient

View Data Paths Associated with a Subclient


Associate a Subclient to a Storage Policy

Required Capability: See Capabilities and Permitted Actions

To associate a subclient to a storage policy:

  1. From the CommCell Browser, right-click the subclient whose associated storage policy you want to change, then click Properties from the shortcut menu.
  2. Click the Storage Device tab of the Subclient Properties dialog box.
  3. From the Storage Policy list of the Data Storage Policy tab, select a data storage policy to associate with this subclient. If necessary, click the Create Storage Policy button to create a new storage policy to which the subclient can then be associated.
  4. From the Changing a Storage Policy window select the next type of backup operation. Click OK.
  5. If applicable for your agent, you can change the number of data streams from the Number of Data/Database Backup Streams field.
  6. If applicable for your agent, click the Log Storage Policy tab and select a storage policy to associate with this transaction log subclient from the Transaction Log Storage Policy list. Also, you can set the Number of Transaction Log Backup Streams from this tab.
  7. Click OK to save your changes and close the Subclient Properties Storage Device tab.

Configure a Subclient for Pre/Post Processing of Data Protection/Archive Operations

Before You Begin

Required Capability: Capabilities and Permitted Actions

To configure a subclient for Pre/Post processing of data protection/archive operations:

  1. From the CommCell Browser, right-click the subclient for which you want to configure a pre/post process, and then click Properties from the shortcut menu.
  2. Click the Pre/Post Process tab of the Properties dialog box.
  3. For an agent other than the Oracle RAC iDataAgent, click inside the space that corresponds to one of the following phases and type the full path of the process that you want executed during that phase. Alternatively, click Browse to locate the process (applicable only for paths that do not contain any spaces). For the Oracle RAC iDataAgent, click Browse for the corresponding process, click the name of the control node client in the Select Client for Browse dialog box, and click OK. Then browse for and click the process.

    Click OK.

  4. If you want to run a Post Process for all attempts to run that job phase, then select the corresponding checkbox.
  5. For subclients on Windows platforms, if Run As displays Not Selected, or if you want to change the account that has permission to run these commands, click Change.
    1. In the User Account dialog box, select Use Local System Account, or select Impersonate User and enter a user name and password. Click OK.
    2. If you selected Local System Account, click OK to the message advising you that commands using this account have rights to access all data on the client computer.
  6. Click OK to save your changes and close the Pre/Post Process tab of the Properties dialog box.

Configure Subclient Content

Before You Begin

Required Capability: See Capabilities and Permitted Actions

wedge.gif (136 bytes)To configure subclient content:

  1. From the CommCell Browser, right-click the subclient for which you want to configure content, click All Tasks (if applicable) and then click Properties.
  2. Follow the procedure below that is applicable for your agent:
  3. Click OK to save your content configuration.

NOTES


Configure MySQL Databases

Related Topics:

Required Capability: See Capabilities and Permitted Actions

To configure databases:

  1. From the CommCell Browser, if you are creating a new subclient, start to create the subclient and then click the Content tab from the Subclient dialog box. Otherwise, right-click the subclient whose content you want to configure, click Properties, and then click the Content tab from the Subclient dialog box.
  2. For an existing subclient, check the current subclient content in the Content tab. If you want to delete any database(s) from the subclient content, select the database(s) and then click Delete.
  3. Click Configure.
  4. If the Database Configuration dialog box is blank, or to discover new database elements, click Discover.
  5. In the Database configuration dialog box, check whether each database is associated to the desired subclient. If not, to change the subclient association for the database, click the current associated subclient and then select the appropriate subclient from the list. Optionally, to associate more than one database to the same subclient, select the appropriate databases and then use the Change all selected storage groups to list to select the common subclient.
  6. Click OK. The Subclient dialog box should display the desired subclient contents.
  7. Make any other desired or required changes and then click OK.

Configure the Subclient for Data Encryption

Encryption settings made at the subclient level are for data protection and recovery operations run from the CommCell Console and are not related in any way to settings made at the instance level which is for third-party Command Line operations only.

See Data Encryption - Support for a list of supported products.

Before You Begin

Required Capability: Capabilities and Permitted Actions

To configure the subclient for data encryption:

  1. From the CommCell Console, right-click the subclient and click Properties.
  2. From the Subclient Properties (Encryption) tab, select an option based on the criteria described in the Encryption tab help.
  3. Click OK to save your settings and close subclient properties.

Create a New Subclient

Before You Begin

Required Capability: See Capabilities and Permitted Actions

To create a new subclient:

  1. From the CommCell Browser, right-click the node (agent/backup set/archive set/instance) for which you want to create a new subclient, click All Tasks (if applicable), and then simply click New Subclient for most agents.
  2. Click the General tab or General (Quick Recovery Agent) tab of the Subclient Properties dialog box and type the name (up to 32 characters) of the subclient that you want to create.
  3. Select other options from the General tab as appropriate for the agent.
  4. Click the Content or Databases tab of the Subclient Properties dialog box and Configure Subclient Content as appropriate for your agent.
  5. For all agents (except QR), click the Storage Device (Data Storage Policy) tab of the Subclient Properties dialog box, then select a data storage policy to associate with this subclient from the storage policy list.
  6. For Oracle and DB2 iDataAgents, click the Backup Arguments (Oracle) or Backup Arguments (DB2, DB2 DPF) tab of the Subclient Properties dialog box and Configure Backup Arguments as appropriate for your agent. Note that the backup arguments for Informix are located on the Content tab.
  7. For Migration Archiver Agents, click the Archiving Rules or Rules tab of the Subclient Properties dialog box and configure archiving rules as appropriate for your agent. In order to perform rules-based migration archiving operations, the Disable All Rules checkbox must be cleared.

    If the File Archiver for Windows supports Data Classification, several filter-like configuration fields are defined as archiving rules and are available from the Subclient Properties (Rules) tab. If you want to define content and archiving rules based on file attributes other than volumes, size, and modified time (i.e., if you want to customize your rules), click the Advanced tab and configure as appropriate. Also, stub management options can be configured from the Stub Rule tab. See Configure Archiving Rules - File Archiver Agents for step-by-step instructions.

  8. For ProxyHost and Image Level ProxyHost iDataAgents, click the Pre/Post Process tab of the Subclient Properties dialog box. In the PreScan field, type the path to the batch file/shell script file that contains those commands that are to run before each backup of the subclient, or click Browse to locate and select this file. For ProxyHost and Image Level ProxyHost, the file must reside on the backup host or primary host.
  9. Optionally (if supported for your agent) you can:
  10. Click OK to save the subclient configuration. For QR Agents, this procedure is now complete. For all other agents, continue on to the next step.
  11. The Backup Schedule dialog box advises you to schedule data protection operations for your new subclient. It is recommended you elect to set a schedule now. You can also associate this subclient with an All Agent Types schedule policy (which is automatically created by the system, or can be a user defined Data Protection schedule policy). If you have already associated a schedule policy at a previous level (Backup Set/Instance, Agent, Client, or Client Computer Group) the schedules defined in the Schedule Policy will be automatically applied to the new subclient. See Schedule Policy for more information.

This task is now complete.


Delete a User-Defined Subclient

Related Topics:

Required Capability: See Capabilities and Permitted Actions

wedge.gif (136 bytes)To delete a user-defined subclient:

  1. From the CommCell Browser, right-click the user-defined subclient that you want to delete, and then click Delete from the shortcut menu.
  2. A confirmation message is displayed, asking if you want to delete the subclient.
    Click No to cancel the deletion and retain the subclient, or click Yes to continue the deletion. If you click Yes:

Enable or Disable Operations

Required Capability: See Capabilities and Permitted Actions

Level Capability
CommCell Administrative Management with CommCell level association
Client Computer Group Administrative Management with Client Computer Group level association
Client Agent Management with Client level association
Agent Agent Management with Agent level association
Subclient Agent Management with Subclient level association

To enable or disable activity control at the CommCell, client computer group, client, agent, or subclient levels:

  1. From the CommCell Browser, right-click the CommServe, client computer group, client computer, agent, or subclient, and then click Properties from the short-cut menu.
  2. From the Activity Control tab of the associated Properties dialog box, select or clear option(s), as desired.
  3. Click OK.
note.gif (292 bytes) Disabled data management and/or data recovery operations are displayed with client and/or agent icon changes in the CommCell Browser. For a comprehensive list of all icons in the CommCell Console, see CommCell Console Icons.

Enable or Disable Software Compression for a Subclient

Before you Begin

Required Capability: Capabilities and Permitted Actions

To enable software compression for a subclient:

  1. From the CommCell Browser, right-click the subclient for which you wish to enable software compression and then click Properties.
  2. Click the Storage Device tab and from the Data Storage Policy tab, select the storage policy from the Storage Policy list.

    If applicable for the selected agent, click the Log Storage Policy tab and select a storage policy from the Transaction Log Storage Policy list.

  3. Then click the Storage Device (Data Transfer Option) tab and choose the appropriate compression option for this subclient.
  4. Click OK to save your changes.

This task is now complete.


Remove a Process from Pre/Post Processing of Data Protection/Archive Operations

Before You Begin

Required Capability: Capabilities and Permitted Actions

To remove a process from Pre/Post processing of data protection/archive operations:

  1. From the CommCell Browser, right-click the subclient for which you want to remove a pre/post process, and then click Properties from the shortcut menu.
  2. Click the Pre/Post Process tab of the Subclient Properties dialog box.
  3. Click the text inside the space that corresponds to one of the following phases for which you want a pre/post process removed, then press the Delete key:
  4. Repeat Step 3 for any additional processes that you want to remove.
  5. Click OK.

Rename a Subclient

Before You Begin

Required Capability: See Capabilities and Permitted Actions

wedge.gif (136 bytes)To rename a subclient:

  1. From the CommCell Browser, right-click the subclient that you want to rename, and then click Properties from the shortcut menu.
  2. From the Subclient Properties (General) tab, or the QR Agent Subclient Properties (General) tab, type the new name in the Subclient Name field, and then click OK.

The CommCell Browser updates the subclient with its new name. The new name will also be reflected in any associated schedules and reports.


View Data Paths Associated with a Subclient

Required Capability: See Capabilities and Permitted Actions

To view data paths:

  1. From the CommCell Browser, right-click the subclient whose data paths you want to view, then click Properties from the shortcut menu.
  2. Click the Storage Device tab of the Subclient Properties dialog box.
  3. From the Data [or Logs] Storage Policy tab, click Show Data Paths to view the data paths used by the subclient to access the storage media for data protection operations. Click Close to exit the Data Paths dialog box.
  4. Click OK to exit the Subclient Properties Storage Device tab.