Configuring a Subclient for Block-Level Backups of MySQL Databases

By default, block-level backups and restores are performed using the native snap engines.

You can configure a default subclient or create a new user-defined subclient to protect your MySQL instance.

When you run a block-level backup operation, the IntelliSnap takes the snapshot of the entire volume, even if other subclients are not IntelliSnap enabled. Therefore, we recommend you to create a single subclient in the volume.

About This Task

• For Linux LVM snaps, there must be adequate free space in the LVM volume group for snapshot creation. The default COW cache size is 4096 MB which might be insufficient for large volumes. You must set it to 5% of the volume size to avoid snapshot failures. To increase the COW cache size, add the nSnapCowSizeMB additional setting. For instructions on adding the additional setting, see Add or Modify an Additional Setting.

• For CVBF snaps, the COW files are created in the software_install_path/CVBF/cache directory, by default. Over time, the COW files can grow significantly and fill up the volume. To move the COW files to another volume, add the sCVBFSNAPPART additional setting. For instructions on adding the additional setting, see Add or Modify an Additional Setting.

Before You Begin

Check whether you have completed the following tasks:

1. Create a storage policy.

2. Create a snapshot copy for a storage policy.

3. Enable spool copy on the snapshot copy.

4. You must have a MediaAgent installed on the MySQL client to perform block-level backups.

Procedure

1. From the CommCell Browser, choose whether to configure the default subclient or to set up a user-defined subclient:

   • To configure the default subclient of MySQL:

     1. Expand Client Computers > Client > MySQL > Instance.

     2. Right-click the default subclient and then click Properties.

   • To set up a user-defined subclient of MySQL:

     1. Expand Client Computers > Client > MySQL.

     2. Right-click the instance, point to All Tasks, and then click New Subclient.

2. On the General tab, in the Subclient box, type a name for the subclient.

3. On the Storage Device tab, from the Storage Policy list, select an appropriate storage policy.

4. To set up your block-level backup, on the Advanced Backup Options tab, select Use Volume Copy.

5. Select additional options as appropriate and then click OK.