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!

…

jHeidi Mobi has been released for the Apple iPhone!

jHeidi is the only database front-end to provide Oracle and MySQL access in a mobile application. HeidiSQL and jHeidi users will feel right at home as the mobile interface follows the layout of the user friendly HeidiSQL and jHeidi desktop applications.

Download jHeidi Mobi from iTunes app store today!

More info at jheidi.com

There are times when auto increment is not sufficient. And there are times when what you need is actually a sequence. Unfortunately MySQL doesn’t have support for sequence. Having been working on PostgreSQL database as well, I found that it’s nextval() function is pretty nice. So in this article, I’d like to emulate (or implement) […]