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.
Terms and conditions apply.
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.
Provided environment for hands-on practice
We will provide the credentials and environment necessary for you to practice right within your browser.
Guided walkthrough
Follow along with the author’s guided walkthrough and build something new in your provided environment!
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