Lab 6 1 Build a Database Server - max-gallagher/SYS-360 GitHub Wiki

Task 1: Create a Security Group for the RDS DB Instance

  • Navigate to VPC on the AWS dashboard then go to the security groups section

  • Create a new security group named DB Security Group and set the VPC to Lab VPC

    • Set an inbound rule to access from the "Web Security Group" as shown below

image

  • Now finish creating the security group

image

Task 2: Create a DB Subnet Group

  • Navigate to the RDS service from the management console and then go to the subnet groups section

  • Create a new subnet group named DB-Subnet-Group and set the VPC to the Lab VPC

    • In the add subnets section add both us-east-1a and us-east-1b availability zones

    • Then in the subnets section add both 10.0.3.0 and 10.0.1.0 subnets

image

  • Finish creating the Subnet group

image

Task 3: Create an Amazon RDS DB Instance

  • Stay in Amazon RDS from the last step and navigate to Databases

  • Create a new database

    • Set the engine to MySQL

    • Set the templet to Dev/Test

    • Set availability and durability to Multi-AZ DB instance

    • In the settings section use the following configurations

      • Instance Identifier: lab-db
      • Master username: main
      • Master password: lab-password (please do not do this in normal use)
      • Confirm password: lab-password

    • Set the DB instance class to Burstable classes and db.t3.micro

    • Set storage to a 20gb General Purpose SSD

    • Under connectivity set VPC to Lab VPC

    • Set the VPC security group to the group we made earlier

    • Under monitoring turn off enable enhanced monitoring

    • Under Additional Configuration set the initial database name to lab and uncheck both automatic backups and encryption (this is just for the case of the lab were we dont need security and just want everything to be up and running quickly)

    • Create the database

  • Click on the link to lab-db and make sure that everything is up and running by waiting until info is set to Modifying or Available

  • Once that is done go to connectivity and security and copy the endpoint field and paste it somewhere for later use.

    • Endpoint: lab-db.cxmwoa044j30.us-east-1.rds.amazonaws.com

Task 4: Interact with Your Database

  • On the page for the lab click AWS Details up top and copy the WebServer IP Address field

    • In a new tab paste the webserver address and you should be brought to a webapp that shows information about your ec2 instance

  • Once you are on the Webserver page click RDS at the top of the page and fill in the information as shown below using the username and password from earlier in the lab and the endpoint we got from our database

image

  • Add and remove contacts as you wish to test

Deliverables

Submission: Screenshot of address book with contacts including your name or other identifying info:

(Dont worry I used a fake phone number)

image