This article is the continuation of WordPress with Docker, AWS (ECS, Code Pipeline, Load Balancer, RDS, EFS) Complete Series. For better understating, please start from the beginning of the series.
The purpose of creating MYSQL database using AWS RDS is quite simple. Centralized, automatic backups, scalable and highly available. What else we can ask for when it comes to MYSQL.
For wordpress there are two main options to choose your database from. Amazon Aurora and MYSQL.
Amazon Aurora is also compatible with MYSQL. Aurora is better but more expensive than regular MYSQL RDS database.
In our example, we are using the regular MYSQL
Let’s begin creating the RDS database for our blog
Create RDS Database
Find and select the RDS service under the service tab. Click on create database. Follow the instructions below:
Before we begin, please change things such as database size, names and other identifiers as per your requirements
- DB instance identifier is not the database name
- Keep the Master username and password secure, we will need it later on.
Keep the Master username and password secure, we will need it later on.
DB instance size totally depends upon your traffic. We’re just using the bare minimum.
In the connectivity section below, use the rds Security Group we have created earlier.
This is where you are creating the initial database.