[Maria-discuss] Galera Cluster: Do we need binlogs? How to limit the space used by binlogs?
Hello We have quite a busy MariaDB operating in a Galera cluster. The Size of the database is not that large, about 2GB. We get several GB of Binlogs per day as we get a lot of transactions (busy mailserver with Bayes DB and a lot of timestamps being updated) I have set: expire_logs_days = 1 But still those binlogs 'waste' several dozends of GB on each node. Does Galera need those logs for syncing? Are there other ways to limit the size used by the binlogs? Kind regards Benoit Panizzon -- I m p r o W a r e A G - ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 07 CH-4133 Pratteln Fax +41 61 826 93 02 Schweiz Web http://www.imp.ch ______________________________________________________
Hello Benoit, On 07 Aug 2014, at 10:50, Benoit Panizzon <benoit.panizzon@imp.ch> wrote:
We have quite a busy MariaDB operating in a Galera cluster. The Size of the database is not that large, about 2GB. We get several GB of Binlogs per day as we get a lot of transactions (busy mailserver with Bayes DB and a lot of timestamps being updated)
I have set: expire_logs_days = 1
But still those binlogs 'waste' several dozends of GB on each node.
Does Galera need those logs for syncing? Are there other ways to limit the size used by the binlogs?
MariaDB Galera Cluster does not use binary logs at all for replication! You can disable binary logs if you have no need for it. Binary logs on one or more masters are sometimes enabled for additional master/slave replication and/or backup strategies. - Pim
participants (2)
-
Benoit Panizzon -
Pim Rupert (Lemonbit)