🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.comp.database.mysql
Article #83

MySQL cluster

#83
From: Rytis Sileika
Date: Tue, 05 Oct 2004 11:48
105 lines
3272 bytes
Hi,

Has anybody ever got MySQL cluster running?

Now let me tell you me story.

step 1

Downloaded and built (nothing special, just configured with 
--with-ndbcluster option) MySQL 4.1.6. Compilation passed without any 
errors. MySQL itself runs smooth, no probs at all.

Fun began when I tried to start ndb_mgmd. I had to create Ndb.cfg file 
with the following info in it: nodeid=1;host=localhost:2200
All it did is just crashed without any warning (sytem prompted: Aborted, 
strace showed the same thing: +++ Killed by SIGABRT +++)

step 2

Downloaded and built (again, nothing special, same configure line as 
above) MySQL 5.0.2. Everything is fine as above, MySQL runs smoothly no 
probs.

Now, ndb_mgmd complained about 'no configuration file specified'.
Fair enough, I created config.ini (as show in MySQL doc example):
---
[NDBD DEFAULT]
NoOfReplicas: 1

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

[NDB_MGMD]
HostName = localhost

[NDBD]
HostName = localhost
DataDir: /mc-data

[MYSQLD]
[MYSQLD]
[MYSQLD]
---
What I get now is this:
"""
Illegal call to ConfigInfo::getInfo() - NDBD
Aborted
"""
After some try-and-error steps, I figured out that it does not like the 
' DEFAULT' bit in the conf file. Good, here's my next attempt:
---
[NDBD]
NoOfReplicas: 1

[MYSQLD]

[NDB_MGMD]

[TCP]

[NDB_MGMD]
HostName = localhost

[NDBD]
HostName = localhost
DataDir: /mc-data

[MYSQLD]
[MYSQLD]
[MYSQLD]
---
Now I get:
"""
Error line 4: Parameter "ExecuteOnComputer" missing from DB section [DB] 
starting at line: 1
Error line 4: Could not store previous section of configuration file.
"""
Why??? Why would I need DB section on my mgmt node? Anyway, adding lines
[DB]
ExecuteOnComputer: 1
did give me exaclty the same result... Strange, ain't it? (Adding 
[COMPUTER] section did not help)

Right. Let's then start from the very beginning. And that would be a 
config file:
---
[NDB_MGMD]
HostName = localhost
---
This gave an immediate: 'Aborted'. No additional comments at all.

Could anyone give me an example of how to configure this thing properly? 
It all seems that failures are due to some buggy code. Or am I 
configuring and building this thing somehow improperly?
BTW, exactly the same behavior I observe on SuSE 8 (2.4.19 kernel) and 
Mandrake 10 (whatever kernel it's got)

All I want to do is to get two server running MySQL in a cluter, with 
mgmd on one of them.

Regards,
Rytis Sileika
Technical Details
Message-ID: <2sfg53F1i1tbmU1@uni-berlin.de>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 114450,6093b4683a1aa80b,start
X-Google-Attributes: gid114450,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: Rytis Sileika <rytis@_NS--PLEASE-REMOVE-THIS_dr.com>
Newsgroups: cn.comp.database.mysql
Subject: MySQL cluster
Date: Tue, 05 Oct 2004 12:48:37 +0100
Lines: 105
Message-ID: <2sfg53F1i1tbmU1@uni-berlin.de>
Reply-To: rytis@_NS--PLEASE-REMOVE-THIS_dr.com
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de fzCk6wuEdQGDPEVuQfhwfQm/+7ZYmVEZ9rAq5iS2BxVuwUfCXI
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: en-us, en