I need to move on from using mariadb-dump for backups
Hi all,
Looking at options for backups of a production MariaDB server currently housing one large-ish database (135GB data dir), and another 6 smaller databases (1-6GB in size).
The time taken to backup the databases isn't a primary concern, although as always the faster the better. Currently the nightly cron task for backups takes around 3 hours, including compression of the files out put my mariadb-dump.
What does concern me is the time to restore should we have a disaster. I'm performing occasional restores to a staging server, and that large DB is taking somewhere in the vicinity of 6+ hours.
One of my criteria would be the ability to restore just a single one of those 7 databases to the production host, which appears to preclude or at least make more complex a few of the options I've been looking at (ie mariadb-backup). I also need the ability to restore a single one of those databases to a separate (staging/forensic) host once a month.
Can I have a few ideas as to the direction you'd recommend I look, here?
Thanks!