MariaDB Galera + Remote Backup

Question

I'm using CentOS 8 and I have a MariaDB 10.5.4 Galera set up with three nodes. Now, I want it to create a backup to my central server from time to time. I'm thinking of mysqldump but restoration would take a lot of time and mariabackup does not support remote backups (I think). So I'm thinking of creating a Master-Slave to from my galera cluster setup to a stand-alone setup on my central server then I run mariabackup from there like this:

For now my current set up is that I had my third node act as a backup for HAProxy and it is where mariabackup is currently running (see image and remove central server). But my boss wanted me to store backup on central and let central do the backup instead of the database server.
Are there any simple alternative? I'm thinking of following this guide, but it's a bit outdated and I'm not sure if it would work. Thanks

danblack · Answer

Central backups occurring on a replica is a decent strategy.
The guide on quick glance looks ok. Ensure that your server-id is unique. Per mariadb galera guidance galera cluster members shoudl have the same server-id in most scenarios.. Its unclear why binlog-format=mixed when galera requires row so I'd just keep row.
'log-slave-updates' is the critical thing of the master node but for consistency its easy enough to have this on all galera nodes in case you need to change master at some point.
Like all backups consider the process that a restoration would take and business requirements on MTTR (mean time to recover). And test the restoration process when you've got backup to see it works and how long it takes.

MariaDB Galera + Remote Backup

One Answer

Add your own answers!

Ask a Question