In the previous chapter, we saw how to monitor MariaDB instances and statistics for performance. This is very important, but one of the most important things that cannot be forgotten is backups.

There are several ways to create backups. Each one has their pros and cons of course. Some of them are related to the technology you're using while others depend on your constraints.

We saw some of those tools in the previous chapters, but they were for specific cases. We're going to see them here in a broader perspective that will help you choose the most convenient one that suits your needs.

To make it simpler, here is a Vagrantfile that will install and configure a lot of things for you:

# -*- mode: ruby -*-
# vi: set ft=ruby :
# Vagrantfile API/syntax version. Don't touch unless you know what you're doing!
#
VAGRANTFILE_API_VERSION = "2"

# Insert all your Vms with configs
boxes = [
    { :name => :backup,        :role      => 'db',   :ip => '192.168.33.31' },
]

$install...