# Creating an Instant Clone for MySQL

You can create a clone from an IntelliSnap backup or a block-level full backup.

## Before You Begin

- The version of database server must be the same on both the source client and the destination client.

- The database user must have the same user ID on both the source database server and the destination database server.

- The Commvault package and the MediaAgent must be installed on the destination client.

- On the destination client, create a working directory to use as the mount path for the database clone files. This directory must be writable by the database user.

- The working directory must have enough space for the cloned server.

- The file permissions for the clone working directory must be set to 777.

- Do not use root directory as a clone working directory.

- Free space required for staging logs depends on the total application size of the relevant log backups. For example, if there are five transaction log backups in the backup cycle selected to restore, add up the application size for all five log backups to find the free space needed.

## Procedure

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

   The database Overview tab appears.

2. On the Instant clones tab, from the top-right corner of the page, click Instant clone .

   The Select database type page appears.

3. Click MySQL and select Next.

   The Add MySQL instant clone dialog box appears.

4. Under Source details section, enter the following details:

   1. From the Source server list, select the client that contains the instance that you want to clone.

   2. From the Source instance list, select the instance that you want to clone.

5. Under the Destination details section, enter the following details:

   1. From the Destination server list, select the client where you want to clone the server.

   2. For the Instance name list, specify the binary directory and database user for the clone:

      - To use the binary directory and the database user of an existing instance for the clone server, select the instance.

      - To specify the location for the binary directory and the database user for the clone server, select Custom.

   3. For the Recover to list, specify the backup to recover:

      - To recover the most recent backup operation, select Most recent backup.

      - To recover a specific backup, select Point in time, and then enter the date and time the backup ran.

6. Under the Destination options section, enter the following details:

   1. In the Clone working directory box, enter the location to create the clone in.

   2. In the Binary directory box, enter the path of the binary directory.

   3. In the Database user box, enter the name of the database user.

   4. In the Port box, enter the port that you want the source instance to use.

      Verify that the port is not in use.

7. Under the Clone options section, enter the following details:

   1. Specify the time period to retain the clone for.

   2. After the time period expires, the clone server is dismounted and the mount point is deleted. By default, the clone is retained for 24 hours.

   3. To overwrite an existing clone instance that uses the same port number as the clone that you want to create, select the Overwrite if already exists check box.

8. Under the Advanced options section, enter the following details:

   1. In the Command file path box, enter the path of the command file.

9. Click Submit.

## Results

- If Commvault services are restarted on the client computer, the clone server becomes unavailable, even if the reservation period of the clone server is not over.

×

Loading...