MySQL powered by AWS RDS

In this chapter, as well as teaching you about Route 53, DNS, and certificates, we’ve also changed our main database to MySQL hosted on AWS’s Relational Database Service (RDS).

Let’s assume that you currently run a website with a MySQL database, and this book has inspired you to move to AWS and write your infrastructure code with AWS CDK. At some point, you are going to have to do a database migration. There are plenty of ways to do this with AWS, with the most complete solution being with AWS Database Migration Service.

Keeping with the theme of simplicity and giving you the tools to tackle infrastructure problems with AWS CDK, let’s go with the simplest scenario, which would essentially be an exported .sql from your current database. That said, our plan is pretty evolved and advanced and should cover most types of database migrations.

If you look in the infrastructure/lib/constructs/RDS/init directory, you will see one...