Amazon Aurora Supports the READ COMMITTED Isolation Level on Read Replicas

Posted on: Jan 16, 2020

Amazon Aurora with MySQL compatibility supports the ANSI READ COMMITTED isolation level on read replicas. This isolation level enables long-running queries on an Aurora read replica to execute without impacting the throughput of writes on the writer node.

The READ COMMITTED isolation level is available with Aurora MySQL engine version 1.21 and above, compatible with MySQL 5.6, and with engine version 2.07 and above, compatible with MySQL 5.7. You can read the Aurora documentation to learn more.

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better throughput than standard MySQL together with increased scalability, durability, and security.