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.
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.