It had to happen (and not just because Savio asked when it would happen). Today Red Hat (which seems to be making a lot of noise during Oracle's OpenWorld event :-) and Hyperic joined forces to create a common systems management platform. The ice between the two has thawed at last:

For years, the JBoss Operations Network [JON] team has been developing code on the Hyperic platform. Red Hat will be contributing its updates and enhancements to this new open source project. Both companies will work to maintain, govern and extend management capabilities within the new open source systems management platform project. Additionally, Hyperic and Red Hat will work jointly to include this base in both future Hyperic …

The market for server virtualization software appears to have gotten a whole lot more crowded this week. Not only did Oracle announce free server virtualization software at the Oracle Open World conference, but Microsoft and VMWare also made announcements of competing free offerings. And this morning at Oracle OpenWorld Sun announced their plans for virtualization also, known as xVM with support from Intel, AMD, Symantec and MySQL among others. Rich Green, head of Software at Sun, demonstrated Sun's xVM virtualization server and the xVM Ops Center management software console with a live demo deploying a workload to some Sun servers... READ MORE

Lua is a great programming language and I use it as embedded scripting language in

• MySQL Proxy
• wormhole Storage Engine
• lighttpd

What impresses me most it's flexibility. What ever I come up with is only a few lines away ... and I have crazy ideas. Like profiling lua scripts with KCacheGrind.

For profiling lua-scripts you can use

• luaprofiler
• …

This is my personal whishlist for MySQL.

Please let me know if I'm wrong or if there is a workaround for any of these items.

1. Per user and/or per database quota
Would very useful in setups for shared hosting. This would also prevent one database from bringing down the whole server. Separate tablespaces on different mountpoint can ease the pain, but I consider that a nasty hack.

2. External authentication
I've seen numerous scripts which fetch the authentication info from ldap, a file, another database or some other authentication store. This should be integrated into mysql. The mysql grant tables should be pluggable so it is possible to write a custom authentication plugin. We already have plugable engines and function (UDF) so this shouldn't be that hard is it?

3. Database locator
So you've got hundreds of servers.... and a multitude of databases. How to connect to …

This is my personal whishlist for MySQL.

Please let me know if I'm wrong or if there is a workaround for any of these items.

1. Per user and/or per database quota
Would very useful in setups for shared hosting. This would also prevent one database from bringing down the whole server. Separate tablespaces on different mountpoint can ease the pain, but I consider that a nasty hack.

2. External authentication
I've seen numerous scripts which fetch the authentication info from ldap, a file, another database or some other authentication store. This should be integrated into mysql. The mysql grant tables should be pluggable so it is possible to write a custom authentication plugin. We already have plugable engines and function (UDF) so this shouldn't be that hard is it?

3. Database locator
So you've got hundreds of servers.... and a multitude of databases. How to connect to …

Today I saw a case where MySQL server is writing its binlog entries to the error log file ‘mysqld.err’ instead of writing it to regular binlog. This is happening with MySQL version 4.0.26 and not sure how it was triggered.

I am guessing it could be because the file handles got swapped, it can not be a memory overrun or anything else as I can see the error log is getting the right binlog entries. I am still trying to find what could have caused this to happen. This happened twise so far from the same property with the same setup; even though there is more than an year in between. If you restart the server or upon issuing FLUSH LOGS, everything will be back to normal.

I’m setting up my first mysql cluster, and just wanted some clarification on a few things.

In the manual, it says:

Online schema changes. It is not possible to make online schema changes such as those accomplished using ALTER TABLE or CREATE INDEX, as the NDB Cluster engine does not support autodiscovery of such changes. (However, you can import or create a table that uses a different storage engine, and then convert it to NDB using ALTER TABLE tbl_name ENGINE=NDBCLUSTER. In such a case, you must issue a FLUSH TABLES statement to force the cluster to pick up the change.)

MySQL Cluster Exclusive Limitations

However, on another cluster limitations page, it says:

DDL operations. DDL operations (such as CREATE TABLE or ALTER TABLE) are not safe from data node failures. …

I ran into something with mysql cluster today which boggles my mind.  On http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-config-params-ndbd.html page, it is documented that if we you change datamemory parameter in the config.ini under mysql-cluster like below, you would have to restart nodes to reread the configuration. [NDBD] id=2 HostName=10.0.0.2   # the IP of the first data node DataMemory=6G IndexMemory=512M But when I tried the: [...] …

Microsoft and Kyocera sign patent agreement. Volantis goes open. UnivaUD launches Grid.org community. (and more)

Microsoft and Kyocera Mita Enter Broad Patent Cross-Licensing Agreement, Microsoft / Kyocera Mita (Press Release)

Volantis Removes Price as Barrier for Enterprise Mobile Content Development and Delivery, Volantis (Press Release)

New Open Source Grid and Cluster Community Launches, UnivaUD (Press Release)

Red Hat and Platform Computing Collaborate to Deliver Integrated HPC Solution, Red Hat / Platform Computing …

Lua is a great programming language and I use it as embedded scripting language in

• MySQL Proxy
• wormhole Storage Engine
• lighttpd

What impresses me most it's flexibility. What ever I come up with is only a few lines away ... and I have crazy ideas. Like profiling lua scripts with KCacheGrind.

For profiling lua-scripts you can use

• luaprofiler
• …