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.

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

Applies to:

Goal

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!