MySQL Forums
Forum List  »  NDB clusters

Re: sql node and storage node concept, state of cluster.
Posted by: Qiang Li
Date: May 10, 2005 10:31AM

thanks for your reply, jon.

>Data definition statements aren't automatically distributed between storage nodes.

>1. create the database and the tables on one storage node

the doc said load the sql file into sql node , not storage node. what's the difference here?
the database loaded into the nodes will get fragmented automatically ?

also, from the FAQ , "the minimum recommended number of computers in a MySQL Cluster is four: one each to run the management and SQL nodes, and two computers to serve as storage nodes. "
correct me if i am wrong, but it looks like i need to have another SQL node and mgm node to provide the redundancy. so that adds up to 5 computers for a reasonable setup.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.