AWS Labs
Labs badge iconLAB

Build Your Own Highly Available Database Servers on Amazon EC2

In this lab, you’ll practice setting up a high-availability database on EC2 instances. When you’re finished with this lab, you’ll have a database server in two different availability zones with a DNS address to connect to the database.

* Our Labs are Available for Enterprise and Professional plans only.
Terms and conditions apply.
Contact sales
Labs - Build Your Own Highly Available Database Servers on Amazon EC2

Lab info

Rating (56)
Level
Beginner
Duration
1h 5m
Released
Jul 06, 2021

Lab author

Lab Author: Craig Golightly
Craig Golightly
Craig is passionate about solving problems with the right tools. He has over 20 years of software development experience with large enterprises and small startups on everything from search engines to fighter jets. He has a bachelor's and master's degree in computer science with extensive experience in AWS, microservices, and artificial intelligence. Craig enjoys teaching and mentoring others so they can save time and accomplish their goals faster.
Challenge

Infrastructure Setup

Launch EC2 instances for the database in 2 different availability zones along with an application server instance.

Challenge

Install and Configure a Database Engine on the DB1 EC2 Instance

Modify the default Security Group so you can access the EC2 machines. Install and configure a database engine on the first database server and insert data to distinguish between the two database servers.

Challenge

Install and Configure a Database Engine on the DB2 EC2 Instance

Install and configure a database engine on the second database server and insert data to distinguish between the two database servers.

Challenge

DNS Configuration

Use a Private Hosted Zone in Route 53 to create a DNS entry with a simple routing policy.

Challenge

Application Connection and Failover

Simulate a database outage and update the DNS entry to failover from the first to the second database server.

Labs - code icon

Provided environment for hands-on practice

We will provide the credentials and environment necessary for you to practice right within your browser.

Labs - list icon

Guided walkthrough

Follow along with the author’s guided walkthrough and build something new in your provided environment!

Labs - analytic icon

Did you know?

On average, you retain 75% more of your learning if you get time for practice.

Recommended prerequisites

  • Have an SSH client on your machine
  • Know how to SSH to an EC2 instance

Start learning by doing today

Contact sales

Contact Sales

Loading form...

If this message remains, it may be due to cookies being disabled or to an ad blocker.

Close button

Ready to skill up
your entire team?

10
Subscriptions
Continue to checkout Continue to checkout
Cancel

With your Pluralsight plan, you can:

With your 14-day pilot, you can:

  • Access thousands of videos to develop critical skills
  • Give up to 10 users access to thousands of video courses
  • Practice and apply skills with interactive courses and projects
  • See skills, usage, and trend data for your teams
  • Prepare for certifications with industry-leading practice exams
  • Measure proficiency across skills and roles
  • Align learning to your goals with paths and channels

Ready to skill up
your entire team?

10
Subscriptions
Continue to checkout
Cancel

With your Pluralsight plan, you can:

With your 14-day pilot, you can:

  • Access thousands of videos to develop critical skills
  • Give up to 10 users access to thousands of video courses
  • Practice and apply skills with interactive courses and projects
  • See skills, usage, and trend data for your teams
  • Prepare for certifications with industry-leading practice exams
  • Measure proficiency across skills and roles
  • Align learning to your goals with paths and channels
Copyright © 2004 - 2022 Pluralsight LLC. All rights reserved.