Creating an Instant Clone for MySQL

Updated

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

Before You Begin

  • The version of MySQL server must be the same on both the source client and the destination client.

  • The MySQL 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 MySQL 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 navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. On the Instant clones tab, click Instant clone.

    The Instant clone page appears.

  3. Click MySQL.

    The Instant clone dialog box appears.

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

  5. From the Instance name list, select the instance that you want to clone.

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

  7. 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.

  8. In the Recover options section, 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.

  9. In the Destination options section, enter the directory and port information:

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

    2. Enter the port that you want the source instance to use.

      Verify that the port is not in use.

  10. In the Clone options section, specify the time period to retain the clone for.

    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.

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

  12. To run a script after the clone is created, in the Post clone operation section, enter the path to the script.

  13. Click OK.

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.