Details
-
Type:
Task
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Fix Version/s: 5.5.42-galera, 10.0.16-galera
-
Component/s: wsrep
Description
Hi,
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.
Joffrey
Gliffy Diagrams
Attachments
Issue Links
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Ok to push if no problems with regression testing and RQG.
Hi Nirbhay,
as discussed together, I think we should re-enable ASAP the possibility to set the binlog_format to something else than ROW at the session level.
Thanks,
Joffrey