There are large cost savings moving your workload to Aurora Serverless v2. I have performed multiple production upgrades from RDS MySQL -> Aurora Serverless v2 utilizing native mysql replication. This allows for a seamless cutover startegy while utilizing a rollback instance in the event a DB issue was discovered hours or days after the upgrade. I can personally attest to the scaling abilities of Aurora Serverless v2. My solution is AWS RDS SME approved and recommended if a rollback instance is desired. It provides a great sense of security to the business if you're struggling to get your change management request approved.
Scenarios:
- on-prem -> AWS EC2 -> RDS -> Aurora Serverless
- RDS -> Aurora serverless
- Azure -> AWS