SYS 360 Lab 6 1: Build a Database Server - JadenGil/Jaden-Tech-Journal GitHub Wiki

Create a Security Group for the RDS DB Instance

In the search bar search for VPC and once on the VPC homepage select "Security Groups" and "Create Security Group"

The security group should have the following settings:

image

Create a DB Subnet Group

Now we can go back to the search bar and search for RDS once there select "Subnet Groups" on the side bar and then "Create DB subnet group"

The subnet group settings should be:

image

With that created we can now select "Databases" from the sidebar and then select "Create database"

Select MySQL as the engine:

image

Dev/Test as the template:

image

Under Availability and durability choose Multi-AZ DB instance:

image

The settings should be the following:

image

Instance settings:

image

Storage Settings:

image

Connectivity Settings:

image

Monitoring settings:

image

Additional Config Settings:

https://github.com/user-attachments/assets/de565f21-807b-49d1-a198-254ade407ee7

With all that done we will wait 4 minutes for it to finish:

image

Once done you will see this:

image

And you will want to paste the enpoint info

Interact with Your Database

To discover the WebServer IP address, choose the "i" AWS Details drop down menu above these instructions. Copy the IP address value and paste into a new tab:

image

On this page select "RDS" and enter the following information:

image

Then select "Submit"

You will then see the following:

image

Test things out by editing and removing the contacts

Deliverable:

image