My Oracle Support Banner

mysqldump Single-transaction & Set-gtid-purged (Doc ID 2919859.1)

Last updated on FEBRUARY 20, 2023

Applies to:

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


Is it possible to use mysqldump in a GTID enviroment ?

From the Online Manual, this seems not feasible:

Using --single-transaction together with the --set-gtid-purged option is not recommended; doing so can lead to inconsistencies in the output of mysqldump.
Using this option with the --single-transaction option can lead to inconsistencies in the output. If --set-gtid-purged=ON is required, it can be used with --lock-all-tables, but this can prevent parallel queries while mysqldump is being run.



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

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