Hi there …
How do i take the differential ,full and transactional ,cold and hold backups in Percona MySQL…?
Can i automate the backups using Percona monitoring management tool…?
1 Like
Hi there,
You can take full by following - https://www.percona.com/doc/percona-xtrabackup/8.0/backup_scenarios/full_backup.html
Incremental and differential are done the same way, you alway have a delta. Incremental is done by having a delta from previous backup:
Monday - Full / Tuesday - Incremental since Monday / Wednesday - Incremental since Tuesday
Differential backups are done similar to incremental, but you always use full as base:
Monday - Full / Tuesday - Incremental since Monday / Wednesday - Incremental since Monday
You can take incremental/differential by following https://www.percona.com/doc/percona-xtrabackup/8.0/backup_scenarios/incremental_backup.html
Percona Xtrabackup is already a hot backup for MySQL.
Regarding cold backup, not sure why you will want that nowadays.
Currently PMM doesn’t have the ability to automate backups. An alternative is to script it under crontab to trigger backup on a regular basis.
Also, remember that more important that take a backup, is to test if you can restore it!
1 Like