What Are the Restrictions on RDS for MySQL 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.
Parent topic: Product Consulting