When you have a node failure the best practice is to restart the ndbd node as soon as possible.
This post illustrates what happens with restart times:

• if you have configured TimeBetweenLocalCheckpoints wrong and have a high load
• if you don't restart the failed ndbd node immediately
• how long time it takes to resync 1GB of data with and without ongoing transactions.
  

5.0 and 5.1 differences in node recovery protocol

In 5.0 the node recovery protocol copies all data from the other node in its node group.
In 5.1, there is a new node recovery protocol, called "Optimized Node Recovery", called ONR below.
When a node has failed, and is restarted, it will recover its local logs (Local Checkpoint (LCP) + redo log) and only copy the changes that has been made on the started node.
This is faster than copy all information as done in …

MySQL Connector/Net 5.0.5 a new version of the all-managed .NET driver for MySQL has been released.

This is a bug fix release for the current production branch of Connector/Net.
Version 5.0.5 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-5.2 Falcon "Preview".

It is now available in source and binary form from the Connector/Net download pages at http://dev.mysql.com/downloads/connector/net/5.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)

What happened to 5.0.4?
We had 5.0.4 packaged up and ready to go and then discovered that a previous bug fix was not complete.  Rather …

With many other open source projects - like our friends from phpMyAdmin - we're showcasing our software at this year's DotOrg-Pavilion (open April 24th and 25th) and will be happy to talk to you about the past, the present and the future of XAMPP.

The MySQL Conference & Expo is taking place in Santa Clara, April 23-26, and it's not too late to qualify for the early bird discount: If you take advantage of early registration by March 14th you can save $200 off the standard conference fee.

For complete MySQL Conference & Expo details, visit: http://www.mysqlconf.com

In the most recent edition of Database Trends and Applications (hardcopy), there’s an interview with Tom Kyte from Oracle with the focus being the new enhancements coming in Oracle11g. I’m a big fan of Mr. Kyte as he really knows his stuff and is not shy in admitting what Oracle doesn’t do well. Even though I’m no longer an in-the-trenches Oracle DBA, I still follow his columns because his advice can oftentimes apply to other DBMS’s in addition to Oracle.

I was intrigued to see the very first 11g enhancement he noted in his interview - Oracle will now sport a new memory cache that will cache the results (not just the raw data blocks) of SQL queries. Sound familiar? When I first came to MySQL, one thing that quickly caught my eye was the query cache. Now I know the query cache isn’t for everybody, but in the right situations, it can really be a godsend. Seems Oracle has now gotten the same message. And no wonder: for repetitively …

Oracle contributes TopLink to the Eclipse Foundation…Zend releases updated version of Zend Core…FSF seeks partnerships with hardware vendors…and more…

Oracle Proposes Open Source Persistence Project at Eclipse Foundation, Oracle (Press Release)

Oracle Becomes Board Member of Eclipse Foundation , Oracle (Press Release)

Eclipse Foundation Community Awards Announcement, Eclipse Foundation (Press Release)

…

With many other open source projects - like our friends from phpMyAdmin - we're showcasing our software at this year's DotOrg-Pavilion (open April 24th and 25th) and will be happy to talk to you about the past, the present and the future of XAMPP.

The MySQL Conference & Expo is taking place in Santa Clara, April 23-26, and it's not too late to qualify for the early bird discount: If you take advantage of early registration by March 14th you can save $200 off the standard conference fee.

For complete MySQL Conference & Expo details, visit: http://www.mysqlconf.com

Last few days I had a lot of a lot of questions at MySQL Performance Forum as well as from our customers regarding query optimization... which had one thing in common - It is not query which needed to be optimized.

Way too frequently people design schema first and then think how the queries they are looking to be answered can be expressed using that schema... which just does not work as a lot of rows needs to be traversed to get results you're looking for. Here are couple of examples:

GROUP BY Consider SELECT COUNT(*) cnt, page FROM log GROUP BY page ORDER BY cnt DESC limit 10, the query to display top popular pages. There are very many queries of this type in many web applications which do group by one field sort by another and then use LIMIT to output first few rows. This query is not going to be efficient as it needs to traverse a lot of rows …

I doubt that anyone will notice, but I thought it would be at least polite to mention that hackmysql.com is moving to a new host. Therefore, some time this week the site may be inaccessible.

Infrastructure management company dbaDirect, in a move similar to Oracle’s play to intercept Red Hat’s enterprise support for its own distribution of Linux, is now supporting the MySQL open source database with dbaDirect’s usual enterprise services that include on-demand technical expertise, patches and upgrades.

While Oracle’s Unbreakable Linux announcement last year was no surprise and consistent with the company’s history and strategy, the dbaDirect MySQL offering is more on the level of the larger industry (meaning not just companies that throw around a few billion in acquisitions and extensions each year).

With dbaDirect, we now have a mid-sized, typical enterprise IT services company (3,000 corporate databases managed) basing strategy on the …

Earlier today I had a nice IM chat with someone.  He or she is referred to below as Question and I’m Answer.  There where interesting questions and perhaps others find the answers interesting as well.  I seemed a shame to let the information in the chat log go to waste, so I’m posting it here on my blog.
Question: I have a qestion for you about the possibility of creating custom transformations.
Answer: sure
Question: my company already has quite a buit of business logice that is coded in C and/or C++ and this logic then calls some Corba services.  Would it be possible for use to integrate that logic into Kettle?
Answer: Not directly, however, it’s not that hard to write wrappers in JNI (java native interface) and create a plugin for it.
Question: That was my idea.  I was just wondering if there were any other ways
Answer: …