It’s been a while since I’ve sent any news about the MySQL Cacti Templates project I started a while ago. Here’s what’s new:

First of all, it’s not just MySQL templates anymore. It’s a generic framework and tools for creating templates, and I’ve written templates for Apache, Memcached, etc. I just haven’t publicized [...]

I was recently involved in a project where the main requirement was the smallest possible latency for queries. The queries were simple insert and update statements, the update being by primary key. The cluster was using regular Gigabits Ethernet and formed by 3 servers with 8 cores each, one Management node and 2 data nodes. Since throughput was not a concern, a design decision has been made to locate the MySQL daemons on the same servers as the data nodes, in order to save network hops. MySQL chooses the closest NDB data node as its transaction coordinators and the closest on will be reachable on localhost.

Apart from the architectural decision to host MySQL and the NDB nodes on the same boxes, we decided to benchmark the new real time options of NDB. The options are the following:

This Thursday, February 12th, I'll be giving a free webinar with Jimmy Guerrero on Scaling a PHP/MySQL application and discovering all the pain points. It's pretty much the same talk I gave the start-ups who showed up to the Hatchery/Sun Start-up Essentials Event in New York City last week (more on that later, I'm just recovering from being sick during that trip).

So let people who are novice/intermediate know to go sign up.

More on my New York/Boston tour when I get back to Montreal (on my way there now!)

Summary:Arjen would give me an earful if I got this wrong or poorly worded."OurDelta produces enhanced builds for MySQL, with OurDelta and third-party patches, for common production platforms" from http://ourdelta.org/aboutOver the next series of articles I am going to put the many additions to the MySQL 5.0 baseline through their paces on Amazon EC2.Using a base CentOS 4.4 I had lying around on

DTrace has been something that I’ve been trying to get into the MySQL server for more than a year now.

After a combination of my own patches and working with Mikael Ronstrom and Alexey Kopytov we finally have a suite of probes in MySQL 6.0.8. Better still, after a short hiatus while I was busy working on a million-and-one other things, the documentation for those probes is now available: Tracing mysqld with DTrace.

The documentation is comparatively light and deep all at the same time. It’s lightweight from the perspective that I’ve added very little detail on the mechanics of DTrace itself, since there is no need to replicate the excellent guides that Sun already provide on the topic. At the same time, I’ve tried to provide at least one (and sometimes two) D script examples for each of the groups of probes in the 6.0.8 release.

Summary: Arjen would give me an earful if I got this wrong or poorly worded. “OurDelta produces enhanced builds for MySQL, with OurDelta and third-party patches, for common production platforms” from http://ourdelta.org/about Over the next series of articles I am … Continue reading →

Today I have uploaded Q4M 0.8.4 to q4m.31tools.com. Prebuilt binaries for MySQL 5.1.31 running on linux (i386 or x86_64) and Mac OS X (x86) are available as well.

The release fixes crash on linux (i386) systems when a table becomes larger than 2GB. There are no changes for other platforms.

Here are the slides from yesterday’s presentation about horizontal database scaling through sharding at the mySQL dev room at FOSDEM 2009.

I’ve got a ton of notes and remarks to these slides, which will become available here soon.

I just got mail that my presentation on MySQL Monitoring ShootOut is currently being showcased on the 'Technology' page by the slideshare editorial team.

It's likely to be there for the next 16-20 hours...

Thnx folks !

Technorati Tags: fosdem presentation slideshare …

This week, Sun hosts a live webinar on accelerating MySQL and DRBD in scale-out environments, in which yours truly will be covering the DRBD part. Besides DRBD for Dolphin Express, the webinar will also cover how to use Dolphin Express to accelerate MySQL Cluster and MySQL Replication.

Registration for this webinar is now open. See you on Wednesday!

…