AWS RDS (Relational Database Service) With WordPress..

Using MySQL Database ..

Hello All..!!

Here I am come with new concept or service of AWS which gives us an Database storing device.

So here we are going to do one task that is given below..

Before start our main practical first we have to clear the basic concept related with that practical. So let’s start..

DataBase :

A database is an organized collection of data so that it can be easily accessed and managed. You can organize data into tables, rows, columns, and index it to make it easier to find relevant information. Database handlers create a database in such a way that only one set of software programs provides access to data to all the users.

RDS in AWS :

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the AWS Cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.

Amazon Relational Database Service is a distributed relational database service by Amazon Web Services. It is a web service running “in the cloud” designed to simplify the setup, operation, and scaling of a relational database for use in applications.

WordPress :

WordPress is a free and open-source content management system written in PHP and paired with a MySQL or MariaDB database. Features include a plugin architecture and a template system, referred to within WordPress as Themes.

Now let’s start our practical..

First create two security group one for RDS database and one for backend instance.

  1. For Backend instance : allow ssh and http port.

2. For RDS Database : MYSQL/Aurora

Here we create this security group because in that database lot’s of important information we store and there is an one option in protocol selection that is MYSQL/Aurora which gives all over security to our database. And here we added custom SG which we created for EC2 instance.

Now lunch a new EC2 instance .

Here we are using the Amazon Linux 2 AMI image for lunching instance.

Now use instance type having free tier eligibility.

Now in step of configure instance details go to advance details and in user data add below code do run commands for installing wordpress.

After that add storage and give the tag to our instance.And then in security group give security group which we already created above.

Now launch instance...

Here Our instance name is “ EC2_WP ” .

Now check the httpd service configured and running properly or not by running command ..

“ systemctl status httpd ”

Here our httpd service running great.

Now we can create new Database using RDS service of AWS. You just follow below steps to lunch database.

First go to RDS service and select create database option .Here we are using MySQL database.

Now select version and template.

Now give name to our database server and give also give credentials like username and password.

After that add database instance size or give database instance type .

Now add storage.

Now fill up the option for connectivity.

Now select the authentication option.

Now create database in Additional configuration.

Now add values in Backup option.

And last option that is maintenance keep it as it is.

And select option create database for creating the database.

Now our database created successfully.

Here we did both things the EC2 with httpd service started and the RDS instance for DataBase.

After configure the wordpress in Our EC2 insatnce.For that first step is download the software of wordpress in that ec2 instance.

After that extract this package of wordpress in /var/www/html folder.

Now you can see wordpress installed.

Now access the wordpress from the browser by giving IP address of that instance like ..

“ (ip address)/wordpress/wp-admin/setup-configure.php ”

And after we click on Let’s go option then it go to next page .

Here we have to give our database name , username , password and database host . Database host name we can found in RDS service. In RDS service click on our database server and there is an one option that is connectivity and security in that we found the endpoint it means the database host.

Now after putting all the requirements click on submit. After that it goes to next page.

Here we have to create one file in /var/www/html folder having name wp-config.php and copy the code given in that block and paste on that file. And then press on Run the installation option and it ask for authentication and we can access the wordpress.

That Set …

We are done with our task and we create an database successfully.I hope this article help you..

If this article , will clear your concept ,then please clap it . Also if you have any query then please tell me in LinkedIn..

Thanks, Everyone for reading. That’s all…

Computer Engineering Student.