Issues with incremental MariaDB backups setup

MySQL & MariaDB
1

Hey everyone,

Been trying to automate MySQL backups, but it’s been a mess for me. I set up this simple script:

mysqldump -u root -p’mypassword’ mydatabase | gzip > /backups/db_backup.sql.gz
But backup takes forever on my large DB. How do you guys automate MySQL backups without killing performance? Any tools or tricks that actually work well?

2

Choose pxb or mariadb-backup according to different versions. for mariadb

3

Hi Sam,

There’s a blog from Vinicius comparing blackup tools: Backup/Restore Performance Conclusion: mysqldump vs MySQL Shell Utilities vs mydumper vs mysqlpump vs XtraBackup

But yes, xtrabackup for physical backups and mydumper for logical parallel backups on passive server is the way to go.

Thanks,
K