In this blog, I am going to integrate the WordPress with Amazon RDS. So without any further delay Let’s Get started..
Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform, offering over 175 fully featured services from data centers globally. Millions of customers — including the fastest-growing startups, largest enterprises, and leading government agencies — are using AWS to lower costs, become more agile, and innovate faster.
Amazon RDS is the Relational Database Service offered as a web service by Amazon. It makes it easy to set-up and operate a relational database in the cloud. It provides a very cost-effective way to use industry’s leading RDBMS software as a managed service. Because of this web service from amazon AWS, You do not have to buy any server or install any database software in it. You just have subscribe to the AWS RDS web service and start using the RDBMS features after some initial configuration involving memory and CPU capacity allocation etc.
WordPress is an open source Content Management System (CMS), which allows the users to build dynamic websites and blog. WordPress is the most popular blogging system on the web and allows updating, customizing and managing the website from its back-end CMS and components.WordPress is an excellent website platform for a variety of websites. From blogging to e-commerce to business and portfolio websites, WordPress is a versatile CMS. Designed with usability and flexibility in mind, WordPress is a great solution for both large and small websites.
For this, there are some Prerequisite
An account on AWS so that we can use its resources.
Basic knowledge of how to launch EC2 instances on AWS cloud.
Launch an EC2 instance For Deploying WordPress
Amazon Elastic Compute Cloud (Amazon EC2) is a web service that provides secure, resizable compute capacity in the cloud. It is designed to make web-scale cloud computing easier for developers. Amazon EC2’s simple web service interface allows you to obtain and configure capacity with minimal friction. It provides you with complete control of your computing resources and lets you run on Amazon’s proven computing environment.
For launching EC2 instance you can follow below mentioned link:
Here I launched the Amazon Linux 2 instance using AWS Management Console. You can also use AWS CLIv2 which is the Command Line Version.
To know more about AWS CLIv2 you can refer to my another blog mentioned below.
After Launching the instance, just connect To the Instance
1) Open the Amazon EC2 console.
2) In the left navigation pane, choose Instances and select the instance to which to connect.
3) Choose Connect.
After this we have to install the some important softwares
The following command will download the WordPress from Internet.
curl https://wordpress.org/latest.tar.gz --output wordpress.tar.gz
Also we have to extract it.
tar xf wordpress.tar.gz
Also just for information:
The Linux ‘tar’ stands for tape archive, is used to create Archive and extract the Archive files. tar command in Linux is one of the important command which provides archiving functionality in Linux.
tar [options] [archive-file] [file or directory to be archived.
-c : Creates Archive
-x : Extract the archive
-f : creates archive with given filename
-t : displays or lists files in archived file
-u : archives and adds to an existing archive file
-v : Displays Verbose Information
Here’s how to copy a directory in Linux:
cp -r source_directory destination_directory
We will use
cp -r wordpress /var/www/html
After this Start the Apache webserver services:
systemctl start httpd
1)Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
2) In the upper-right corner of the AWS Management Console, choose the AWS Region where you want to create the DB instance.
3) In the navigation pane, choose Databases.
4) Choose Create database.
5) On the Create database page, shown following, make sure that the Standard Create option is chosen, and then choose MySQL.
Here I am using free tier account so In the Templates section, choose the Free tier.
6) In the Settings section, set these values:
DB instance identifier — Mydb Master username — Give username Auto-generate a password — Disable the option Master password — Choose a password. Confirm password — Retype the password
8) In the Connectivity section,Use default values.
If you want to change, You can…
9) Now just create the database
10) Wait for the Status of your new DB instance to show as Available. After some minutes you will see that the database is created.
You can also access this database from the terminal.
Lastly, Provide the endpoint/connection string to the WordPress application to make it work.
That’s It, Thanks for Reading !! 📃
Keep Sharing, Keep Hustling🎯🎯🎯