Kristian Nielsen presented “Beyond MySQL GA: patches, storage engines, forks, and pre-releases”.
This included a history of current products:

Google Patches (5.0 & 5.1) included improvements in :

• statistics/monitoring
• lock contention
• binlog
• malloc()
• filesorts
• innodb I/O and wait statistics
• SHOW …STATISTICS statements
• smp scalability
• I/O scalability
• semisync replication
• many more

Percona Patches (5.0) focus on

• statistics/monitoring
• performance/scalability
• buffer pool content/mutexes
• microslow patch

These have been ported to 5.1 and mainly integrated into XtraDB.

EBay Patches (5.0) have included:

• variable length memory storage engine
• pool of threads

Fosdem 2010 was my 10th fosdem Edition (including the first OSDEM)
As every year Fosdem suffered even more from it's own success.

On Friday evening ther was the obligatory Beer event... however as people need to eat to .. the Devops crowd fled the scene

I had made reservations for a 20 something group and with the CentOS crowd joining us (as there was some overlap anyhow) we were 25 when we arrived in the restaurant .

Dinner and Discussions were great .. I learned about some new projects and we had some insightfull dicussions on how fat your thin foil should be ...

After dinner we went back to the Beer Event were lots of Free Beer was tasted ...

Saturday was the first full day of Fosdem, as usual Fosdem was the victim of it's own success , too much interresting stuff to see .. too little

The next presentation by Piotr Biel from Percona was on Multi-Master Manager for MySQL.

The introduction included a discussion of the popular MySQL HA solutions including:

• MySQL Master-slave replication with failover
• MMM managed bi-directional replication
• Heartbeat/SAN
• Heartbeat/DRBD
• NDB Cluster

A key problem that was clarified in the talk is the discussion of Multi-Master and this IS NOT master-master. You only write to a single node. With MySQL is this critical because MySQL replication does not manage collision detection.

The MMM Cluster Elements are:

• monitoring node
• database nodes

And the Application Components are:

• mon
• agent
• angel

MMM works with 3 layers.

• Network Layer – uses a

Following the opening keynote “Dolphins, now and beyond”, Marc Delisle presented on “State of phpMyAdmin”.

phpMyAdmin is an DBA administration tool for MySQL available today in 57 different languages. This is found today in many distributions, LAMP stack products and also in cpanel. The product is found at http://phpmyadmin.net.

There are current two versions, the legacy 2.x version to support older php 3.x & 4.x, The current version 3.x is for PHP 5.2 or greater.

The current UI includes some new features including.

• calendar input for date fields
• meta data for mime types e.g images, which is great for showing the output as an image, otherwise blob data
• Relational designer with

Fosdem is coming up again .. It's going to be the 10th edition already So it's going to be 2 days and nights of fun, tech and geek stuff

Lenz already posted the announcement , but allow me to recapitulate.

The MySQL & Friends meetup is on saturday evening , we'll meet around 1900 in front of the under the big tree in front of the AW building...

As with the Devops Meetup you can once again vote for your preferred food

The crowd voted and Favoured an Italian place , so I've made reservations for a 15+ persons group at Sogno d'Italia which is walking

For those in the US the annual MySQL UC is taking place again in April. For those in Europe we have dedicated room for MySQL and MySQL related products/variants/branches at FOSDEM 2010 being held in Brussels, Belgium on 6-7 Feb.

This conference will feature a full day of talks with a format of 20 minutes presentation and 5 minutes Q&A. More information about submissions can be found at Call for Papers for “MySQL and Friends” Developer Room at FOSDEM 2010 now open!

Other references:

• FOSDEM 2010 (via Forge Wiki)

The 10th edition of Fosdem is getting closer, yes .. I said 10 ,10 decimal that means ten, not two :)

It's kinda hard to imagine that this is actually going to be my 10th fosdem , it feels weird ..

Anyhow.. Lenz just announced a call for participation for the MySQL and Friends devroom.

I`m guessing a talk on .LolSQL might be a good fit for the "and Friends" part.

58 days to Fosdem ... !

I covered this one before .. but as it struck twiced today .. I think it's worth repeating. Both my collegue Karl and Trent ran into the same problem , within hours hours of eachother, a missing or failing reverse dns mapping that caused performance issues .. and a lot of log entries..

Karl denies having a second life in Perth but I`m not really sure about that ...

But I guess they both have to agree... Everything is a fscking DNS problem.
(I noticed other people using that spelling this weekend, on stage in the Janson)

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 !

The slides for my Monitoring MySQL talk , which I gave earlier today in an overcrowded MySQl Developersroom at Fosdem are now online, both at my site and at Slideshare

As of now I actually expect people to use those slides for schoolwork or next year in a main Fosdem track :)
As afterall that is the goal of Open Source and spreading the word ..