MySQL / MariaDB DBA

Percona XtraBackup

Question

Full versus incremental XtraBackup: what differs, and when should each be used?

Answer

Full: standalone copy, restorable after one prepare. Incremental: copies InnoDB pages changed since a base backup's LSN; restore prepares the base plus each increment in order. Use full for simple recovery; incrementals to cut backup time and storage. Applies to MySQL, including Percona Server for MySQL.

This is 16 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples