MySQL Master / Slave Deployment in Amazon AWS

In this video I deploy MySQL to Amazon AWS. I start off simple and deploy a single instance of MySQL in a single AWS Availability Zone (AZ). Then I scale the database by deploying a "master / slave" MySQL replicated server where the master and slave are deployed to two AWS AZs. This configuration allows the application to separate database read operations from writes. With this knowledge you could add additional read-only replicas (slaves). We also configure Laravel to take advantage of our replicas.
This is a continuation of the previous videos in the series where we are developing our capability to deploy an application to Amazon AWS. Previously we covered:
- 7 Steps To Deploy Laravel to AWS (8 videos, start here: • 2024 - 7 Steps To Depl... )
- DevOps and Infrastructure As Code (4 videos, start here: • Infrastructure as Code... )
- DevOps - Continuous Integration / Continuous Delivery (3 videos, start here: • DevOps - Continuous In... )
#mysql #replication #replica #master #slave #masterslave #devops
#database #scaling #laravel
#technologysandbox