Creating and Managing Snapshots

This topic does not apply to Oracle Cloud Infrastructure.

MySQL Cloud Service supports the creation of snapshots, which you can then use to create new database deployments called linked clones.

When you create a storage snapshot, the database deployment is put into maintenance status and a snapshot of all the storage for the deployment is taken. Then, when you create a linked clone deployment, MySQL Cloud Service creates a new database deployment whose storage volumes are from the snapshot.

Using the “copy on write” technology that Oracle Compute Cloud Service supports for storage volume snapshots, the file data on the linked clone deployment can change without changing the snapshot itself. Thus, you can create several linked clones from the same snapshot to use for application testing or branched application development work.

The following are the tasks for creating and managing snapshots:

• Creating a Snapshot

• Listing Cloned Services Created from a Snapshot

• Deleting a Cloned Service

• Deleting a Snapshot

Creating a Snapshot

1. Go to the Snapshots page of the deployment you want to create a snapshot of:

   1. Open the MySQL Cloud Service console.

   2. Click the name of the deployment you want to create a snapshot of.

      The MySQL Cloud Service Overview page is displayed.

   3. Select the Administration tile, then click the Snapshots tab.

      The Snapshots page is displayed. Any snapshots already created for the deployment are shown in the Available Storage Snapshots list.

2. Click Create. In the Create Storage Snapshot window that is displayed, enter a name (and, optionally, a description) for the snapshot and then click Create.

   In the next window that is displayed, confirm that you want to put the database deployment into maintenance mode and create the snapshot by clicking Create.

Listing Cloned Services Created from a Snapshot

1. Open the MySQL Cloud Service console.

2. Click the name of the deployment whose snapshot you want to see linked clone deployments of.

   The MySQL Cloud Service Overview page is displayed.

3. Click the Administration tile and then click the Snapshots tab.

   The MySQL Cloud Service Snapshots page is displayed.

4. In the Available Snapshots list, locate the snapshot you are interested in and check the value displayed next to Linked Clones.

   If the value is zero, no linked clone deployments have been created from the snapshot. Otherwise, click expand to view the list of cloned services.

   When viewing the list of clones, you can click the name of a cloned service to go directly to that service’s Overview page.

Deleting a Cloned Service

1. Open the MySQL Cloud Service console.

2. Locate the snapshot clone you want to delete and choose Delete from that snapshot clone’s action menu.

3. In the Delete Service window, confirm that you want to delete the clone database deployment by clicking Delete.

   Once deleted, the associated entry is removed from the list of database deployments displayed in the MySQL Cloud Service console.

Deleting a Snapshot

Note:

You cannot delete a snapshot that has cloned services created from it. You must first delete the associated clone service, as described in Deleting a Cloned Service.

1. Open the MySQL Cloud Service console.

2. Click the name of the deployment whose snapshot you want to delete.

   The MySQL Cloud Service Overview page is displayed.

3. Click the Administration tile and then click the Snapshots tab.

   The MySQL Cloud Service Snapshots page is displayed.

4. In the Available Storage Snapshots list, locate the snapshot you want to delete and choose Delete from that snapshot’s action menu.

5. In the Delete Storage Snapshot window, confirm that you want to delete the snapshot by clicking Delete.

   If the window warns you that you cannot delete the snapshot because there are database deployments cloned from it, click Close and then delete the linked clone deployments before trying to delete the snapshot.