Aurora 3 MySQL 8

Improvement of Aurora 3

• Multi-threaded replication
  • replication lag が下がる = 同期が早くなる。
• supports instant DDL
  • This feature significantly speeds up supported schema changes like adding a column, setting or dropping column default values, renaming a table, and more.
  • also don’t exclusively lock the tables being changed. Because the instant DDL operations only modify metadata in the data dictionary, without metadata locks on the table
• New index types
  • Aurora MySQL 3 now supports descending and invisible index types.
  • Descending indexes improve the performance of queries that need to sort and retrieve from indexes in descending order.
  • Invisible indexes allow you to test the performance impact of removing an index without actually dropping the index.

https://aws.amazon.com/blogs/database/amazon-aurora-mysql-3-with-mysql-8-0-compatibility-is-now-generally-available/

MySQL 8.0.x Knowledge

What atomic DDL is;

An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation.