Course description

In this hands-on lab, you will configure MySQL Master-Slave replication to enhance database scalability and availability. Starting with Terraform, you'll provision two EC2 instances in the same VPC: one as the master and one as the slave. You'll install and configure MySQL on both servers, create a replication user, and enable binary logging on the master. You'll then capture the master's log position, configure the slave to replicate from the master, and start the replication process. Through testing, you'll verify that data written to the master is automatically synchronized to the slave. By the end, you'll have a fully functional MySQL replication setup ready for production use.

Additionally, all learners receive dedicated online support through our Slack workspace where you can ask questions, get troubleshooting help, and interact with our team throughout the entire project.

Click here to access Slack workspace link

What will i learn?

• Provision MySQL master and slave instances using Terraform
• Configure MySQL binary logging and replication settings
• Create replication users and grant appropriate privileges
• Capture master log position and configure slave replication
• Start and verify MySQL replication status
• Test data synchronization and validate replication integrity
• Understand real-world use cases for MySQL replication

Frequently asked question