Article View: cn.comp.database.mysql
Article #83MySQL cluster
From: Rytis Sileika
Date: Tue, 05 Oct 2004 11:48
Date: Tue, 05 Oct 2004 11:48
105 lines
3272 bytes
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-mailShow 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