Help Center/ GaussDB(for MySQL)/ User Guide/ Data Backups/ Backup Types
Updated on 2023-10-18 GMT+08:00
View PDF

Backup Types

You can back up your GaussDB(for MySQL) instances to ensure data reliability.

  • GaussDB(for MySQL) supports multiple backup types. Automated backup is enabled by default. For details about automated backup, see Configuring a Same-Region Backup Policy.
  • GaussDB(for MySQL) periodically creates full backups and incremental backups for your instances. You can restore data to a specific point of time using a backup. For details, see Restoring Instance Data to a Specific Point in Time.
  • GaussDB(for MySQL) backs up data at the DB instance level.
  • Automated and manual backup files cannot be downloaded.

Based on different dimensions, there are the following backup types:

  • Full backup and incremental backup based on the data volume
  • Manual backup and automated backup based on backup method
  • Same-region backup based on backup region
Table 1 Comparison of backup types

Backup Type

Enabled by Default

Retention Period

Description

How to View

Full backups

Yes

Full backups are retained till the retention period expires.
  • A full backup is to back up all data of your DB instance in the current point of time.
  • You can use a full backup to restore the complete data generated when the backup was created.
  • Full backups include automated backups and manual backups.

Click the instance name. On the Backups page, click the Full Backups tab and view the backup size.

Incremental backups

Yes

Incremental backups are retained till the retention period expires.
  • GaussDB(for MySQL) automatically backs up the updated data since the last automated or incremental backup was made every five minutes or after a certain amount of data is reached.
  • Incremental backups are automated backups.

Click the instance name. On the Backups page, click the Incremental Backups tab and view the backup size.

Same-region backups

Yes

1-3660 days

Backup files are stored in the same region as the DB instance. Same-region backup (automated backup) is enabled by default and cannot be disabled.

Click Backups in the left navigation pane and view the backup size.

Automated backups

Yes

1-3660 days

GaussDB(for MySQL) saves automated backups based on the retention period you specified.

-

Manual backups

Yes

Manual backups are always retained until you delete them manually.

Manual backups are user-initiated full backups of instances. They are retained until you delete them manually.

-
Parent topic: Data Backups