How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1

This tutorial is based on Falko Timme's tutorial for MySQL Cluster 5.0. It shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer nodes. This cluster is load-balanced by an Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).

I have recently moved MySQL Sandbox to launchpad and Bazaar.

Working with Launchpad is really a joy. It is much more than providing a web interface to Bazaar version control. It also includes provisions for bug reporting and handling, writing blueprints for your roadmap, creating distribution files, and manage your packages if you want to release them in …

With a few days of delay, I want to share my impressions about Red Hat's Open Source Day presented in Rome on June 10, 2008.

The Event

Event was organized really well, Red Hat took responsibility of everything and all went smoothly toward the end. There were more than 200 attendees and the hall was crowded of Open Source enthusiasts, customers and others waiting for interesting speeches and a juicy agenda. General impression was very good, a lot of attention from both community attendees and customers willing to deeper their Open Source knowledge and listening to shining or emerging stars in the field.

A rich agenda gave everyone a bunch of new ideas to think about.

MySQL/Sun

Luca Gargaglione catalyzed attendees attention by explaining How and Why MySQL is the world's most popular open source database. He gave us a …

With a few days of delay, I want to share my impressions about Red Hat's Open Source Day presented in Rome on June 10, 2008.

The Event

Event was organized really well, Red Hat took responsibility of everything and all went smoothly toward the end. There were more than 200 attendees and the hall was crowded of Open Source enthusiasts, customers and others waiting for interesting speeches and a juicy agenda. General impression was very good, a lot of attention from both community attendees and customers willing to deeper their Open Source knowledge and listening to shining or emerging stars in the field.

A rich agenda gave everyone a bunch of new ideas to think about.

MySQL/Sun

Luca Gargaglione catalyzed attendees attention by explaining How and Why MySQL is the world's most popular open source database. He gave us a …

With a few days of delay, I want to share my impressions about Red Hat's Open Source Day presented in Rome on June 10, 2008.

The Event

Event was organized really well, Red Hat took responsibility of everything and all went smoothly toward the end. There were more than 200 attendees and the hall was crowded of Open Source enthusiasts, customers and others waiting for interesting speeches and a juicy agenda. General impression was very good, a lot of attention from both community attendees and customers willing to deeper their Open Source knowledge and listening to shining or emerging stars in the field.

A rich agenda gave everyone a bunch of new ideas to think about.

MySQL/Sun

Luca Gargaglione catalyzed attendees attention by explaining How and Why MySQL is the world's most popular open …

The other day I was explaining options to someone who wanted to know about archiving data in MySQL. “So,” he said, “I might have to code my app to look for the data in two places?” The disadvantage of this is that his app might be more complex. Another disadvantage is that it might take two queries – if you look for a user in the usual location and it’s not there, you have to look for it elsewhere.

If you haven't heard of Digsby yet, you have probably been living in some kind of a virtual cave or have no friends. Digsby is a multi-network instant messenger application, similar to Trillian, Pidgin (GAIM), or Miranda. I said 'similar', so what makes Digsy special? Reviews I read so far don't give the real reasons and don't dive into the features in depth. Instead, you get a standard load of marketing BS and in the end to you, the user, Digsby may end up being "yet another IM program." Some reviews describe certain features, but so far I haven't seen one that highlighted THE MAIN REASON why Digsby is different. And may I preface it with: finally somebody got a clue. I never before wanted to write about any other IM client, which already indicates that on the "this is the most awesome meter ever" meter, Digsby is floating somewhere at the top. …

Do they exist? Do they make you money (or in the case of Firebird meaningfully extend your community)? Would you be unhappy if support would be dropped in PHP 5.3, in PHP 6.0? Do you have ressources to prevent this from happening, by taking ownership of the code in question? Are you interested in ensuring the availability of solid support in PDO? While I do not think support will be dropped in PHP 5.3 (well for FrontBaseSQL I have a hard time standing up in defense like I did for the other 3), there is a good chance this will happen in PHP 6.0. Without PDO support your users will be left more or less in the dust. So if you work for one of these vendors, please talk to who ever who can prevent this. If you know …

In what I think must be MySQL’s first time in the Philippines, there will be a presence there next week. Well, its not the first time, but in terms of a community/developer event, I think it might be. The Sun Tech Days is happening from 17-19 June 2008, in the Shangri-La Makati.

Besides MySQL, expect great talks on NetBeans, GlassFish, OpenSolaris, and so much more. I’ll be the guy walking around in the MySQL shirt, so feel free to stop me and ask questions. Its exciting for me, as we’ve not really paid much attention to the Philippines, in terms of community growth (and the Philippines is in the APAC region!).

This isn’t a free event (its 1,000 PHP = ~USD23), and registration should still be available. If you’d like to meet up, and talk MySQL, shoot me an email at colinATmysqlDOTcom or …

Well I don't quite know either (yet ;-) but I spotted a hint: his LinkedIn profile now says "President at NimbusDB", with stated goal "To build a database in the clouds that scales to 1000X disk-based database systems." Sounds good.

Which Jim? Jim Starkey, most recently known from MySQL's Falcon storage engine.