Lab: Build a Database Server

Note: This blog is for you to make your life easier. 

Don't make your life complicated, just enjoy the blog. ^_^

Please pardon my simplicity of my own blog and look for the content. 

To make it more easier for you just click one photos, follow then scroll. ⏩

Enjoy reading! ^_^

Build a Database Server

This lab is designed to reinforce the concept of leveraging an AWS-managed database instance for solving relational database needs.

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, which allows you to focus on your applications and business. Amazon RDS provides you with six familiar database engines to choose from: Amazon Aurora, Oracle, Microsoft SQL Server, PostgreSQL, MySQL and MariaDB.

Objectives

• Launch an Amazon RDS DB instance with high availability.
• Configure the DB instance to permit connections from your web server.
• Open a web application and interact with your database.

First, Access your AWS Management Console.

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

We will create a Security Group for RDS DB instance, go to AWS Management Console then Services, click VPC. Go to Create Security Group and add the following below. 

After creating, go to DB Security Group then Inbound Rules tab and Edit rules. You will be able to create MySQL Aurora.

Task 2: Create a DB Subnet Group

On the Services menu click RDS then Subnet groups. We will be creating DB Subnet Group as part of the requirements.

Task 3: Create an Amazon RDS DB Instance

Now, we will configure and launch a Multi-AZ Amazon RDS for MySQL database instance.

Amazon RDS Multi-AZ deployments provide enhanced availability and durability for Database (DB) instances, making them a natural fit for production database workloads. When you provision a Multi-AZ DB instance, Amazon RDS automatically creates a primary DB instance and synchronously replicates the data to a standby instance in a different Availability Zone (AZ).

From your current browser, go to Database then Create Database, this will enable you to create an Amazon RDS DB Instance.

Note that it will take approximately 4 minutes for the database to be available. This will be the deployment process is deploying a database in two different availability zones.

After creating database, click lab-db (the link itself). Then go to Modify, Connectivity & Security section and copy the endpoint field.

Task 4: Interact with Your Database

The last task is opening the web application running in web server and configuring it to use the database.

To copy the WebsServer IP address, click the Vocareum tab then Details & Show. Proceed with RDS link at the top of the page and configure.

Problems Encountered:

NONE.

Lesson Learned:

This lab we created is a DB instance in an isolated database environment running in the cloud. It is the basic building block of Amazon RDS. A DB instance can contain multiple user-created databases, and can be accessed using the same client tools and applications you might use to access a standalone database instance. DB instances are simple to create and modify with the Amazon AWS command line tools, Amazon RDS API operations, or the AWS Management Console.

References:

AWS Website.

Thanks for visiting my blog.

Email me at: aileen-pacia@live.nmit.ac.nz

“I can do all things through Christ who strengthens me.”

Philippians 4:13