MySQL Sandbox in docker

The idea for this project is playing to change replication topology, make a failover, recover a master, scale slaves, everything with traffic simulated.

MySQL Sandbox run in docker and has inside:

• MySQL Server V-5.7
• Orchestrator V-3.2.6
• ProxySQL (Install latest version 2.*)
• Consul V-1.4.2

We use a multi-container Docker to defining and running any services for MySQL, one service for Orchestrator and one for ProxySQL. With any container of MySQL you have a possibility to play with slaves, co-master, and intermediate master.

Limitation:

• Only run MySQL 5.7.
• Only scale MySQL containers.
• Only have high availability for MySQL.
• Only run one container for ProxySQL, Orchestrator and Consul.

Usage

To simplify the usage, is implemented Makefile, and you have the all commands necessary to playing with this sandbox. For example, you can; up, down and scale containers or enter in the bash. Change topology replication or enter in MySQL or ProxySQL and more...