Integrate WordPress with Amazon RDS!!!

Welcome to my new technical blog, In this blog, I am going to show you how to integrate WordPress with Amazon RDS, but first clear some basic concepts.

AWS EC2 :-

Amazon Elastic Compute Cloud (EC2) is a service which is provided by Amazon.com's cloud-computing platform, Amazon Web Services (AWS), which allows users to rent virtual computers on which to run their own computer applications. A user can create, launch, and terminate\instances as needed. It provides secure, resizable compute capacity in the cloud. . It provides you with complete control of your computing resources

WordPress -

WordPress is a free, open-source website creation platform. On a more technical level, WordPress is a content management system (CMS) written in PHP that uses a MySQL database. Features include a plugin architecture and a template system, referred to within WordPress as Themes. WordPress was created as a blog-publishing system but has evolved to support other web content types including more traditional mailing lists and forums, media galleries, membership sites, learning management systems (LMS) and online stores.

HTTPD:-

HTTP Daemon is a software program that runs in the background of a web server and waits for the incoming server requests. The daemon answers the request automatically and serves the hypertext and multimedia documents over the Internet using HTTP.

PHP :-

It is a general-purpose scripting language especially suited to web development. It was created by Danish-Canadian programmer Rasmus Lerdorf in 1994 The PHP reference implementation is now produced by The PHP Group.[7] PHP originally stood for Personal Home Page, but it now stands for the recursive initialism PHP: Hypertext Preprocessor.

MySQL:-

It is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data.

Steps to do:-

---> Create an AWS EC2 instance

---> Configure the instance with Apache Webserver.

---> Download php application name "WordPress".

---> As WordPress stores data at the backend in the MySQL database server. Therefore, you need to set up a MySQL server using AWS RDS service using Free Tier.

---> Provide the endpoint/connection string to the WordPress application to make it work.

Let's jump to the practical part:-

Here I am first going to launch one ec2 instance.

Here you can see that the ec2 instance(Wordpress) has been launched successfully...

---

Configure this instance with apache webserver. So first install apache webserver

Command :- yum install httpd

Now I am going to download the php application name "WordPress". But first, I have to install some dependencies.

Now I am going to download WordPress (tar file )

Here I am extract that file to /var/www/html directory .

commnd :- tar -xvf latest.tar.gz -C /var/www/html

Command to start httpd service :- systemctl start httpd 

Here file has been extracted successfully and httpd service has also started.

Setup a MySQL server using AWS RDS service.

Choose the MySQL version which you want.

Configure RDS like the name of our server and the user name and password of our database that we can create inside our server.

Choose your vpc, subnet, and vpc security group.

Here our RDS is configured Successfully

Now here copy the endpoint, which will be used in the configuration of WordPress. With the help of endpoint, we can integrate MySQL with WordPress.

Configure Wordpress:-Provide basic information like database name, username and password. and for the database host, we have to provide the endpoint which we copied above.

From here u can see that my Wordpress application has been worked successfullyand here my whole setup is done

Thank you my reading my article 🙌🙌