This is a scary problem when you’re recovering from an outage of your database machines. If you’re running a Galera cluster and they all go offline, you’ll need to do a bit of work to restart the cluster and make it safe.
This is another one of those things that is pretty straightforward, but requires culminating information from a different sources in order to get things up and running. The goal here is to get Zabbix to monitor our MariaDB (MariaDB is a drop in replacement for MySQL, I’ll refer to either as MariaDB here) server’s status. There’s a built in template, but a few other files and settings need setup before you can get the juicy data flowing.
One of the things I’ve done for my employer is resize partitions on a few CentOS machines that already had customer data on them. The default CentOS setup didn’t work exactly for our needs, so resizing the /root and /home partitions were our chosen course of action. Overall the process is pretty simple, but I’m writing it down here since it takes the concatenation of a two different processes to get things done.