Creating an RDS Instance
Step 1: Creating an RDS instance.
- Click on the RDS service under Database.
- Click on the Dashboard appearing on the left side of the console, then click on the Create Database button.
- Choose the MySQL database.
- Check the box of "Only enable options eligible for RDS Free Usage Tier", and then click on the Next.
- Specify DB details. Keep all the details as default. Enter the DB instance identifier which would be unique for all DB instances owned by your AWS account.
- Configure advanced settings of your RDS instance. Keep all the settings as default except that you need to enter the database name.
- Click on the Create Database button.
The above screen shows that your DB instance has been created.
Step 2: Creating an EC2 instance.
- Click on the EC2 service.
- Launch an instance.
- Choose an Amazon Machine Image (AMI).
- Configure Instance details. Keep all the details as default.
- (Optional) Add EBS Volume.
- Add Tags.
- Configure Security group. Suppose I create a new group whose name is WebServer.
- Click on the Launch button.
Step 3: Installing PHP.
- Open the Putty.
- Add the hostname. i.e., ec2-user@ip_address.
- Run the command sudo su to reach the root level.
- Install the PHP and server by running the command yum install httpd php php-mysql -y.
The above screen shows that the installation of php has been completed.
- Run the command yum update -y to update the EC2 instance.
- Run the command service httpd start to start the server.
- Put the php information to the index.html fileby running the command echo ?<?php phpinfo();?>? > /var/www/html/index.php.
- Paste the public IP address of an ec2 instance to the clipboard of a web browser.
Step 4: Connect an EC2 instance to an RDS instance.
- Create a connect.php file.
- Now, copy the IP address of an ec2 instance with the forward slash, and then connect.php, i.e., 126.96.36.199/connect.php.
The above screen shows that an EC2 instance is not connected to an RDS instance because of the following reasons:
- Both RDS instance and EC2 instance contains different security groups.
- Update the hostname with the end point of RDS instance.
- Click on the inbound rule, and then Edit the rule. This rule is used to achieve communication between two different security groups.
- The screen shown below shows that the hostname has been updated with the end point of RDS instance.
- Now, copy the public IP address of EC2 instance with the forward slash, and then connect.php, i.e., 188.8.131.52/connect.php.
The above screen shows that an EC2 instance has been connected to your RDS instance.