Rolling out Database-as-a-Service using ProxySQL and Orchestrator

Tuesday 3:20PM-4:10PM

@ Swift Suite 1

MySQL / MariaDB

50 minutes conference

Beginner

Tracks:
Developer

Currently we are in the process of rolling out of a new MySQL database layer on our own private cloud. We are the 2nd largest university in Belgium and we have a wide variety of applications running on MySQL. Some are in-house development that we can control and some are external or closed source tools we just have to run. We also opened up the infrastructure for employees and researchers within the university as a service to our internal community.

Our solution is build on virtual servers with network file systems and consists out of open source tools. We added a proxy layer based on ProxySQL to separate of our MySQL topology from the application layer. This because not all applications were build with read-write splitting capabilities or were too hard to reconfigure automatically. We implemented Orchestrator for topology management and introduced Percona Xtrabackup as our primary backup solution. The entire infrastructure is managed using puppet.


Speakers

Matthias Crauwels

Matthias Crauwels (Pythian)

MySQL Database Consultant

Biography:

Since the age of 10 I've always been passionate about computers. I've been working with them ever since. In 2005 I got my degree in computer science. I used to work at a major Belgian university where I was developing the e-learning applications. In that position I was the one who looked after the databases. From there on I grew to be their MySQL DBA. Very recently I left the university and joined Pythian as a MySQL Database Consultant.


Slides



  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA