What Are the Restrictions on MySQL DB Instances After GTID Is Enabled?

By default, GTID is enabled on MySQL and cannot be disabled because functions such as the primary/standby relationship establishment depend on GTID. If GTID is disabled, all RDS functions (such as backup and restoration and primary/standby switchover or failover) will be affected or even become unavailable.

After GTID is enabled for MySQL community edition, an error will be reported in the following conditions:

• Create tables (create table...select).
• A transaction is processed by the engine (InnoDB) that supports transactions and the engine (MyISAM) that does not support transactions at the same time.
• Create temporary tables (create temporary table).

RDS for MySQL resolved these issues by optimizing the kernel.