tag:blogger.com,1999:blog-3247171317808202855.post2375424399041815463..comments2007-09-07T21:19:40.329-07:00Comments on DBA Dojo: MySQL 5.1 NDB Cluster on EC2 testing redundancyroobaronhttp://www.blogger.com/profile/08420801903669108937noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3247171317808202855.post-58617062915765757002007-09-07T21:19:00.000-07:002007-09-07T21:19:00.000-07:00Potentially yes. I reread the manual on this <a hr...Potentially yes. I reread the manual on this <A HREF="http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-nodes-groups.html" REL="nofollow"><BR/>concept</A> and you can partition the data as required.<BR/><BR/>What I was demostrating for that test was having 4 replicas of the data on 4 data nodes, rather than partitioning the data into 2 partitions, each with 2 data nodes as suggested in that roobaronhttp://www.blogger.com/profile/08420801903669108937noreply@blogger.comtag:blogger.com,1999:blog-3247171317808202855.post-35997717666819389302007-09-06T02:27:00.000-07:002007-09-06T02:27:00.000-07:00You say that having to store the complete database...You say that having to store the complete database in memory limits the size of the database, both physical limits and cost. But as far as I know, MySQL is capable of storing different parts (fragments) of the data on different nodes, so physically it should be possible with a db size larger than memory size on each node, provided you have enough nodes, right? The cost of running the nodes, on Øyvindhttp://www.blogger.com/profile/05508521402696308721noreply@blogger.com