Integrating Amazon RDS with WordPress
Shreeja Raj
SDE-2 @Walmart | Former SDE Intern'23 @Amazon | Red Hat Certified Engineer | Leetcode 500+ | GEU'23
Amazon Relational Database Service (RDS)
Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. It frees you to focus on your applications so you can give them the fast performance, high availability, security and compatibility they need.
WordPress is a free and open-source content management system (CMS) written in PHP and paired with a MySQL or MariaDB database.
Let’s Begin…
?? Create an AWS EC2 instance
To create an EC2 instance I’m using Amazon Linux 2 image
?? Configure the instance mysql database and apache webserver.
1. Install httpd
2. Install PHP
3. Install WordPress
4. Start httpd service
?? As wordpress stores data at the backend in MySQL Database server. Therefore, you need to setup a MySQL server using AWS RDS service using Free Tier.
???? DataBase created :
???? Creating mysql database :
CREATE DATABASE <database_name>;
???? Now on browser:
https://<public_ip>/wordpres
???? In my case it is not able to create wp-config.php file. Let me create it manually;
cat > wordpress/wp-config.php # and save the file....