I love this - an analysis of how to handle gay marriage in your database model. He actually goes through fourteen different iterations of the design. Here's a comment from iteration six...It's asinine to do it this way. However, there is a good reason why I haven't just skipped schemas schemae schemata One to Six. There are a lot of people in the world who actually think like this. This is their for-real, no-joking conception of "marriage". They do not grasp that men and women are interchangeable, as a result of which homosexual marriages create repulsive integrity problems in their heads. "But if they're both guys, which one is the wife? Does not compute!" How sad.

http://qntm.org/?gay

These are a few features I want to see implemented in InnoDB this year.

We need them for production so we’re probably going to throw down some cash to see this happen. The patches will have to be Open Source of course.

If there are any companies out there that would like to co-sponsor these features feel free to add a note in the comments or contact me via email.

Native InnoDB warmup

We have about 100GB of InnoDB which needs to run 100% out of memory. Our per-DB images are 32GB and the databases on these box fixes into about 25GB (a bit of room for growth).

Right now we have a hacked InnoDB warmup script that runs a number of SELECTS into a blackhole table which warmup the DB.

This MUST be amazingly inefficient as InnoDB could just scan the DB moving pages into memory as it reads forward. One sequential scan of the table would be a LOT faster than our current random …

was it really almost a year ago that i mentioned that my focus would be shifting from connector/odbc to libmysql? time certainly flies.

after what now seems much too long, i can say that we have carved out libmysql from the server source code, rebuilt its build system (using cmake), and are gearing up for an alpha release. the code is on launchpad, and it builds on all the platforms that the mysql server does. we have a build system set up that runs what scant tests we have on all of the platforms, and the big thing to work one before release is making more tests.

because this source is derived from the 6.0 server code, it has at least one big flaw that needs to get addressed — if you try to use utf-8, it uses the new 4-byte utf-8 supported in …

The first alpha version of the MySQL Connector/C++ has been published. You can download the source code from http://dev.mysql.com/downloads/connector/cpp/1.0.html . The MySQL Driver for C++ is a new connector aiming at C++ developers who want to profit from the convenience of using C++ when connecting to the MySQL Server. The API of the MySQL Connector/C++ mimics JDBC, a widely known and well established standard. Some 75% of the core JDBC API calls are available. Please find more details in the announcement.

If you hear that our primary goal for the alpha release has been to serve the needs of our "internal customers" MySQL …

We are pleased to announce the release 1.0.15 of HoneyMonitor, our GUI for MySQL™ administration and monitoring.

In this release, available for immediate download, we have fixed some bugs without adding many new features.

We are working to release a RC version as soon as possible.

The following is the list of changes:

- New Features:

1. new menu entry Auditing / Reports / Edit Report’s Template / Custom Report.

- Improvements:

1. minor bugs fix and improvements in the Report Designer.

- Bugs Fix:

1. on Vista™, the Report Designer was losing the connection after …

The first alpha version of the MySQL Connector/C++ has been published. You can download the source code from http://dev.mysql.com/downloads/connector/cpp/1.0.html . The MySQL Driver for C++ is a new connector aiming at C++ developers who want to profit from the convenience of using C++ when connecting to the MySQL Server. The API of the MySQL Connector/C++ mimics JDBC, a widely known and well established standard. Some 75% of the core JDBC API calls are available. Please find more details in the announcement.

If you hear that our primary goal for the alpha release has been to serve the needs of our "internal customers" MySQL Workbench and …

Kontrollbase is a MySQL monitoring, analytics, reporting, and historical analysis webapp for MySQL database administrators and advanced users of MySQL databases. Its goal is to give you enterprise-level tools that are built on the open-source software model. We want your servers to perform at their best and these tools will help you get the most out of your investment.

For more information on kontrollbase please see this page.
To download kontrollbase please see this page.

The news of the MySQL 5.1 GA announcement brought many emails asking about the 5.1 exams. First, let me state that if you are studying for any 5.0 exam please keep on with your plans. The 5.1 DBA test is inching closer to alpha test and will not suddenly pop up without warning. It is on the way but most of you will not get to see it until well into 2009. Watch this blog for updates on how the testing is proceeding. Second, the 5.0 exams will not be disappearing anytime soon. Nor will they start 'expiring'.

But I do need help with the new 5.1 Developer exam. The new exam will be part multiple choice and part 'hands on' or performance based testing. Like 5.1 DBA exam mentioned earlier this year, I need the help of some of you to take a look at the new material and judge its relevance. No, getting a peek at this …

Here are the minutes of the meeting. They can also be found online
with the irc logs here.

MySQL 5.1 in Jaunty

ScottK mentioned that the next version of amarok (music player for KDE) would require MySQL 5.1 as it uses the embedded mysql library (which is not available in 5.0). He also added that akonadi (PIM manager for KDE) used MySQL 5.0 for now. zul and mathiaz reported that they had been working on merging 5.1 from experimental. However the test suite isn’t successfully run during the build process. There was some discussion about supporting both 5.1 and 5.0 in main. jdstrand from the security team strongly suggested to not do that. mathiaz also mentioned that a senior MySQL developer blogged about the poor quality of MySQL 5.1 now that it has been declared stable for production use (GA) by upstream.

…

MySQL 5.1 reaches GA. But is it ready for production deployments? SpringSource launches commercial version of Apache Tomcat. BusinessWeek focuses on open source business models and open source in the downturn. And more.

Official announcements
MySQL 5.1 Downloads — Generally Available (GA) release for production use Sun Microsystems

SpringSource Launches tc Server; Continues to Redefine Application Server Market SpringSource

Open Solutions Alliance Appoints New President, Announces New Leadership Team Open Solutions Alliance

…