… in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to maintain… GTIDs on a production setup. The manual describes very nicely how to switch to GTID-based replication, I won’t repeat it. Basically… #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create…

… from MySQL 5.6 to MariaDB 10.0 or vice versa. You just won’t be able to use the GTID features to automatically… you have any suggestion of how to make MariaDB compatible without merging all of the crap that is MySQL 5.6 global transaction ID, I would very much like to hear it …

It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP…. Updates involving non-transactional storage engines – It is not possible to mix non-transactional tables (such as MYISAM) with innodb tables…