DevOps Project — Implement MySQL Master/Slave On EC2s

Real World DevOps Project series

I’d like to share with you some of the powerful learnings I’ve gained from my extensive journey working on and experiencing various Cloud DevOps projects throughout my career. Hopefully these insights will serve as a guiding light to all those seeking to make a difference in the world of Cloud DevOps.

Project Description

Design a MySQL Database server on AWS EC2 with the following features:

1. Two Master-Slave MySQL servers with streaming replication enabled.
2. The ability to switch the master should also be shared.
3. Backups should be maintained on the slave server and copied to an AWS S3 bucket.
4. Monitoring should be enabled with Datadog.

High-level Architecture Design

Here is the high level architecture design for MySQL Database server on AWS EC2 with the mentioned features:

                            ┌───────────┐       ┌───────────┐
                            │  Master 1 │ ◄───► │   Slave 1 │
                            └───────────┘       └───────────┘
                                   ▲                    ▲…