The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

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.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.