MySQL infrastructure testing automation at GitHub
Jul 6, 2017GitHub Engineering

Summary
This post details the automation of MySQL infrastructure testing at GitHub. It covers the use of Percona Xtrabackup for full and logical backups, Hubot for restoring tables to non-production databases, and delayed replicas as a safeguard against erroneous queries. It also describes the setup of a production-like test cluster for continuous failover testing using Orchestrator, and the automation of adding new replicas via chat commands.