My Oracle Support Banner

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

Last updated on JANUARY 26, 2024

Applies to:

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

Goal

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>. 

Solution

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
Goal
Solution
 Better parallelism with writeset based transaction dependency tracking
 Writeset with each type of binlog format
 Recommended configuration
References


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