Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

dbhell: a tiny Python framework for the administration and monitoring of farms of MySQL servers

dbhell: a tiny Python framework for the administration and monitoring of farms of MySQL servers

 4 October 7:30 PM - 8:30 PM
Experience level: 
Intermediate
Duration: 
Lightning Talk
Tracks:
Operations and Management
MySQL
Topics:
MySQL
Python
Tools and Techniques

Description

As the sole DBA for the Wikimedia Foundation, I faced the task of maintaining hundreds of busy MySQL servers, with only a handful home-made tools on different languages (bash, PHP, perl) and a few 3rd party utilities such as Percona Toolkit and XtraBackup. In order to get out of that administrator's hell, I wrote a basic, easy to use, tiny-scope API to be used as the base of all monitoring, alerting and management utilities, focused on query efficient, safeness of operations, and automatization; maybe someone else is interested?

Speakers

Jaime Crespo's picture

Jaime Crespo

Sr Database Administrator, Wikimedia Foundation

Biography:

Jaime works as the senior database administrator for the non-profit organization Wikimedia Foundation, host of Wikipedia and other similar open knowledge projects. His main topics of interest are MySQL query optimization and architectures for high availability. He is a former MySQL A.B./Sun Microsystems/Oracle/Percona instructor and consultant, and has also worked as an independent MySQL consultant at DBAhire.com.

Share this talk


Slides