Jan Kneschke has released a new tool called "MySQL Proxy".
This proxy is between the mysqld and the client and can handle load balancing, fail over, query rewriting and analysis.
It´s also possible to extend the proxy with LUA scripting which opens nice possibilities.
I´m thinking about adding Memcache-Support. But perhaps its better up to the application to decide, if the cache should be used or not.
At least it should be possible to implement load balancing/ failover in an easy way for a slave-farm.

BusinessWeek asks: How much is MySQL worth? MySQL, a fast-growing maker of database software used by some of the Internet's most recognized brands, is preparing to file for an initial public offering, perhaps as soon as late 2007. The offering could value the company at between $600 million and $1 billion, according to sources, and inject some pep into a tech IPO market that's seen only a handful of successful offerings in the past year.... READ MORE

Version 1.2 of Zmanda Recovery Manager (ZRM) for MySQL, a robust and intelligent solution for backup and recovery of MySQL databases is available at Zmanda downloads page.

Changes in this release:

• Code restructured into modules
• Snapshot plugin interface. LVM snapshots implemented as a plugin.
• ZRM should be run as user belonging to mysql group.
• Numerous bug fixes

Documentation is available at ZRM for MySQL wiki. Ask questions and provide feedback in Zmanda forums.

One may think one may use MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes. In fact however not all the queries are logged. I already mentioned mysql slave queries are not logged to slow query log and it looks like I was wrong connecting it just with replication.

In reality it is not the fact the thread is replication thread causes queries to be omitted from slow query log but the fact thread uses SET TIMESTAMP functionality. If you do this within normal connection result would be the same.

Why is this happening ? I guess it happens because of the way the code is structured. During query start current timestamp is stored to special value which will be used for the query execution by all NOW() calls internal timestamp assignments etc. At certain point …

So, a number of folks wanted more meaty content than was being offered in the CIO-targeted MySQL marketing campaign recently, "The Twelve Days of MySQL Scale-Out". I wanted to write a blog entry which addressed this carnivorous appetite of the MySQL community by going into a discussion on what precisely this term "scale-out" means.

Comparisons of Scaling Out versus Scaling Up

What is scaling anyway? Simply put, it's the ability of an application to address growth in throughput, usage, and capacity. Both scale out and scale up strategies address the ability of a system to address this growth. I think there is a …

It has gotten a bit quiet around the MySQL Proxy over the last weeks, but I can assure you it was worth it.

Here in my hands I hold MySQL Proxy 0.5.0. Not just some binaries, no everything with sources. As always it is dual licensed under the GPL and commercial MySQL license. We worked hard to get everything ready for the release: the wiki, the forums, the public SVN trees ...

The proxy can do magic. Put in your ideas and say the magic words and there ... it works. :)

The proxy is fully scripted now which opens up the proxy to your ideas. The possibilities are endless. I can think of at least of the following features:

• load balancing
• fail over handling
• query analysis
• SQL macros
• query rewriting
• .... much more

The proxy started as side project of me and is now evolved into a full MySQL project maintained by the …

For the curious, the slides for the eLiberatica 2007 presentations are now up at http://eliberatica.ro/2007/ - the slides include presentations from eZ CEO Aleksander Farstad, Brian Behlendorf, FSF Europe President Georg Greve, Ubuntist Kurt von Finck and MySQL co-founder Monty Widenius (and yours truly, but the slides are a bit weak - check out my …

So, now I am working on this project. This project is a part of google SoC. I believe in the end it should be something like mysql workbench, but web-two-zerofied. At current moment there is not much to look into (http://myweber.googlecode.com/svn/trunk/). But I will be very grateful to you for any comments, questions and suggestions.

mysql> CREATE TABLE innodb_string_test (h varchar(512) ) TYPE=INNODB;
Query OK, 0 rows affected, 2 warnings (0.55 sec)

mysql> show warnings;
+---------+------+--------------------------------------------------------------------------+
| Level   | Code | Message                                                                  |
+---------+------+--------------------------------------------------------------------------+
| Warning | 1246 | Converting column 'h' from CHAR to TEXT                                  |
| Warning | 1287 | 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead |
+---------+------+--------------------------------------------------------------------------+
2 rows in set (0.00 sec)

Technically innodb supports defining varchar's greater then 255 characters (utf8 are double bytes so don't assume that 255 characters mean bytes-FYI). …

It's hard to believe I'm back. It's so quiet here.

Saturday morning, it took too long for the hotel clerks to check us out. They'd screwed up my credit card, krow's credit card, messed up their room reservation log, and so forth. And we needed at least the receipt for krow's corporate card before we left. (I let them handle mine off-line. If they screw it up, I just dispute the charge and wash my hands.)

The session about non-relational databases was interesting. The guy from Twitter talked about their queue db. They are using the memcached wire protocol to talk to it! Dabble talked about their neat little cheat, where they don't actually have a …