← Back to team overview

maria-developers team mailing list archive

Question about GTIDs in MariaBD


GTID implementation in MySQL 5.6 has the limitation as described here:

"nontransactional storage engines such as
be made in the same statement or transaction as updates to tables using
transactional storage engines such as

If you try you will get the error:
Error Code: 1785
When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables
can only be done in either autocommitted statements or single-statement
transactions, and never in the same statement as updates to transactional

Is there same or similar/other limitations with GTID in MariaDB 10?

-- Peter Laursen
-- Webyog

Follow ups