Not the answer you need?
Register and ask your own question!

MySQL Backups

ca1990ca1990 Current User Role Contributor

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..?

Answers

  • Marcelo AltmannMarcelo Altmann Percona Staff Role

    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!

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.