Migrate the WordPress Database to AWS RDS

In this chapter, we’ll migrate the MariaDB database, which is currently hosted on the same EC2 instance as WordPress, to an external RDS MariaDB database.

Doing so allows us to separate the components of the WordPress application and scale them individually. By using RDS, we gain access to all of the options AWS provides to scale and operate databases efficiently.

Migration steps

Let’s take a look at the steps involved to migrate the database.

Step 1: Launch WordPress instance from launch template

The first step is to recreate the WordPress instance. To do so, we can use the new launch template.

Execute the following command in the terminal: