Launching WordPress on AWS with RDS

USE-CASE

1. Create an AWS EC2 instance
2. Configure the instance with Apache webserver
3. Download php application name "WordPress".
4. Setup a MySQL server using AWS RDS service using Free Tier as a backend
5. Provide the endpoint/connection string to the WordPress application to make it work

Pre-requisite:

1. AWS Account

STEP 1 : Create an EC2 Instance

🔶 We need to launch an EC2 Instance on AWS which we will use to configure Apache Webserver and run WordPress.

🔶 Click on Launch Instance.

🔶 Select 'Amazon Linux` as a Instance Flavor.

🔶 Select t2.micro as a instance type. It is free for eligible.

🔶 Provide configuration details and click on Add Storage.

🔶 Add storage. I will keep it default. And click on Add Tag.

🔶 Add tag if you want. For this, click on Add another tag.

🔶 After this click on Configure Security Group.

🔶 Click on Add Rule. I will allow All traffic to avoid any firewall issue. Then click on Review and Launch.

🔶 Attach key pair then Instance will launched successfully.

🔶 Click on Instance ID. You will get all the details of your created instance.

🔶 You will get Public IP and Private IP from this.

Now you can use Public IP address any Key to connect this Instance. You can use Putty(Recommended) or CLI Browser provided by Amazon to Connect Instance.

Lets go for Next to Configure the instance as Apache Webserver:

STEP 2 : Configure the Instance with Apache Webserver

🔶 Here we are going to configure the Apache Web Server in Amazon Linux 2 Instance.

🔶 To run WordPress, we need to run a web server on our EC2 instance. The open source Apache web server is the most popular web server used with WordPress.
🔶 Install Apache Web Server.
`

sudo su -
yum install httpd -y 

🔶 Then we are Starting Webserver and Enable it Permanently.

systemctl start httpd

systemctl enable httpd

STEP 3 : Installation and configuration of php software name WordPress

🔶 WordPress is a php Application, let’s install php 7.2.

🔶 With Amazon Linux 2, you can use the Extras Library to install application and software updates on your instances.

 amazon-linux-extras install -y php7.2

🔶 After that download WordPress file!

wget http://wordpress.org/latest.tar.gz

🔶 After download the "TAR" file "UNTAR" it.

tar -xvzf latest.tar.gz

🔶 Next you see wordpress name dir come up. So now you can copy all Content inside wordpress folder to Document Root /var/www/html.

cp -rf wordpress/* /var/www/html

Note:

Make Sure where you download your tar file and where you Untar it.

STEP 4 : Setup a MySQL server using AWS RDS service with Free Tier Account

🔶 Let’s now launch a MySql database using Amazon RDS.

🔶 Click on Create Database.

🔶 Choose Standard Create and MySQL as a engine option.

🔶 Select Version MySQL 8.0.20 and template as Free tier.

🔶 Provide DB Instance name, Username & Password

🔶 Here this DB instance have No Connectivity to Internet. We will access it through EC2 Instance.

🔶 Now after Launching this DB Instance mydb named Database will be created inside this DB server.

🔶 Now click on Launch Database. It will take around 10 minutes.

🔶 Once the Database is available, click on Connectivity & Security. You will get hostname and Port no. there.

STEP 5 : Provide the Endpoint/Connection string to the WordPress Application

🔶 Go to the created EC2 Instances instance. In the Description below, find the Public DNS (IPv4) of your instance.

🔶 Enter this IP Address into your web browser. And type Enter.

🔅 Provide Following Information:
🌀 Database Name: Provide Name of Database which created at time of launching DB!

🌀 Username: The username you given while launching DB Instance!

🌀 Password: Provide Password!

🌀 Database Host: Provide the ENDPOINT which you get from "wordpress-database"!

🔶 Now our WordPress is running on the AWS using AWS RDS as a service and in the backend it is using MySQL.
Let's check from CLI.
Use command

# mysql -h <endpoint_url> -u <username> -p

And provide our password.

🔶 Provide Following Details and Install WordPress!

🔶 After Login with the credentials and Login to WordPress!

Successfully done! We have Login in to WordPress and we can continue to write Blogs etc., All your Data will Be stored in RDS MySQL DB.