Thursday, May 31, 2007

MySQL Cluster

I did some research on MySQL cluster so i can recommend one of our customers whether to use it or not. It turns out that the MySQL cluster is very different from other DBMS clustering solutions in that it distributes the data across the nodes (synchronously) and then stores it on the disk (asynchronously). This is all very nice, but at the moment all data is stored in memory, so if I have a 120GB database I would need around 150GB memory on each node, which is silly.

The Wikipedia Page on MySQL Cluster gives more details.

Waiting for MySQL to get better...

UPDATE: It seems that this is no longer the case for the 5.1 version of mysql. See here.

Welcome - eureka

Why this blog?

Post random thoughts about random technology issues. Basically acts as an online(public) notepad, so i can keep track of things i found and do not wish to forget.

Why eureka?
eureka is the greek word for 'I have found (it)', supposedly exclaimed
by Archimedes upon discovering how to measure the volume of an irregular solid
and thereby determine the purity of a gold object. source: http://www.answers.com/eureka&r=67