Data consistency if binlog_transaction_dependency_tracking=WRITESET
Posted by: Won-sang Yoo
Date: February 06, 2024 11:09PM

I am considering setting

binlog_transaction_dependency_tracking=WRITESET
and
slave_parallel_type=LOGICAL_CLOCK

to reduce replica lag, but concerned about the data consistency.

From https://dev.mysql.com/doc/mysql-replication-excerpt/8.0/en/replication-options-binary-log.html#sysvar_binlog_transaction_dependency_tracking, it says "Two transactions are considered conflicting if their write sets overlap—that is, if there is some number (hash) that occurs in the write sets of both transactions.", but I'm not sure whether this setting may cause any data inconsistency.

Thank you for insights in advance!

Options: ReplyQuote


Subject
Written By
Posted
Data consistency if binlog_transaction_dependency_tracking=WRITESET
February 06, 2024 11:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.