Top MySQL 8/AWS RDS 3 features that can improve your app

MySQL 8 & AWS RDS 3

Recently AWS announced a long waited support of MySQL 8 for their RDS Aurora. Of course, you could use MySQL 8 engine on RDS way before, but Aurora has lots of good features like replication. Version 5.7 will be supported until Oct 2023 so you should think about migration in advance.

This is my personal list of features that we will be using in our project. I will structure features by their functionality. Here it is:

Performance

1. Instant DDL
   MySQL 8 introduced ALGORITHM=INSTANT with the ALTER TABLE statement. This gives you a huge performance impact on some types of operations. According to official docs ADD COLUMN operation on a table with 150M records would be executed within 0.5–1.5s (!). Compared to MySQL 5.7 — it would take nearly 40m.
   (!) But be aware that this feature currently works only with enabled Amazon Aurora MySQL lab mode
2. Invisible indexes. This can be very useful to test index performance impact without breaking anything on your production database. Adding and deleting indexes on big data sets is expensive and time-consuming. Using an invisible index can help you with testing and after tuning — you can make an index visible to the optimizer. The top feature for big DBs.