Working with snapshots in Cloudera Operational Database

Know how to take and manage snapshots of the HBase tables in your Cloudera Operational Database.

The Cloudera Operational Database enables you to take a point-in-time copy of an HBase table with little performance impact on HBase. Creating and restoring snapshots does not copy any data; therefore, the effect is minimal.

Data backup and restore operations are important for your Cloudera Operational Database to support data recovery. In addition to Cloudera Operational Database, you can also use the CDP CLI, which offers multiple commands that help you manage the HBase snapshots in your Cloudera environment.

Using the Cloudera Operational Database, you can:

  • Create a snapshot
  • List all the restore operations performed for a snapshot in your Cloudera environment
  • Restore from a saved snapshot
  • Delete a snapshot

Creating a snapshot

The Cloudera Operational Database enables you to create snapshots of HBase tables.

When creating a snapshot, specify the HBase table for which you want to take the snapshot and the cloud storage location where you want to save the snapshot.

You must be logged into the Cloudera Operational Database as an administrator.

  1. Log in to the Cloudera Operational Database web interface.
  2. Find and select the database for which you want to create a snapshot.
  3. Navigate to the Snapshots tab on the Database Manager page.
  4. Click the Create Snapshot button.
  5. Specify the following details.
    Parameter name Description
    Table Name The fully qualified name of the HBase table for which you want to take the snapshot.
    Snapshot Name The name of the new snapshot. The snapshot name is unique per database.
    Snapshot Location The URL of the snapshot location on the object store where the snapshot is to be stored.
  6. Click the Create button.
You can find the status of the newly created snapshot under the Snapshot tab.

Listing the restored snapshots

Cloudera Operational Database enables you to list all the restored snapshots in your Cloudera environment against a database.

You can check the number of times the restore operations are performed for a snapshot.

You must be logged into the Cloudera Operational Database as an administrator.

  1. Log in to the Cloudera Operational Database web interface.
  2. Find and select the database for which you want to check the list of restored snapshots.
  3. Navigate to the Snapshots tab on the Database Manager page.
  4. Click the icon for a snapshot and select the See Restored Snapshots action from the list of actions.
The number of restore operations performed for a snapshot is listed. You can also check the status of each operation.

Restoring a snapshot

Cloudera Operational Database enables you to import a snapshot automatically from the snapshot location.

You must be logged into the Cloudera Operational Database as an administrator.

  1. Log in to the Cloudera Operational Database web interface.
  2. Find and select the database for which you want to restore a snapshot.
  3. Navigate to the Snapshots tab on the Database Manager page.
  4. Click the icon for a snapshot and select the Restore Snapshot action from the list of actions.
  5. Specify the following details in the Restore Snapshot dialog box:
    Parameter name Description
    Target Database Name The name of the target database where the snapshot is to be restored.
    Target Environment Name The name of the target environment where the snapshot is to be restored.
  6. Click the Restore button.
The snapshot is restored for the target database and environment.

Deleting a snapshot

Cloudera Operational Database allows you to delete a snapshot from the location where the snapshot is exported.

You must be logged into the Cloudera Operational Database as an administrator.

  1. Log in to the Cloudera Operational Database web interface.
  2. Find and select the database for which you want to delete a snapshot.
  3. Navigate to the Snapshots tab on the Database Manager page.
  4. Click the icon for a snapshot and select the Delete Snapshot action from the list of actions.
  5. Click the Ok button in the Confirm dialog box.
The snapshot is deleted from the object store location.