Loading...

Instant Application Recovery for MySQL Server

You can duplicate a source server by cloning the snapshots created during backup. This operation, referred as cloning, utilizes the cloning capability of the storage array hardware, which enables you to duplicate large servers within a short period of time. Clones can be used for multiple purposes, such as:

  • As test environments to troubleshoot issues found in the production server.
  • Quick data retrieval without running resource intensive restores on the production environment and without requiring additional space on destination server.
  • Alleviate load from the production servers for running reports and queries.

Currently, clone restore is supported on Linux platform only. A clone can be created from an existing SnapProtect or a block-level full backup job. During the clone creation, a reservation period is specified by the user. At the end of the period, the system automatically shuts down the clone server and frees up all resources, including snapshot clones on the storage array. The cloning operation can also be scheduled to run periodically to allow the clones to get refreshed from the latest backups on a regular basis.

Prerequisites

  • The MySQL server version on the destination client must be the same as the one in the source client.
  • The MySQL user in both the source and destination database servers must have the same user ID.
  • The MySQL Agent and the MediaAgent must be installed on the destination client.
  • On the destination client where you plan to create the clone database, create a directory to be used as the mount path for the database clone files. This directory must be writable by the MySQL user.
  • The Clone Working Directory should have minimum space for the cloned server.

Procedure

Use the following steps to create a clone environment from existing snapshots:

  1. From the CommCell Browser navigate to the Client Computers | client | MySQL | instance.
  2. Right-click a subclient, and then click Clone.
  3. From the Clone Options dialog box, click View Content.
  4. From the browse window, click Clone.
  5. Note: By default, the entire server is selected. You cannot select individual databases here.

    The MySQL Clone Options dialog box is displayed
  6. Under the Clone Options tab, from the Destination Client list, select a client where you want to clone the server.
  7. From the Instance Name list, you can either select an instance or <Custom> from the list.
    • Select an instance to use its Binary Directory and Unix UserName for the new clone server that you are creating.
    • Select <Custom> to type the location for Binary Directory and Unix UserName for the new clone server that you are creating.
  8. Type or select a port number that the selected instance will use for communication purpose. Verify that the selected port number is not in use.
  9. Type or browse a location for the Clone working directory. The selected instance will be cloned at this location.
  10. Specify the Reservation Period for which you would like to retain the test environment.

    By default, the clone environment will be retained for 24 hours. Once the specified reservation period expires, the clone server is dismounted and the mount point is deleted.

  11. Optional: Select the Overwrite if clone exists check box if you want to overwrite an existing clone instance that uses the same port number as the new clone that you want to create.
  12. From the Restore Time box, select a date and a time. From the Time Zone list, select the time zone of the destination client that you have selected.
  13. Click OK.

Notes:

  • If SnapProtect services are restarted on the client computer, the clone server becomes unavailable, even if the reservation period of the clone server is not over.
  • The file permissions for the staging directory must be set to 777.
  • Do not use root directory as a staging location.