I've been working on this for a few days now, with Alex Davies helping. He suggested I
post the trace log during this issue, but it comes out as ALL 0's, no information at all.
Let me re-cap:
I get ndb_mgmd running, then try to run one of my cluster machines with
ndbd --initial
That tries to connect to localhost:2200 even though my /etc/my.cnf file contains:
ndbcluster
ndb-connectstring=10.129.29.42 # the IP of the MANAGMENT (THIRD) SERVER
[mysql_cluster]
ndb-connectstring=10.129.29.42 # the IP of the MANAGMENT (THIRD) SERVER
I then tried running:
ndbd --initial -c "host=10.129.29.42:1186" ## To get the right machine, the right port. I
get this error:
Current byte-offset of file-pointer is: 468
Date/Time: Tuesday 4 January 2005 - 10:12:46
Type of error: error
Message: Invalid Configuration fetched from Management Server
Fault ID: 2350
Problem data: Invalid configuration fetched
Object of reference: No transporters configured
ProgramName: NDB Kernel
ProcessID: 3380
TraceFile: ndb_2_trace.log.1
***EOM***
But there is nothing but zeroes in the trace.log file..
Can anyone point me in the right direction?????
Thanks in advance!
G.
-----Original Message-----
From: Gary Every
Sent: Thu 12/30/2004 1:43 PM
To: alex@stripped; cluster@stripped
Cc:
Subject: RE: HOWTO set up a three server setup (closest possible to two server setup)
I am using 4.1.8,
mysql>show variables like '%version%';
+-------------------------+-------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+-------------------------------------------------------------+
| protocol_version | 10 |
| version | 4.1.8-max |
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (December 14, 2004) |
| version_comment | Official MySQL-max binary |
| version_compile_machine | i686 |
| version_compile_os | pc-linux |
+-------------------------+-------------------------------------------------------------+
I also added the 1186 port to my.cnf, but it is still reporting the port 2200 on the ndbd
error.
So I tried:
ndbd -c "host=10.129.29.42:1186" --initial
and got:
2004-12-30 13:34:46 [NDB] INFO -- Angel pid: 28997 ndb pid: 28998
Error handler shutting down system
Error handler shutdown completed - exiting
My ps -ef | grep ndb sows nothing
Is there any way of getting more verbose error information?
-----Original Message-----
From: Alex Davies [mailto:daviesalex@stripped]
Sent: Thu 12/30/2004 1:26 PM
To: Gary Every; cluster@stripped
Cc:
Subject: Re: HOWTO set up a three server setup (closest possible to two server setup)
Hi Gary,
Are you using mysql 4.1.8? It looks to me that you might be using
4.1.7 from the port. If so you NEED to use mysql 4.1.8 because they
have changed stuff in it (starting with the port).
If you are on 4.1.8, try setting the port directive in /etc/my.cnf:
[mysqld]
ndbcluster
ndb-connectstring=192.168.0.3:1186
[mysql_cluster]
ndb-connectstring=192.168.0.3:1186
(note the :1186).
Another idea: have you got any firewalls between you and the managment
server? If so stop them to eliminate that as a possible problem.
Finally, if you got to the managment server and type the following
what do you get?
ps aux | grep ndb_mgmd
Alex
On Thu, 30 Dec 2004 13:23:56 -0600, Gary Every
<Gary.Every@stripped> wrote:
> I've gone through the tutorial, but when I get to Stage 3, the ndbd --initial it
> gives me this output:
>
> WARNING: Failed to retrieve cluster configuration
> (Cause of failure: Unable to connect to localhost:2200)
> Attempt 1 of 12. Trying again in 5 seconds...
>
> WARNING: Failed to retrieve cluster configuration
> (Cause of failure: Unable to connect to localhost:2200)
> Attempt 2 of 12. Trying again in 5 seconds...
>
> I've looked through the mysql.server info, but was unable to find anything useful or
> even that pointed to port 2200
>
> TIA
>
>
> -----Original Message-----
> From: Alex Davies [mailto:daviesalex@stripped]
> Sent: Thu 12/30/2004 5:10 AM
> To: cluster@stripped
> Cc:
> Subject: HOWTO set up a three server setup (closest possible to two server
> setup)
> Hi Everyone,
>
> I have written a tutorial which will take two clean servers and a
> third random server (which needs only minor modifications) and turn
> them into a MySQL Cluster. This is suitable for those who are behind a
> loadbalancer or using round robin DNS.
>
> The HOWTO can be found at http://www.davz.net/static/howto/mysqlcluster/.
>
> Please note that it IS NOT POSSIBLE TO SET UP A MYSQL CLUSTER WITH
> JUST TWO MACHINES. You NEED the third machine (although it is only
> required when starting or stopping the cluster).
>
> This HOWTO was produced with the help of several cluster users and
> addresses the most common problems that people have when setting up
> mysql cluster so I strongly suggest that you follow it before posting
> here.
>
> If you find it useful please link to it. If anyone has any comments
> please email me (email address on the site).
>
> Alex Davies
> --
> Alex Davies // http://www.davz.net
>
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the sender immediately by e-mail and delete this e-mail permanently.
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe: http://lists.mysql.com/cluster?unsub=1
>
>
>
--
Alex Davies // http://www.davz.net
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender immediately by e-mail and delete this e-mail permanently.
