Help Center> GaussDB> User Guide> Backups and Restorations> Working with Backups
View PDF

Working with Backups

GaussDB(for MySQL) supports backups and restorations to ensure data reliability.

GaussDB(for MySQL) uses Sysbench to import data models and a certain amount of data. The compression rate after backup is about 80%. The more duplicate data is, the higher the compression rate is.

Compression ratio = Space occupied by backup files/Space occupied by data files x 100%

Functions

If a database or table is maliciously or accidentally deleted, backups can help you recover the lost data to ensure data security.

Automated Backups

Automated backups are created during the backup time window of your DB instances. GaussDB(for MySQL) saves automated backups based on the retention period you have specified. If necessary, you can restore to any point in time during your backup retention period.

Manual Backups

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

Full Backups

The full backup mode is used to back up all target data even if no data is updated since the last backup.

Incremental Backups

GaussDB(for MySQL) automatically backs up data updated since the last automated or incremental backup every five minutes.

Parent topic: Backups and Restorations