I setup my first mysql cluster on 4.1.10 since april 2005. So far for minor or tiny operation it has not a problem, when i tried to migrate the databases from the stand alone server to a cluster, below are some of the problems i faced :-
-> Many issues have been corrected. The latest version 4.1.14 should resolve some of the problems you are seeing
1. conversion to ndbcluster on table type error, ended up export the data into sql and reinsert with ndbcluster for each table creation
-> Can you paste an example?
2. deletion of certion rows in a table returned some very funny errors and i had check , it is a bugs.
-> Did you find a bug report, or have you created a bug report? Again you should try 4.1.14.
3. how frequent to flush the data in memory and write in to disk for good.
-> Not sure I understand your issue here
4. NDBD doesn't behave constantly....
-> Detailed examples help the most. Global statement like this are hard to fix :-)
and some minor ones.....may be is due to my limited knowledge..but i had seached and googled around and even within this informative forum, some are limitations some are plain bugs.....
i was thinking if not ndbcluster, will the HA solution like multiple slave with 1 master kind of replication will work better and not memory hungry....
-> Replication is good also, you have to consider disk space and ability to scale. The cluster allows you to scale by adding more computers and if you loose one (or more depending of setup) your cluster stays up and running. With replication, you have to make the slave the master until you are able to recover the master computer. Then there is the issue of getting it back to the way you org had it. There are pros and cons for both.
-> If you find issues that you feel are bugs, please turn in a bug report. We will be happy to look at it and fix it if it is a bug.
Jonathan Miller
Austin, Texas USA
Senior QA Developer
MySQL AB www.mysql.com
Jumpstart your cluster!
http://www.mysql.com/consulting/packaged/cluster.html
Get training on clusters
http://www.mysql.com/training/courses/mysql_cluster.html
All-in-one Enterprise-grade Database, Support and Services
http://www.mysql.com/network/