<p>Recently the question came up if it is faster to restore a MySQL cluster when all nodes are up or only ONE node from each node group during restore.</p> <p>The answer from our gurus was: All nodes up during restore! I wanted to find out why. So I set up the following cluster and started to measure:</p>

Recently the question came up if it is faster to restore a MySQL cluster when all nodes are up or only ONE node from each node group during restore.

The answer from our gurus was: All nodes up during restore! I wanted to find out why. So I set up the following cluster and started to measure:

MySQL Cluster set up

MySQL Cluster backup

The backup is not that interesting. But I made the drawing for possible future use :-) :

MySQL Cluster restore

For the restore there are 4 different ways thinkable:

• Restore with all nodes up and all 4 backup pieces are restored in sequence. (1a)
• Restore with all nodes up and all 4 backup pieces are restored in parallel. (1b)
• Restore with 1 node of each node group down and all 4 backup pieces are restored in sequence. (2a)
• Restore with 1 node of each node group down and all 4 backup pieces are restored in …

Solid has released 5.0.27-0064. This release has a number of bug fixes and enhancements. For the full detailed list of bug fixes and enhancements, please see the ChangeLog.

Some highlights include:

• Obtain version number. You can now see which version of solidDB for MySQL you are running with the “show status” command. In order to not break existing applications which rely on it, the version number of MySQL server on which solidDB for MySQL is built upon can still be determined by using the “select version()” function.

mysql> show status like 'solidDB_version';
+-----------------+---------------------+
| Variable_name   | Value …

One of our product managers sent around a link to the site www.crankypm.com which describes the fictional life of a product manager at a mythical software company.  Having read a few of the essays on "A Day in the Life" and "All the Responsibility and No Authority" I think it's a pretty accurate description of life in the trenches in product management. 

Product Management is not an easy job, but its an …

Today, March 22nd, is Bum Rush The Charts Day.  This is a day during which thousands of independent podcasters and bloggers will attempt to show the strength they have compared to traditional corporate media. How?  By making an indepedent single the #1 item on iTunes.  You can support this effort by buying the song "Mine Again" by Black Lab, a band that was dropped from two labels and had to fight back to get the rights to its own music.  Every commission made on the sale of the song is being donated to support college scholarships and 50% of the royalties the band earns will also be donated.  If you believe in podcasting and …

From time to time, MySQL employees are approached with proposals from universities and other research institutions about MySQL participating in research programmes financed by governmental initiatives in the US and in the EU. This is much appreciated. Often, there is a mutual interest, where

• academics need an industrial partner to anchor the results of the research into a real-world application and even to fulfil the requirements of getting a grant, and
• the MySQL user community needs new features in MySQL Server, or in the Connectors enabling the use of MySQL from various development environments.

Left: MySQL University refers to the highest form of education when it comes to learning how to develop MySQL Server (as opposed to using it). It’s opening up for the MySQL …

I used to wear glasses (was nearsighted), but through some natural processes that I won’t go into here, I actually reversed my nearsightedness and now see clearly without the need for glasses. Having clear vision is a great thing, both for individuals and for companies.

One of the terrific aspects about MySQL is that the vision for the database is established with the help of the very active and innovative community of MySQL users who are daily pushing and extending the MySQL database server to do new and exciting things. We are in the process now of crafting the future vision of the server, and that process would be incomplete without your input.

Where would you like to see MySQL go in the coming years? What new areas would you like to see MySQL address? What does your business need MySQL to do that it currently doesn’t? We’re not talking about detailed feature requests here, but more of a “big picture” type of thing. …

In May 2007 XAMPP will be five years old and we think this is a good time to think about changes and improvements to XAMPP. That's what this survey is for: to find out what your needs are and what we can do to improve XAMPP in the next major release.

The survey will run for exactly one month (from March 22nd to April 22nd 2007), after which we will publish the results right here.

Thank you for taking the time to complete the survey. We appreciate your feedback and we will use it to make XAMPP even more useful and enjoyable. ;)

If there are any questions you don't want to answer, you don't have to. You choose.

Apache Friends XAMPP 2.0 Survey »

MuleSource expands team…Digium delivers Asterisk appliance…R1Soft introduces data protection for MySQL…and more…

MuleSource Expands Global Management Team With New Hires From JBoss, Sun, and Tibco, MuleSource (Press Release)

Digium Delivers Asterisk Appliance for Full-featured, Cost-effective Internet Telephony, Digium (Press Release)

R1Soft Introduces Continuous Data Protection for MySQL, Righteous Software (Press Release)

Novell’s tiny regret in Microsoft deal, The Register, Gavin Clarke (Article)

…

I'll be giving a presentation about CouchDb tomorrow night at the PHP UG Dortmund. If you're in the area, come and say hello.

You'll learn what CouchDb is, why it is so cool and how to use it with PHP. The talk will be in German, but I'll make some material available in English some time after the presentation.

In case you'd like to see this or my High Availability talk at your local usergroup, company or conference, you can find contact information at my website. I'd like to hear from you!