Re:Fast MySQL Backup and Restore Using Mydumper and Myloader
by wanderr on Saturday July 22, 2017 @10:04PM
(#14830536)
How does this compare to the percona tools?
[ Parent
| on HN ]
Re:Fast MySQL Backup and Restore Using Mydumper and Myloader
by barrkel on Saturday July 22, 2017 @11:35PM
(#14830768)
Percona talk about these tools on their website / blogs. Basically, this thing is for logical backup, where you might want to eg only restore a single table. Logical also compresses much better. Innobackupex binary full restore will still be much faster though.
Re:Fast MySQL Backup and Restore Using Mydumper and Myloader
by INTPenis on Sunday July 23, 2017 @05:57AM
(#14831585)
My question precisely.
Ever since I started using mysql replication I've been mostly relying on replicated incremental backups with xtrabackup.
To workaround the downside of not being able to restore a single table I'm using some scripts I found online that perform automatic restore tests of the xtrabackup backups with docker. That way I can access the restored DB in the docker container and export/dump whatever I want.
This also enables me to run a restore test and data integrity test on the restored data every day and report the status to my monitoring platform.