AWS MySQL Cluster Automation (Proxy & Gatekeeper Patterns)

This project automates the deployment of a distributed MySQL Cluster on AWS EC2. It implements the Proxy pattern for load balancing (Read/Write splitting) and the Gatekeeper pattern for security.

Architecture

The automation script provisions 5 EC2 instances (t3.micro):

1. Manager: MySQL Master (Write operations).
2. Worker 1 & 2: MySQL Slaves (Read operations).
3. Proxy: Routes traffic (Trusted Host).
4. Gatekeeper: Public entry point (Security validator).

Prerequisites

1. Python 3.8+ installed.
2. AWS Account with appropriate permissions (EC2, Security Groups).
3. AWS Credentials configured locally (via aws configure or ~/.aws/credentials).
4. A key pair created in AWS named test.

Installation

1. Clone the repository or download the source code.
2. Place your AWS private key file (test.pem) in the same directory as the script.
3. Install dependencies:

   pip install -r requirements.txt

Configuration

Open main.py and verify the configuration constants at the top of the file:

KEY_NAME = 'test'          # Must match your AWS Key Pair name
KEY_PATH = './test.pem'    # Path to your local .pem file
REGION = 'us-east-1'       # Desired AWS Region