Summary
In this chapter, we discussed the various backup techniques and tools that can be used with a MariaDB server. A DBA should know all the backup methods, because each one can be the best choice for some types of workloads.
We discussed how to perform a physical or logical complete backup. When we have a complete backup, we can then perform incremental backups, which are always smaller than complete backups and take less time. Then, we discussed how to take partial backups that do not include all tables from all databases. The restoring of all types of backups has also been explained.
Backups of InnoDB tables are slightly more complicated and, before MariaDB 10.0, required the server to be stopped. We discussed how to back up and restore InnoDB ...
Get Mastering MariaDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
