Skip to main content

Backup and Rollback

MySQL Database provides comprehensive data backup and rollback functionality to help you ensure data security and support rapid data recovery in case of data loss or misoperations. This document will detail backup types, operation procedures, and rollback methods.

Data Backup​

MySQL Database supports both automatic backup and manual backup:

  • Automatic Backup: The platform automatically performs backup once daily, with data backups retained for 7 days
  • Manual Backup: Users can actively trigger backup operations based on business needs
Important Notes
  • Automatic backup currently only supports "Snapshot Backup" for rapid rollback of the original cluster
  • Both automatic backup and manual backup are limited to once per hour by default

Backup Types​

MySQL Database provides two backup types. You can choose the appropriate backup method based on your business scenario:

Backup TypeTechnical PrincipleAdvantagesDisadvantagesApplicable Scenarios
Logical BackupSaves database logical structure and content as SQL statements• Supports fine-grained database/table-level backup
• Minimal impact on database performance
• Includes complete database objects		• Slower backup speed
• Larger storage volume		Precise backup scope control or cross-version migration
Snapshot BackupUses redirect-on-write (ROW) technology to create storage layer snapshots• Extremely fast backup speed (seconds)
• Business-transparent
• Relatively smaller volume		• Coarser backup granularityProduction environment rapid backup and recovery

Operation Steps​

  1. Go to CloudBase Console/MySQL Database/Database Settings

  2. In the "Backup and Rollback" section, click the "Manual Backup" button

  3. In the backup panel that appears, select the backup type (Logical Backup or Snapshot Backup)

  4. Click "Confirm" to start executing the backup task

Manual Backup Operation Interface

Data Rollback​

The data rollback function allows you to restore the database to a specified point-in-time state based on existing backups.

Rollback Features​

  • New Instance Generation: Rollback will generate a new database instance
  • Custom Naming: Supports custom renaming of the rolled-back database
  • Original Data Handling: Supports choosing whether to delete the original database and data tables

Operation Steps​

  1. Go to CloudBase Console/MySQL Database/Database Settings

  2. In the backup record list, find the backup record you need to rollback

  3. Click the "Rollback" button for the corresponding backup record

Data Rollback Operation Interface