# Galera cluster mariadb - binlog ?

**URL:** <https://forums.percona.com/t/galera-cluster-mariadb-binlog/6697>\
**Category:** Other MySQL® Questions\
**Created:** [November 22, 2018, 10:13pm UTC](https://forums.percona.com/t/galera-cluster-mariadb-binlog/6697 "2018-11-22T22:13:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rocklee44](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@rocklee44](https://forums.percona.com/u/rocklee44)\
**Post date:** [November 22, 2018, 10:13pm UTC](https://forums.percona.com/t/galera-cluster-mariadb-binlog/6697/1 "2018-11-22T22:13:56Z")

</div>

Hi all,

My environment : I have a galera cluster Mariadb with 3 nodes (10.1.22).

Can binlog records every changes happens with my dbs so I can restore my dbs to point in time ? Or make an external Mariadb instance becomes a slave and replicate from my cluster ?

I run full backup (mysqldump) my dbs on node1 weekly.

If I enable binlog on node1 in my cluster , binlogs only record changes happen on node1 , so these binlogs are useless .

Can I make node1’s binlogs records all events happen on 3 nodes in clusters ? Or I have to enable binlog on 3 nodes ? Does “log\_slave\_updates” help ?

Please give me some advice, thank you very much.

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [November 23, 2018, 5:42am UTC](https://forums.percona.com/t/galera-cluster-mariadb-binlog/6697/2 "2018-11-23T05:42:55Z")

</div>

Hello [rocklee44](https://www.percona.com/forums/member/42483-rocklee44) thanks for the question. Although our team have skills in MariaDB most of the questions on the Forum are about Percona’s own software releases, and these necessarily tend to get more attention.

While someone from Percona might pick this up for you, I think you might be better served by asking this question on the MariaDB Foundation website. Here’s a link in case that helps? [URL=“[https://www.percona.com/forums/member/42483-rocklee44](https://www.percona.com/forums/member/42483-rocklee44)”][https://mariadb.org/get-involved/[/URL]](https://mariadb.org/get-involved/%5B/URL%5D)

---

<div class="post-metadata">

**Author:** ![rocklee44](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@rocklee44](https://forums.percona.com/u/rocklee44)\
**Post date:** [November 23, 2018, 8:45pm UTC](https://forums.percona.com/t/galera-cluster-mariadb-binlog/6697/3 "2018-11-23T20:45:45Z")

</div>

Hi Lorraine, thanks for your hint , I will place this question at Mariadb community, please remove this topic and sorry for the confusion.

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [November 26, 2018, 11:42am UTC](https://forums.percona.com/t/galera-cluster-mariadb-binlog/6697/4 "2018-11-26T11:42:50Z")

</div>

Hey no problem at all, the team would probably love to look at your question but realistically I know that they are more likely to prioritize the Percona s/w. Feel free to ask questions again, though!

I’ll close this post…