common_schema: DBA's framework for MySQL

Tools
2 April 2:20PM - 3:10PM @ Ballroom G

Experience level: 
Intermediate
Duration: 
50 minutes conference
This session introduces the common_schema project: a self contained schema which leverages the DBA and the developer capabilities through a set of sophisticated views, routines and a specialized scripting language (QueryScript), simplifying MySQL server administration and analysis. common_schema is aimed to be imported onto any MySQL server, on any platform. Along with INFORMATION_SCHEMA and PERFORMANCE_SCHEMA, common_schema becomes a valuable tool for one's server. In this session we will see how common_schema adds new capabilities to the MySQL server or otherwise makes complex tasks easy. We will review: * How to install (import) common_schema * Schema analysis views * Process & security views and routines * Status monitoring and transaction analysis * SQL generating views and eval() * QueryScript: an SQL based scripting language * Schema versioning and migration common_schema is free and open source. "The common_schema is to MySQL as jQuery is to javaScript" - High Performance MySQL, 3rd Edition, Baron Schwartz et al.


Speakers

Senior Infrastructure Engineer, GitHub
Biography: 
Shlomi is an engineer and a database geek. He is an active MySQL community member, authors gh-ost, orchestrator, common_schema and other open source tools, and blogs at <a href="http://openark.org">http://openark.org</a>. Shlomi is recipient of Oracle ACE, Oracle Technologist of the Year, and MySQL Community Member of the Year awards. He works at GitHub on the database infrastructure team.

Slides