Join 4,000+ technologists, decision makers and community members in Raleigh, NC

October 13 - 15

Register

Databases

Implementing MySQL Database-as-a-Service using open source tools

Matthias Crauwels   

This session handle the setup of a MySQL-as-a-service setup 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.