I have read How to setup mysql cluster on http://www.howtoforge.com/loadbalanced_mysql_cluster_debian and I am thinking to setup mysql cluster for my system, but there are 2 questions that bugging me: 1. how to export/import data from standalone mysql server? yes I know, I can use mysqldump to export queries then ran the sql queries on to mysql cluster. but that took times. especially if I have 2GB datafile (*.myd). is there any faster and simpler way to migrate my data into mysql cluster? 2. can I easily expand / decrease the number of nodes? I know it should be do able. but I haven't found any article how add new node or removing node. any hint/url will be appreciate thanks b4
1. MyISAM databases can be copied binary, you don't need a mysqldump for that (it's not really recommended, but it is possible, i've done it multiple times without any problems) 2. no idea, no clustering experience
yes, all my databases on (standalone) mysql server is using myisam. but are you sure that clustered mysql server also use myisam storage engine and not other storage engine? what I have read, it's using ndb ________ Dodge Demon Concept History