• Server configuration management via Puppet
• Tomcat high availability via Keepalived
• Wrote Java mysql proxy with query cache support
• Squid based reverse caching proxy for assets
• Multimaster MySQL setup over 10 servers
• Monitoring via Nagios (NRPE) and Diamond
• Networking architecture improvements targeting latency
• Developed backup, archival, and validation procedures
• Improved queries, indexes, and database schemas
• Setup and administered firewalls using Shorewall
• MySQL replication integrity testing via pt-table-checksum
• OpenVPN deployment including limited network access
• Capacity and growth planning, Bottleneck identification
• Automated schema change timing and testing utility
• Automated database query log processing in Python
• PXE kickstarting of CentOS servers
• Subversion server administration and replication

• Managed team of 5 developers
• Code-base of approximately 700,000 lines
• MySQL database of approximately 3.5 terabytes of data
• Development of staging process
• Lead the design of a middle tier unified API layer
• Reduced average page time from 4.4 seconds to 1.5
• Refactor of existing code to reduce memory footprint
• Development of customized live auction system
• Deployment scripts to standardize code roll outs
• Designed an site resource limits system
• Enhanced shared security framework
• Implemented per user 'click stream' tracking
• Refactor billing system to increase reliability
• Utilized SEO improvements to increase placement
• Increased ad revenue by following UX research
• Wrote Memcache object cache layer
• Integrated Jquery based web 2.0 frontend elements

A high performance daemon that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication. Written with a modular, threaded structure, you can write plugins to convert queries, update/modify result sets, redirect traffic, automatically shard, anything you want.

Diamond is a python daemon that collects system metrics and publishes them to Graphite (and others). It is capable of collecting cpu, memory, network, i/o, load and disk metrics. Additionally, it features an API for implementing custom collectors for gathering metrics from almost any source.

Course Description

An intensive one-day workshop for MySQL database administrators and systems administrators that covers InnoDB and XtraDB, the most popular storage engines for MySQL.

• Learn to be systematic about fixing performance problems
• Optimize query performance
• Understand the basic operation of InnoDB - including how data is stored on disk and in memory
• Understand what InnoDB does internally when data is written, and how features like the transaction log files and undo space work
• Understand how key features of InnoDB work, including the buffer pool, transaction logs, clustered indexes, insert buffer, adaptive hash, double write buffer
• Learn to read diagnostic Information from InnoDB and make informed decisions while tuning configuration
• Discover how XtraDB, and the Percona and Google patches will provide you better diagnostics and performance