Backup/Restore strategy. Recommendations?
I have 6 mariaDB servers each with about 30 customer databases. Databases vary in size from 10 to 150 GB.
What is the "best" (quickest, safest) backup/restore process bearing in mind the majority of times it will just be needed to restore a single table?
One day of course it might be needed to rebuild the entire server or to move a database to a new server .... but my biggest concern at the moment is restoring individual tables as quickly as possible.
(one table on one database on one server got corrupted this week and it took an embarrassingly long time to get the customer back up and running)
Answer Answered by Ian Gilfillan in this comment.
You could use Mariabackup.