DataOps Barcelona 2018 - Implementing MySQL Database-as-a-Service using open source tools

Implementing MySQL Database-as-a-Service using open source tools
For a project, we have been setting up new MySQL database layer on a cloud environment. This solution is built on virtual machines and consists solely out of open source tools. We implemented a proxy layer based on ProxySQL to create a separation of the MySQL topology from the application layer. Not all applications are built with read-write splitting capabilities or are too hard to reconfigure automatically, the proxy layer helps us with routing the traffic to the correct database servers. For topology management, we use Orchestrator, currently developed by the Database Infrastructure Team at GitHub. Other tools include Percona Xtrabackup as primary backup solution and Percona Toolkit to help performing maintenance in the environment. The entire infrastructure is managed using Puppet. We have developed some open source Puppet modules to be able to implement this all. By Matthias Crauwels MySQL Database Consultant, Pythian at DataOpsn at DataOps.Barcelona 2018 - June 21 - 11:50 – 12:30