Cluster or Master/Slave (replication)

[Wai Boon Ng]

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 :-

1. conversion to ndbcluster on table type error, ended up export the data into sql and reinsert with ndbcluster for each table creation

2. deletion of certion rows in a table returned some very funny errors and i had check , it is a bugs.

3. how frequent to flush the data in memory and write in to disk for good.

4. NDBD doesn't behave constantly....

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....