I fixed a couple of typos in my book No Lobbyists As Such - The War over Software Patents in the European Union. Thanks to Marco Menardi for having pointed me to those typos.

Continuent Ships uni/cluster for MySQL / PostgreSQL , Continuent (Press Releases)

When open source is not enough, The Register, Nick Kew (Article)

Ludd vs. open source, ZDNet, Dana Blankenhorn (Blog)

On Red Hat and Commercial Open Source, JM’s Good Times, John Mark Walker (Blog)

JRuby Steps Into the Sun, Headius, …

I have a number of PHP related speaking gigs coming up:

• DC PHP
• ApacheCon
• Zend/PHP Conference

(more…)

Next Monday's MySQL Meetup in San Francisco should be lots of fun. We'll meet at JasperSoft (303 2nd Street, Suite 450) at 7:00 PM, Mon 11 Sep., and have special guest Teodor Danciu, the creator and architect of Jasper Reports. The guys from JasperSoft will also show off some freely available reports for Bugzilla, and I'm going to give a quick 5-slide presentation on the MySQL Roadmap.

Trudy Pelzer, Engineering Project Manager extraordinaire at MySQL, has added a new section to the Forge wiki detailing the design specs for a proposed simple data auditing functionality for future versions of MySQL. Feel free to provide Trudy your feedback on the proposal and comment either on the Wiki itself, or email Trudy personally at trudy at mysql dot com. What exactly is the simple data auditing functionality?

Well, the proposal outlines essentially an updated logging mechanism that combines some of the features of the slow query log, general query log, and other mechanisms into a method of auditing commands, authentication, and even errors, to log files (or tables) within the server. Essentially, we're talking about writing log tables of everything that goes on inside the server, to ensure that in the case of an audit or a security breach, it is …

I'll be giving a presentation on MySQL performance tuning at the Ohio LinuxFest on September 30th. It will be a discussion about performance tuning guidelines, indexing concepts, benchmarking and profiling guidelines, and other such goodies. There will be some big names giving sessions at the conference, including Jon "maddog" Hall, Jeff Waugh and Jorge Castro from Ubuntu. Come on down and say Hi. Admission is free, so no excuses!

Have you ever seen index which refused to be used even if there is every reason for it to work (from the glance view):

PLAIN TEXT SQL:

1. mysql> EXPLAIN SELECT * FROM article WHERE article_id=10;
2. +----+-------------+---------+------+---------------+------+---------+------+-------+-------------+
3. | id | select_type | TABLE   | type | possible_keys | KEY  | key_len | ref  | rows  | Extra       |
4. +----+-------------+---------+------+---------------+------+---------+------+-------+-------------+
5. |  1 | SIMPLE      | article | ALL  | PRIMARY       | NULL | NULL    | NULL | 93490 | USING WHERE |
6. +----+-------------+---------+------+---------------+------+---------+------+-------+-------------+
7. 1 row IN SET (0.00 sec)

…

The ninth edition of Log Buffer, the weekly review of database blogs, is now available at Daniel Schneller’s Blog.

As did last week's Craig Mullins of dbazine.com I wrote a short post about the LogBuffer recently when I found it in my Blog's referrer list and was promptly asked if I would like to compile one myself.

So here am I am, welcoming all of you to the the 9th issue of the Log Buffer, a Carnival of the Vanities for the DBA community. Once again you will find a plethora of links to all sorts of information on the one thing that keeps many of us both fed and sometimes close to blank despair.

Myself being some sort of a mixture between a software developer and database admin I have had a fair amount of time over the last years to get experience …

So I have been really busy lately dealing with a bunch of stuff including having to reset replication (twice) on some of the slaves that started lagging behind seriously. While I am determined to find and fix this replication lag issue, the majority of it comes from the huge spec differences between the master and the slaves.

Anyway, yesterday I got my plane ticket to go to MySQL Camp which is really exciting. I will be arriving there on Thursday night and leaving Sunday night on an overnight flight.

Last time when I blogged I was writing about MySQL benchmarking, so I will try to pick up where I left off.

I was having some compile issues when trying to compile sysbench on Solaris. When I was running ./configure I was getting the following warnings:

###############################
./configure output …