From: Andrew Morgan Date: October 27 2010 10:41am Subject: RE: testing the cluster List-Archive: http://lists.mysql.com/cluster/7865 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Hi Stefano, My first comment would be to do your testing with MySQL Cluster 7.1 - a hu= ge amount has improved since 5.0. Also make sure that you use the MySQL Ser= ver (mysqld) binaries that come with the Cluster binaries as it is differen= t to the regular MySQL 5.1 version. When storing your tables with the ndb storage engine, the mysqlds act as i= nterface nodes - all of the data is held in the data nodes. The test you sh= ould do is to add through one mysqld and then check for the rows from the s= econd mysqld - the changes should be instantly visible. The names of the database doesn't match to a file on the data nodes. If yo= u look in the data directories for the data nodes then you should see that = files get created there but they don't represent the database name(s). Note= that by default Cluster stores the data in memory but checkpoints the data= to disk asynchronously to help with recovery. Regards, Andrew. > -----Original Message----- > From: stefano ppp [mailto:thgnss@stripped] > Sent: 27 October 2010 11:33 > To: cluster@stripped > Subject: testing the cluster >=20 > Hi all, > I'm working with debian distribution and MySQL 5.0. > I tried to follow the ufficial documentation to startup a cluster but I > can't understand a couple of things. > I have 5 hosts: 1 management node (mgm), 2 sql node (sql1,sql2) and 2 dat= a > node (ndb1,ndb2). > After the initial configuration I tried to start up the cluster and all > seems good; the output of the show command of the management client on th= e > mgm host is ok: all nodes are connected. > The next step is to create some database in order to have some trial. > So I created a databases named world on s1 and imported the sample world.= sql > after changing the engine in NDB for all the tables. > Next step was to create a database named world on s2 and as I typed 'use > world' it read all the tables and updated the database. > Now if I create/delete tables or records on one sql host, this is reflect= ed > over the other and it's fine. > Anyway my questions are: > Are the data just created stored on ndb1 and ndb2? > If so, why there is no track on these hosts of the world database? >=20 > Finally there is something in a documentation I found that I can't undest= and > "The final thing you are likely to want to check is that all your SQL nod= es > are actually working, so if you insert one row on one node, it does appea= r > on all the others. You can do this by logging in to each storage node and > inserting another row before selecting all rows". > Someone can suggest me how to do this if I have no information on my data > nodes? >=20 > Thanks in advance > Regards