# Binary logging confusion

**URL:** <https://forums.percona.com/t/binary-logging-confusion/3434>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [April 29, 2014, 8:44am UTC](https://forums.percona.com/t/binary-logging-confusion/3434 "2014-04-29T08:44:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![holvoetj](https://avatars.discourse-cdn.com/v4/letter/h/b782af/32.png) [@holvoetj](https://forums.percona.com/u/holvoetj)\
**Post date:** [April 29, 2014, 8:44am UTC](https://forums.percona.com/t/binary-logging-confusion/3434/1 "2014-04-29T08:44:24Z")

</div>

Hi all,

I built a 3-node cluster a while ago using examples from the Percona website.  
These all state to use : binlog\_format=ROW.  
However, none of them set “log\_bin” so that means binary logging isn’t even turned on … or am I completely confused and is there no connection between these two variables ?

As far as I can tell the cluster is working perfectly without the log\_bin setting.  
Maybe I only need it if I want to do point-in-time recovery ?

Any and all answers appreciated, even RTFM ones (if you can point met to the manual to read) 🙂

regards  
Jo

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [April 30, 2014, 6:09am UTC](https://forums.percona.com/t/binary-logging-confusion/3434/2 "2014-04-30T06:09:39Z")

</div>

Hi Jo,

Galera uses the standard binary logging mechanism under the hood for it’s write sets. But log\_bin is not required as you don’t need to write binlogs to the disk, but fomat=row is still needed as galera does not work with statement or mixed ones. Sometimes enabling log\_bin helps in debugging or in backups (you can stream the binlogs online with mysqlbinlog 5.6).

---

<div class="post-metadata">

**Author:** ![holvoetj](https://avatars.discourse-cdn.com/v4/letter/h/b782af/32.png) [@holvoetj](https://forums.percona.com/u/holvoetj)\
**Post date:** [April 30, 2014, 6:23am UTC](https://forums.percona.com/t/binary-logging-confusion/3434/3 "2014-04-30T06:23:43Z")

</div>

Hi przemek;

thanks very much for your reply ! Good to hear “officially” that my cluster is ok.  
So do I need log\_bin for point-in-time recovery then or will that also work with the standard binary logging mechanism ? I’m using xtrabackup/innobackupex.

thanks again & regards  
Jo
