5 ms·
My question precisely. Ever since I started using mysql replication I've been mostly relying on replicated incremental backups with xtrabackup. To workaround
by INTPenis 9y ago
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.