The problem with broken group commit was discusses many times, bug report was reported 3.5 years ago and still not fixed in MySQL 5.0/5.1 (and most likely will not be in MySQL 5.1). Although the rough truth is this bug is very hard (if possible) to fix properly. In short words if you enable replication (log-bin) on server without BBU (battery backup unit) your InnoDB write performance in concurrent load drops down significantly.
We wrote also about it before, see "Group commit and real fsync" and "Group commit and XA".

The problem is the InnoDB tries to keep the same order of transactions in binary logs and in transaction logs and acquires mutex to …

In just over 2 weeks I’ll be the invited speaker in Washington DC to Best practices for migrating applications to MySQL. This workshop is being held in conjunction with Carahsoft and Sun/MySQL and aims to provide to the Federal sector valuable information for the continued usage and uptake of Open Source and specifically MySQL.

As part of my preparation I’m happy to hear from any organizations that have successfully migrated from Oracle/SQL Server/Informix/Sybase etc to MySQL and would like to be cited.

While I have been involved in the process I am also happy to hear of reasons why a migration failed, was aborted or postponed. This is all valuable information in determining what are the most ideal applications.

In just over 2 weeks I’ll be the invited speaker in Washington DC to Best practices for migrating applications to MySQL . This workshop is being held in conjunction with Carahsoft and Sun/MySQL and aims to provide to the Federal sector valuable information for the continued usage and uptake of Open Source and specifically MySQL.

So Fred and I were wondering what people were planning to use as a Database the next couple of months / years or now.

We mostly see MySQL deployments and a little PostgreSQL

But there's other stuff around ..

So what are you using, , or planning on using ?

Vote Here !

I just wanted to send out a quick update. I have not been able to blog as much as I would like in the last seven or eight months. There is a good reason. Sheeri Cabral and I have been writing a book to be released by Wiley publishing in May of this year. And, finally, we are pretty much done with it. Yeah!!

So, I will have some more time to blog. A lot of changes coming down the road so stay tuned!

The Facebook juggernaut is an interesting environment for application developers. It is well documented for the most part and supports all the popular development languages. So I created a quick app to help promote MySQL certification and gave it the name MySQLQuiz.

The first step in app development is at the bottom of every Facebook page. That is where you will find the 'Developers' link. The documentation here is very good and you will be be able to quickly obtain the application's API Key and the applications 'secret'. Each app is going to have unique values for these.

The examples I will give are in PHP and using the supplied PHP library. I was able to get all this running on a test server.

The bare bones was

<?php

require_once 'facebook.php';
$appapikey = "yourappapikeyhere";
$appsecret = "yourappsecrethere";
$facebook  = new Facebook($appapikey, …

Do you remember Guy Adams? He was one of the winners of the “5.1 Use Case Competition”, ending up on position #2. Guess what: He has a webinar coming up tomorrow, by the title Deploying MySQL in a High Performance Satellite Network Management Environment by Parallel.
 
Guy works with Parallel Ltd. in Milton Keynes in the UK. You may also want to read up on Guy’s DevZone article. This is what you can expect of the webinar:

Join us for this informative technical webinar with Guy Adams, CTO at Parallel, whose flagship product SatManage is the worldwide …

Last week we had a team meeting, where we could discuss and plan various issues and ideas for current and upcoming versions of our project.

But finally it’s time to publish new material to show what we were up to in the past weeks. We have our first dual-platform-release of the MySQL Workbench 5.1.7 alpha version.

Please note, that in terms of UI linux- and OSX- version aren’t yet on the same level of completeness. While we are nearly done having all features onboard for the linux-build, we still have some more checkmarks to fill on the osx checklist - but we are catching up. Nevertheless it’s the same codebase - especially the backend-code is the same for all platforms.

Some of you might be missing a release - 5.1.6 for Linux. No, you didn’t miss an announcement: For the purpose of unifying the releases for Linux and mac we simply didn’t publish 5.1.6 last week. It was considered an internal release only and now …