Score:0

How to sync table data between two nodes of a mariadb galera cluster?

ru flag

I built a mariadb galera cluster on CentOS7. Below is the galera node information:

10.200.67.27    MariaDB-Node1
10.200.67.29    MariaDB-Node2
10.200.67.26    MariaDB-Node3

However, MariaDB-Node2 was unexpected stopped. And I found a table named leave_records, the data in the table is not synced. I mean the table records is not exactly the same, even though MariaDB-Node1 and MariaDB-Node3 are still running.

How can I compare the diffrence between them, and resync table data? I need every node have same data records.

Any help is important to me.

Nikita Kipriyanov avatar
za flag
It should be synched automatically during startup. Notice, that Galera originally was developed to sync InnoDB tables (development versions also have experimental support for MyISAM and ARIA). Check log files and configuration, especially regarding SST, and [attach here](https://serverfault.com/posts/1101902/edit), if there are problems that you don't understand.
Winbert avatar
ru flag
@Nikita Kipriyanov I found the stopped node cannot start up
Nikita Kipriyanov avatar
za flag
Then how you determined that "table records is not exactly the same", without starting the node? Also, where is the configuration and logs from failed node?
ua flag
See if Percona's pt-table-sync has a mode that works with Galera (aka Percona Xtradb Cluster).
ua flag
"not exactly the same" -- What is the evidence? (`SHOW TABLE STATUS` is _not_ sufficient.)
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.