Updated on 2025-01-26 GMT+08:00

Managing Table-level Backups

GeminiDB Cassandra API allows you to create table-level backup for your instance. If a database or table is deleted maliciously or accidentally, you can use backups to restore data.

Usage Notes

  • To enable the table-level backup function, choose Service Tickets > Create Service Ticket in the upper right corner of the console and contact customer service.
  • Table-level backups can be created automatically or manually.

Enabling or Modifying a Table-level Backup Policy

  1. Log in to the Huawei Cloud console.
  2. In the service list, choose Databases > GeminiDB Cassandra API.
  3. On the Instances page, click the target instance name to access the Basic Information page.
  4. In the navigation pane, choose Backups & Restorations.
  5. On the displayed page, click Configure Table-level Backup Policy.
  6. On the displayed page, configure related parameters.

    Figure 1 Setting a table-level backup policy
    Table 1 Parameters

    Parameter

    Description

    Automated Backup

    After this function is enabled, database table data is backed up based on the backup policy.

    Retention Period

    Automated backup files are stored for 7 days by default. The retention period ranges from 1 to 732 days.

    • If the retention period is shorter than seven days, the system automatically backs up data daily.
    • The system automatically checks existing backup files and deletes files that exceed the retention period you set.

    Time Window

    A one-hour period the backup will be scheduled within 24 hours, such as 01:00-02:00 or 12:00-13:00. The backup time is in GMT format. If the DST or standard time is switched, the time window changes with the time zone.

    Backup Cycle

    • All: Each day of the week is selected. This option is selected by default. The system automatically backs up data every day.
    • You can select one or more days in a week. The system automatically backs up data on the specified days.

    Databases and Tables

    Select tables to be backed up.

    A full backup starts within one hour of the time you specify. How long the backup takes depends on the data volume.

  7. Click OK.

Creating and Managing Table-level Backups

Creating a Manual Table-level Backup

  1. Log in to the Huawei Cloud console.
  2. In the service list, choose Databases > GeminiDB Cassandra API.
  3. On the Instances page, locate the instance that you want to create a table-level backup for and click its name.
  4. In the navigation pane on the left, choose Backups & Restorations.
  5. On the displayed page, click Create Table-level Backup.
  6. On the displayed page, configure related parameters.

    Figure 2 Creating a table-level backup
    Table 2 Parameters

    Parameter

    Description

    Backup Name

    The backup name can contain 4 to 64 characters and must start with a letter. The name is case-sensitive and can contain only letters, digits, hyphens (-), or underscores (_).

    Description

    The description can include up to 256 characters and cannot contain carriage return characters and the following special characters: >!<"&'=

    Databases and Tables

    You can select the databases and specify tables therein that you want to back up.

  7. Click OK.
  8. Choose Backups and Restorations > Table-level Backup and manage the created backup.

    Alternatively, click Backups in the navigation pane on the left, choose Intra-region Backups > Table-level Backups, and manage the created backup.

    Figure 3 Managing the created table-level backup

    • Click View Tables to view tables contained in the backup file.
    • Click Restore in the Operation column to restore the backup to a new instance. For details, see Restoring Data to a New Instance.
    • Click Delete in the Operation column to delete the created backup.

      Deleted backups cannot be recovered.

Disabling a Table-level Backup Policy

  1. Log in to the Huawei Cloud console.
  2. In the service list, choose Databases > GeminiDB Cassandra API.
  3. On the Instances page, click the target instance name to access the Basic Information page.
  4. In the navigation pane, choose Backups & Restorations.
  5. On the displayed page, click Configure Table-level Backup Policy.
  6. On the displayed page, configure related parameters.

    Figure 4 Disabling table-level backup policy

    After the table-level backup policy is disabled, any table-level backup task in progress stops immediately, and all table-level backups of the instance are retained. The retention duration depends on Retention Period specified when you enabled the table-level backup policy.

  7. Click OK.