My Oracle Support Banner

Don't Set binlog_format=MIXED And binlog_transaction_dependency_tracking=WRITESET(_SESSION) (Doc ID 2982715.1)

Last updated on NOVEMBER 20, 2023

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.


This document describes important mis-configuration regarding to dependency tracking on the source when using a multi-thread applier (MTA) of MySQL asynchronous replication. For more information about fundamental configuration of MTA, refer to <Document 2978013.1>. 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Better parallelism with writeset based transaction dependency tracking
 Writeset with each type of binlog format
 Recommended configuration

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.