alessandrob/rds-haproxy repository overview

⁠docker-rds-haproxy

a docker build of a customized haproxy for mysql connections that uses AWS APIs to discover RDS nodes

⁠Getting started

Install the docker toolset if you don't have it yet, or update it if it's not the latest and greatest with homebrew:

brew update && brew install docker docker-machine docker-compose

(or download the docker toolbox package at https://www.docker.com/products/docker-toolbox⁠)

Then, install the awscli⁠ and the ecscli⁠ if you intend to run this on ECS⁠.

⁠Test with docker-machine

docker-machine create local --driver virtualbox 

Once completed, just run

eval $(docker-machine env local)

to be able to access the docker daemon running on your docker machine and then

ENABLE_STATS=true DB_NODES="db1.example.com db2.example.com" docker-compose up -d && docker-compose logs

where DB_NODES is a space separate list of MySQL servers listening on port 3306 You can check the status of haproxy if you run open http://$(docker-machine ip local):8080/stats and connect to your mysql databases with mysql -h $(docker-machine ip local)

⁠Test with docker-machine on AWS

To test the environment on AWS, the simplest thing is to create an instance on your VPC still using docker machine:

docker-machine create --driver amazonec2 --amazonec2-iam-instance-profile <role-with-RDS-read-access> --amazonec2-vpc-id <vpc-where-your-RDS-instance-resides> --amazonec2-subnet-id <subnet-in-your-vpc> --amazonec2-region <region-of-your-vpc> --amazonec2-zone <the-zone-for-your-subnets> ec2-haproxy

After your docker machine is running, you can connect to the docker daemon running

eval $(docker-machine env ec2-haproxy)

Please note that docker machine will create a new security group (called docker-machine), which will need to have a rule created to allow access to port 3306 from your ip (for testing), and you will also need to allow access from that security group to your RDS security group on port 3306. After that, just run

ENABLE_STATS=true CLUSTER_ID="your-rds-cluster" docker-compose up -d && docker-compose logs

to start your containers and then mysql -h $(docker-machine ip ec2-haproxy) to connect to your cluster. The round robin policy will make so that each connection will be to a different node in your cluster.