On Fri, 2004-09-03 at 13:31, Wouter de Jong wrote:
> On Fri, Sep 03, 2004 at 10:45:59AM +0000, Tomas Ulin wrote:
>
> Hi ya Tomas,
>
> > Please post your current config file. If it is the one below, it has
> > errors than may be causing yor problems.F
>
> I've attached it, so the message wouldn't become too long.
> OS is on all servers FreeBSD 5.2.1, MySQL-version is 4.1.3-beta
>
> But NOTE: it works now!
> I've played with the config.ini a while, and the one attached works.
> The thing I've changed now, is the ID order of the DB-nodes.
>
> What doesn't work:
> db-id2@computer2,db-id3@computer3,db-id4@computer2,db-id5@computer3
> What does works:
> db-id2@computer2,db-id3@computer2,db-id4@computer3,db-id5@computer3
>
> So if you have multiple DB-nodes on a server, you must issue following-up
> ID's (2,3,4 etc) for all the nodes on this computer, and after all DB-nodes
> on a computer have such an ID, then you can issue ID's to the DB-nodes of
> the next-computer... This is not documented or I've missed it.
Great, you got the cluster started!
But, you should be able configure your system with node 2 and 3 on
different computers. Actually it's important that you do it that way to
get the nodegroups correct. Since the data in one node is replicated to
the other node in it's nodegroup, you don't want the whole nodegroup on
the same computer.
You can check which nodegroup a node belongs to, by using the SHOW
command of ndb_mgm, see below.
#> ndb_mgm
-- NDB Cluster -- Management Client --
Connecting to Management Server: localhost:2200
NDB> show
Cluster Configuration
---------------------
4 NDB Node(s)
DB node: 2 (Version: 3.5.0, Nodegroup: 0, Master)
DB node: 3 (Version: 3.5.0, Nodegroup: 0)
DB node: 4 (Version: 3.5.0, Nodegroup: 1)
DB node: 5 (Version: 3.5.0, Nodegroup: 1)
1 MGM Node(s)
MGM node: 1 (Version: 3.5.0)
5 API Node(s)
API node: 6 (not connected)
API node: 7 (not connected)
API node: 8 (not connected)
API node: 9 (not connected)
API node: 10 (not connected)
> Also, could somebody explain to me what 'arbitrator' is ?
The arbitrator is used to avoid network partitioning. If you would
unplug the network cable between your two computers, the cluster would
become partitioned and the two nodes on either side would continue to
run as if nothing has happened, unless the arbitrator would step in and
decide which side should win(stay alive). "A normal configuration uses
the management server as arbitrator setting the ArbitrationRank to 1
(which is the default)"
>
> Anyway, explanation of my working config is as follows (if any one is
> interested at all now):
>
> Server s04: MANAGEMENT-NODE
> * /usr/local/mysql41/cluster/node1/Ndb.cfg:
> nodeid=1;host=s04.srv.fiqz.com:2200
> * /usr/local/mysql41/cluster/node1/config.ini
> [SEE ATTACHMENT]
>
> Server s03: 2x DB-NODE, 1x API-NODE
> * /usr/local/mysql41/cluster/node2/Ndb.cfg:
> nodeid=2;host=s04.srv.fiqz.com:2200
> * /usr/local/mysql41/cluster/node3/Ndb.cfg:
> nodeid=3;host=s04.srv.fiqz.com:2200
> * /usr/local/mysql41/var/Ndb.cfg:
> nodeid=6;host=s04.srv.fiqz.com:2200
>
> Server s02: 2x DB-NODE, 1x API-NODE
> * /usr/local/mysql41/cluster/node4/Ndb.cfg:
> nodeid=4;host=s04.srv.fiqz.com:2200
> * /usr/local/mysql41/cluster/node5/Ndb.cfg:
> nodeid=5;host=s04.srv.fiqz.com:2200
> * /usr/local/mysql41/var/Ndb.cfg:
> nodeid=7;host=s04.srv.fiqz.com:2200
--
Magnus Svensson, Software Engineer
MySQL AB, www.mysql.com
Office: +46 709 164 491
