Using Docker for Fast and Easy Testing of MariaDB and MaxScale

DevOps
22 September 11:20AM - 12:10PM @ Winterthur

Duration: 
50 minutes conference
The ability to replicate the production environment in an isolated testing environment is a key factor for the success of any infrastructure (major or minor) component upgrade or replacement. Before introducing a new technology and deploying components into critical infrastructures, the maintainers must have a very deep knowledge of them. To reach this expertise it is really important to build and re-deploy the testing environment in an easy and fast way. In Colt Engine we experienced this situation when we decided to migrate all our hosting customers from MySQL 5.1 to MariaDB 10. During this presentation we will show how we used Docker and docker-compose to replicate our production infrastructure in a testing environment and how we used these technologies to dramatically increase our experience and knowledge around MaxScale. This speech will presents several real examples of different MaxScale use cases ranging from authentication to read-write splitting and about how we automated the provisioning of such configurations with Docker.


Speakers

Software Architect, Colt Engine s.r.l.
Andrea Tosatto is a software architect with a background experience in
formal methods for computer science and research.

He joined ColtEngine, an italian internet service provider based in Turin,
in 2015 as a member of the research and development team.
He started with a specific main role: the refactoring of Company's
core services from a monolithic framework to a service oriented architecture.

This first experience in the Company allows him to develop a deeper
experience with docker and twelve-factor applications.
Thanks to this personal growth, now he holds the task of product manager
for a new Company research project built on OpenStack.
Java Developer and MySQL/MariaDB DBA, Colt Engine
Alessandro Fustini is a certified MySQL 5.0 Database Administrator and Developer.
He works for ColtEngine, an italian internet service provider based in Turin, since 2004, when he joined the company as senior java developer and MySQL/MariaDB DBA. He designed and developed the core software infrastructure behind the company service offer maturing a strong experience in system integration. He is now leading the ColtEngine's research and development team exploring the forthcoming trends of the ICT, with a particular focus (and passion) on the MySQL ecosystem.

Slides