Not the answer you need?
Register and ask your own question!

Galera cluster mariadb - binlog ?

rocklee44rocklee44 EntrantCurrent User Role Beginner
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.

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    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/
  • rocklee44rocklee44 Entrant Current User Role Beginner
    Hi Lorraine, thanks for your hint , I will place this question at Mariadb community, please remove this topic and sorry for the confusion.
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    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...
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.