Hell ch,
On Tue, 2009-10-13 at 21:35 +0800, ch huang wrote:
> Thanks for your reply .
> I aleady test the two data node in one machine(use xen domain-U 1.5G
> RAM/domain-U),when I insert huge data to a table one node was often
> disconnected from cluster,someone told me to seperate data node to
> different physical machines and it did work fine,I do not know why,I
> do not know how to set several data node in one physical machine
Simply start ndbd (or ndbmtd) multiple times specifying a different node
ID every time in the connect string.
> Now I have more powerful servers,I want to rearranger my cluster one
> data node in 8GRAM-machine ,another 24GRAM host another data node and
> also host 2 sql nodes ,the other two 32bit machine host one sql node
> each,is it ok?
> The cluster just use for test the NDB performance
This is possible but you need to be careful the data node and sql nodes
do not fight for resources if they are on the same machine.
> I already test my old cluster(4 sql nodes in one 2GRAM box,2 data node
> in one 4G box using xen domain-U 1.5G/domain-U),the result compare
> with single box DB using MyISAM engine,MyISAM get double performance
> over NDB,and now our DB arch is Master-slave ,all table is MyISAM
> engine DB writer is 90% DB read is 10%,with this dissatisfy test
> result,I wonder if it is right to move DB from M-s to NDB
Comparing with MyISAM is like comparing apples with oranges. You are
comparing a non-transactional single server storage engine with a
synchronously replicated transactional storage engine. Even comparing
MyISAM and InnoDB will give you poor results in certain situations. In
other situations NDB will perform a lot better than both InnoDB and
MyISAM.
Kind Regards
--
Andrew Hutchings, MySQL Support Engineer, Americas
Sun Microsystems, United Kingdom
http://www.sun.com/mysql/
