Mysql 8.0 in AWS Aurora

 

Features from community MySQL 8.0

The initial release of Aurora MySQL version 3 is compatible with community MySQL 8.0.23. MySQL 8.0 introduces several new features, including the following:

• JSON functions. For usage information, see JSON Functions in the MySQL Reference Manual.
• Window functions. For usage information, see Window Functions in the MySQL Reference Manual.
• Common table expressions (CTEs), using the WITH clause. For usage information, see WITH (Common Table Expressions) in the MySQL Reference Manual.
• Optimized ADD COLUMN and RENAME COLUMN clauses for the ALTER TABLE statement. These optimizations are called "instant DDL." Aurora MySQL version 3 is compatible with the community MySQL instant DDL feature. The former Aurora fast DDL feature isn't used. For usage information for instant DDL, see Instant DDL (Aurora MySQL version 3).
• Descending, functional, and invisible indexes. For usage information, see Invisible Indexes, Descending Indexes, and CREATE INDEX Statement in the MySQL Reference Manual.
• Role-based privileges controlled through SQL statements. For more information on changes to the privilege model, see Role-based privilege model.
• NOWAIT and SKIP LOCKED clauses with the SELECT ... FOR SHARE statement. These clauses avoid waiting for other transactions to release row locks. For usage information, see Locking Reads in the MySQL Reference Manual.
• Improvements to binary log (binlog) replication. For the Aurora MySQL details, see Binary log replication. In particular, you can perform filtered replication. For usage information about filtered replication, see How Servers Evaluate Replication Filtering Rules in the MySQL Reference Manual.
• Hints. Some of the MySQL 8.0–compatible hints were already backported to Aurora MySQL version 2. For information about using hints with Aurora MySQL, see Aurora MySQL hints. For the full list of hints in community MySQL 8.0, see Optimizer Hints in the MySQL Reference Manual.

 

https://dev.mysql.com/blog-archive/the-complete-list-of-new-features-in-mysql-8-0/

MySQL :: The complete list of new features in MySQL 8.0

 

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.3010.html

Aurora MySQL database engine updates 2021-11-18 (version 3.01.0, compatible with MySQL 8.0.23) - Amazon Aurora

 

 

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.MySQL80.html

 

Aurora MySQL version 3 compatible with MySQL 8.0 - Amazon Aurora