Status: Closed (View Workflow)
I know this is like a bit going backwards but to check consistency between:
- nodes of (same) galera cluster
- async slave of galera cluster
We need to set the binlog_format to STATEMENT (using a tool such as Percona pt-table-checksum by example).
This is also valid for other tools (such as pt-table-sync).
In https://mariadb.atlassian.net/browse/MDEV-6924 we have completely disallowed the change of the binlog_format, when wsrep_on = ON.
You can use a workaround, setting wsrep_on = off and run the pt-table-checksum, but this works only for asynchronous slaves. Also, this is dangerous if one user drops the created table, without setting wsrep_on = off (I need to test this, blog post in progress)
Rogue applications (or users, or bugs) may compromise data consistency between nodes of the same cluster, or between master (cluster/standalone) and async slaves(cluster/standalone) and this is the only way I see today to check the consistency.
Could this be set as a parameter, such as wsrep_allow_unsafe_binlog_format ?
Changing the binlog_format is still allowed in latest PXC, and it seems we are taking our own road here.