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
- Log in to the Huawei Cloud console.
- In the service list, choose Databases > GeminiDB Cassandra API.
- On the Instances page, click the target instance name to access the Basic Information page.
- In the navigation pane, choose Backups & Restorations.
- On the displayed page, click Configure Table-level Backup Policy.
- 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.
- Click OK.
Creating and Managing Table-level Backups
Creating a Manual Table-level Backup
- Log in to the Huawei Cloud console.
- In the service list, choose Databases > GeminiDB Cassandra API.
- On the Instances page, locate the instance that you want to create a table-level backup for and click its name.
- In the navigation pane on the left, choose Backups & Restorations.
- On the displayed page, click Create Table-level Backup.
- 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.
- Click OK.
- 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
- Log in to the Huawei Cloud console.
- In the service list, choose Databases > GeminiDB Cassandra API.
- On the Instances page, click the target instance name to access the Basic Information page.
- In the navigation pane, choose Backups & Restorations.
- On the displayed page, click Configure Table-level Backup Policy.
- 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.
- Click OK.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot