In the last quarter of 2021, AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL 8 version, porting many of the advantages MySQL 8 has over previous versions.
While this brings a lot of new interesting features for Aurora, what we are going to cover here is to see how DDLs behave when using the ONLINE option. With a quick comparison with what happens in MySQL 8 standard and with Group Replication.
All tests were run on an Aurora instance r6g.large with a secondary availability zone. The test was composed of:
- #1 to perform DDL
- #2 to perform insert data in the table I am altering
- #3 to perform insert data on a different table
- #4 checking the other node operations
In the Aurora instance, a …[Read more]