Galera cluster mariadb - binlog ?

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.

Hello 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? https://mariadb.org/get-involved/

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

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…