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.
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.
Launch EC2 instances for the database in 2 different availability zones along with an application server instance.
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.
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.
Use a Private Hosted Zone in Route 53 to create a DNS entry with a simple routing policy.
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.
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.