Shuttleworth steps down as Canonical CEO. Open source at SAP. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

# Mark Shuttleworth explained why he is stepping down as CEO of Canonical.

# Groklaw published The EU and Microsoft Settle Browser Issue; Interoperability with FOSS Still a Problem. …

Nicklas Westerlund has published the 173rd edition of Log Buffer, the weekly review of database blogs, on SELECT mysqlgenie FROM lamp;.

Log Buffer will be off next week for the holidays, and back early in 2010 to begin another year of presenting the best of database blogs. Please get in touch with the Log Buffer coordinator if you’d like to publish an edition of your own.

Happy Holidays to everyone! Here is Log Buffer #173.

Time keeps on moving and we’re now only one week from Christmas, when people spend time with their families and loved ones. But, that is in a week, today it is time for a new edition of Log Buffer, where we catch up on database blogs from across the world, starting with SQL Server.

SQL Server
Over at Less Than Dot Ted Krueger brings up the question of the good, the bad and the ugly of database design where he says “In my career I have seen the ugly and then the really ugly but I found on this particular implementation it could get even uglier.”

Over at Carpe Datum the question is …

On the 24th of November I attended a talk given by one of of Sun's benchmark specialists , Dimitri Kravtchuk, at the Sun Solution Center of Paris.

The talk was simply called MySQL performance, and I was expecting, as many I suppose (the auditorium was packed !) tips and tricks on how to optimize a MySQL database. However I was quite positively surprised since the 3 hours session wasn't just a long list of tricks and “how to's” but was actually a journey through one and a half year of improvement of the InnoDB engine.

InnoDB could easily scale horizontally but not vertically. Horizontal scaling is the fact to put many small servers with each running a MySQL server (typically in a Master-Slave mode) where vertical scaling would be to put a unique MySQL server on a bigger server, expecting to get better performances. The latter is more and more needed given the multiplication of cores and threads within the CPUs even in entry level …

On the 24th of November I attended a talk given by one of of Sun's benchmark specialists , Dimitri Kravtchuk, at the Sun Solution Center of Paris.

The talk was simply called MySQL performance, and I was expecting, as many I suppose (the auditorium was packed !) tips and tricks on how to optimize a MySQL database. However I was quite positively surprised since the 3 hours session wasn't just a long list of tricks and “how to's” but was actually a journey through one and a half year of improvement of the InnoDB engine.

InnoDB could easily scale horizontally but not vertically. Horizontal scaling is the fact to put many small servers with each running a MySQL server (typically in a Master-Slave mode) where vertical scaling would be to put a unique MySQL server on a bigger server, expecting to get better performances. The latter is more and more needed given the multiplication of cores and threads within the CPUs even in entry level …

Keeping a MySQL installation up and running can be quite tricky at times, especially when having many servers to manage and monitor. In the replication tutorials at the annual MySQL Users' Conference, we demonstrate how to set up replication appropriately and also how to handle various issues that can arise.

Many of these procedures are routine: bring down the server, edit the configuration file, bring the server up again, start a mysql client and add a user, etc.

It has always annoyed me that these procedures are perfect candidates for automation, but that we do not have the necessary interfaces to manipulate an entire installation of MySQL servers.

If there were an interface with a relatively small set of primitives—re-directing servers, bringing servers down, add a line to the configuration file, etc.—it would be possible to create pre-canned procedures that can just be executed.

To that end, …

Installing Apache2 With PHP5 And MySQL Support On Mandriva 2010.0 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Mandriva 2010.0 server with PHP5 support (mod_php) and MySQL support.

I have now published the Buildbot configuration file that we use for our continuous integration tests in our Buildbot setup. Every push into main and development branches of MariaDB is built and tested on a range of platforms to catch and fix any problems early (and we also test MySQL releases before merging to easily see whether any new problems already existed in MySQL or were introduced by something specific to MariaDB).

The configuration is included in the Tools for MariaDB Launchpad project.

Now, the Buildbot configuration file is not something that most …

With the release of InfiniDB 0.9.5.3 that includes HAVING functionality, the test scripts have been updated to include HAVING tests as well.  Updated UNION tests and RENAME tests have also been included.  You may download these new 0.9.5.3 test scripts here.

With the release of InfiniDB 0.9.5.3 that includes HAVING functionality, the test scripts have been updated to include HAVING tests as well.  Updated UNION tests and RENAME tests have also been included.  You may download these new 0.9.5.3 test scripts here.