How to Build a WordPress Site Using Amazon RDS on AWS : A Step-by-Step Guide

Are you ready to launch your WordPress site using the cutting-edge power of Amazon Web Services (AWS)? This comprehensive guide will take you on a seamless journey, starting from setting up a MySQL database on Amazon RDS to effortlessly deploying WordPress on an EC2 instance. By the end of this adventure, your WordPress website will be soaring high in the secure and scalable AWS cloud. Let's dive in and bring your digital dreams to life!

Prerequisites

Before diving in, ensure you have:

• An AWS account with necessary permissions for creating EC2 instances and RDS databases.

• Basic familiarity with AWS services like EC2, RDS, and security groups.

Section 1 : Setting Up a MySQL Database with Amazon RDS

Let's start by setting up the MySQL database using Amazon RDS.

1. Access AWS Management Console: Log into the AWS Management Console using your credentials.

2. Navigate to RDS: Find and select the RDS service under "Database" in the AWS Management Console.

   

3. Create a Database: Click on "Create database" and choose MySQL as your database engine.

   

   Configure instance settings such as size, storage type, and security group.

   

   

4. Review and Launch: Double-check your settings and click "Create database". Wait for the RDS instance to be provisioned.

   

Section 2: Launching an EC2 Instance

Next, let's launch an EC2 instance to host your WordPress site.

1. Access EC2 Dashboard: Return to the AWS Management Console and navigate to EC2 under "Compute".

2. Launch Instance: Click on "Launch instance" to initiate the instance creation process.

3. Choose an AMI: Select an appropriate Amazon Machine Image (AMI), such as Amazon Linux or Ubuntu, based on your requirements.

4. Select Instance Type: Opt for a suitable instance type, like t2.micro, which is eligible for the AWS Free Tier.

5. Configure Instance: Set up instance details, including network settings and IAM roles.

6. Add Storage: Attach storage volumes as needed, with an 8 GB root volume provided by default.

7. Configure Security Group: Create or select a security group allowing SSH (port 22) and HTTP/HTTPS (ports 80 and 443) access. Limit SSH access to your IP for security.

8. Review and Launch: Review instance details and click "Launch instance".

   

9. Connect to Your Instance: Once launched, connect to your instance using SSH. Instructions are available on the EC2 dashboard.

   

   For more information on creating an EC2 instance, please check out my blog on "How to create an EC2 instance and host a simple Web Page".

Section 3: Configuring Your Amazon RDS Database

Now, let's configure your EC2 instance to connect to the Amazon RDS database.

1. Install MySQL Client: On your EC2 instance, install the MySQL client to connect to the RDS database.

    rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
   

    dnf install mariadb105-server
   

2. Security Settings: Ensure your RDS instance allows inbound traffic from your EC2 instance's security group.

3. Connect to RDS: Use the MySQL client to connect to your RDS database and verify connectivity.

   

   

    mysql -h wordpress-db.chkyc2maonut.ap-south-1.rds.amazonaws.com -u admin -p
    Enter password:admin123
   

   

Section 4: Installing and Configuring WordPress on EC2

With the database set, let's proceed to install WordPress on your EC2 instance.

1. Install Apache and PHP: Update the package manager and install Apache web server and PHP on your EC2 instance.

   To install Apache on your EC2 instance, run the following command in your terminal:

    sudo yum install httpd -y
   

    systemctl start httpd
   

   Now, if you go to your browser and type the public IP address of your EC2 instance, you should see "It works" displayed on the page.

   

2. Download WordPress: Obtain the latest WordPress package from wordpress.org and extract it into your web server directory i.e. /var/www/html.

    wget https://wordpress.org/latest.zip
   

    unzip latest.zip
   

    mv wordpress/* .
   

    rm latest.zip
   

    rm /wordpress
   

   

   Now, copy the IP address from your EC2 instance, paste it into your browser, and install WordPress as shown below:

3. Configure WordPress: Create a MySQL database for WordPress and set up the wp-config.php file with your database credentials.

   Change to the WordPress directory and make a copy of the default config file using the following commands:

    cd /var/www/html
    mv wp-config-sample.php wp-config.php
   

   Edit the wp-config.php file to include your database name, username, and password.

    vi wp-config.php
   

1. Set Permissions: Adjust file permissions to ensure WordPress can write to necessary directories.

2. Complete Installation: Access your EC2 instance's public IP in a browser to finalize the WordPress installation.

   

Section 5: Exploring Your New Website

Congratulations on launching your WordPress site on AWS! Now, let's explore and tidy up.

1. Explore Your Website: Customize your WordPress site by adding themes, plugins, and content. Test its functionality thoroughly.

2. Resource Cleanup: To avoid unnecessary charges, delete the EC2 instance and RDS database if no longer needed. Ensure all associated resources are terminated.

   

Conclusion

You've successfully deployed WordPress on AWS using Amazon RDS and EC2. This guide has provided you with the essential steps to host a scalable and secure WordPress website in the cloud. Keep exploring AWS services to further optimize your WordPress environment.

Thank you for reading! If you have any questions or feedback, feel free to reach out. Happy WordPress hosting on AWS!