What are the pitfalls when downgrading from Mysql 8 (CE) to 5.7?

Question

MySQL

The database uses

• default collation utf8mb4_unicode_ci
  
  
• Default characterset utf8mb4
  
• up to 10 tables
  
• up to 40 GB of live data
  

It is advisable to keep downtime to a minimum as this is production. Runs on AWS and we want to be able to migrate to Aurora at a convenient time when it's ready.

Answer 1

That is, make a copy of the database, deploy it on Aurora and test it - don't you want to? And yet you have to. Let me remind you that Aurora only has a MySQL interface. Inside, this is a different database with its pros and cons You can try to use AWS SCM
for primary validation , but this will not cancel testing