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

Last updated on FEBRUARY 20, 2023

Applies to:

Goal

Is it possible to use mysqldump in a GTID enviroment ?

From the Online Manual, this seems not feasible:

https://dev.mysql.com/doc/refman/en/mysqldump.html#option_mysqldump_single-transaction

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.

 

Solution

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