I occasionally (as time permits) help out companies with their
MySQL needs. I specialize in performance tuning and replication but
can handle nearly all aspects of MySQL on Linux/Unix systems. Here
are some of my current and past clients.
Contact me for
rates and availability.
Here's a brief listing of the MySQL related tools I've built.
Click on the links for more detailed pages, downloads, and so on.
A clone of the top program which can be used to monitor
what your MySQL server is doing. It lists active threads (which you
can filter and even kill), performance statistics, and more.
For MySQL 3.23.xx, setting up replication can be a pain because you
need to generate an initial (consistent) snapshot of your data to load
onto your slave(s). You also need to make sure the binary log on the
master reflects the exact time at which you took the snapshot.
mysqlsnapshot automates the process.
mysqlsnapshot is also a great alternative to mysqlhotcopy for performing
backups of a live MySQL server. mysqlsnapshot used to be known as
myrepl, but this is a more descriptive name.
A a benchmarking, stress testing, and load generation tool for MySQL
developed by Sasha
Pachev but hosted here and featured in chapter 3 (Benchmarking) of
High Performance MySQL.
Spice up your .sig file with a single line of performance stats
about your favorite MySQL server. You can use it to brag... Or get
past the SPAM filter on the MySQL mailing lists... Or just for the
heck of it.
DBIx::DWIW (on CPAN)
A DBI wrapper from MySQL to Do What I Want (DWIW). This was developed
during my day job (Yahoo
Finance at the time). It is described in my "Building Maintainable and Fault Tolerant
MySQL Applications with Perl" presentation.
Here's a list of the stuff I've written about MySQL.
The book I've been hacking at off and on for 2 years is nearly
complete! You can pre-order
today from Amazon.com and be one of the first kids on the block
with a copy.
There will also be a companion web site launching in January
New in MySQL 4.0
An overview of major new features in 4.0 and a peek ahead to version
4.1. Published in the September 2002 issue of Linux Magazine.
Administration Made Easy
A review of PHPMyAdmin in the July 2002 issue of Linux
Performance Tuning: Making sure your MySQL server flies
Published in the December 2001 issue of Linux Magazine. This article
covers server-side tuning of MySQL's various buffers and caches.
Performance Tuning: How to Write Efficient MySQL Applications
Published in the June 2000 issue of Linux Magazine. This article covers basic application design and optimization techniques.
Here's a list of the presentations I've written about MySQL, listed
from newest to oldest..
Scaling MySQL and PHP
Presented on Thursday, October 24th, at the 2002 PHP Conference in
Milbrae, CA. The presentation was 90 minutes long.
Managing MySQL Replication
Presented on Friday, July 26th at the 2002 O'Reilly Open Source Convention in San Diego, CA. The presentation lasted 90 minutes.
MySQL Backup and Recovery
Presented on Wednesday, July 24th at the 2002 O'Reilly Open Source
Convention in San Diego, CA. The presentation lasted 45 minutes.
Presented on Monday, July 22nd at the 2002 O'Reilly Open Source
Convention in San Diego, CA. The presentation lasted 3 hours (180
What's new in MySQL 4.0
Presented at a Yahoo Engineering talk on Thursday, June 20th 2002. It
covers MySQL 4.0's major new features and enhancements. It also
briefly touches on what's coming in 4.1 and beyond. Some of the
material isn't terribly useful without the audio (me) that goes with
it. But someone might find it useful. There's little if anything
that's Yahoo-specific in it.
Perl & MySQL in Yahoo! Finance
Presented at the Silicon
Valley Perl Mongers on June 4th, 2002. This is a revised and
updated version of the previous presentation. It covers the recent
additions to DBIx::DWIW and
goes a bit more in-depth on the Perl side of things.
Building Maintainable and Fault
Tolerant MySQL Applications with Perl
This was my
presentation at the 2nd annual Open Source Database Summit (OSDS) in
Providence, Rhode Island in September of 2001.