3

We are using a MariaDB Galera Cluster with 3 nodes. For the state transfer we are using xtrabackup.

We have some problems with the binary logs - they got too big and crashed the server. We can remove them manually with the purge binary logs command, another way would be to set the expire_logs_days so they would expire.

I now that we could use xtrabackup to backup the DB and use the binlog to get to some point in time. But do we really need it for Galera to work ?

Improve this question

1 Answer 1

Reset to default
3

Galera Cluster by itself does NOT need binary logging enabled. The question is more what happens when you run a bad Query (for example UPDATE employee SET salary = 0 ; WHERE id = 42;). For this scenario a HA Cluster does not help. And if backup was done at 02:00 in the morning you have a little problem (potentially) how to fix your data. So binary logging is possibly recommended. If binary logs get too big it means you have a lot of traffic and need more disk space. Or you have to purge binary logs more frequent. MySQL Backup Manager (mysql_bman) helps you doing this...

Improve this answer
2

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .