Hi,

2013/3/14 Michael Widenius <monty@askmonty.org>

I didn't think that sync_binlog=1 is required anymore for safe reliction.

We are always using group commit in MariaDB 10.0 for the master, so
the binary log will be synced for each group commit, which is safe.

I have to use it in a DRBD config. When testing this config, I killed mysqld with SIGKILL and sync_binlog=0 and failover start binary log in old position, that caused duplicates on slaves.

With sync_binlog=1, this happens no more.

How to configure how often group commits are fdatasynced ?
 

This is of course something that a customer can sponsor us, if they think
this would be useful for them....

We will discuss about that on March 27 ;)

--
Greg