maria-developers team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

GTID implementation in MySQL 5.6 has the limitation as described here:
https://dev.mysql.com/doc/refman/5.6/en/replication-gtids-restrictions.html


"nontransactional storage engines such as
MyISAM<https://dev.mysql.com/doc/refman/5.6/en/myisam-storage-engine.html>
cannot
be made in the same statement or transaction as updates to tables using
transactional storage engines such as
InnoDB<https://dev.mysql.com/doc/refman/5.6/en/innodb-storage-engine.html>
."

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

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

-- Peter Laursen
-- Webyog