MySQL cluster ndb_mgmd problems on FreeBSD 7.x

Hello,

I have four machines, each of them are in the same IP subnet and running FreeBSD 7.0-BETA2. On these machines I'm trying to set up a MySQL cluster (one management node, one SQL node and two data nodes).
The problem is that on the management node I can't use the NDB management client (/usr/local/bin/ndb_mgm), even on localhost and also, the MySQL process on the SQL node can't connect to the management node.

The strange thing is that if I install a 6-STABLE world into a directory, install the same MySQL from ports in that chroot, and run the NBD management daemon (ndb_mgmd) *outside* the chroot (so a 6.x binary in 7.x world), everything starts to work perfectly.

I'm not sure where could I start.

So: with an ndb_mgmd built on 6.x and ran on 7.x the whole stack works, with the same binary, but built and ran on 7.x it does not (the NDB management client is unusable and the MySQL daemon can't connect too).

The config is very basic.
NDB-related config:
[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
[ndb_mgmd]
hostname=172.16.1.2
datadir=/data/mysql-cluster
[ndbd]
hostname=172.16.1.8
datadir=/data/mysql
[ndbd]
hostname=172.16.1.9
datadir=/data/mysql
[mysqld]
hostname=172.16.1.4

my.cnf on the SQL node:
[mysqld]
ndbcluster
ndb-connectstring = 172.16.1.2
datadir = /data/mysql
socket = /tmp/mysql.sock
[mysql_cluster]
ndb-connectstring = 172.16.1.2

Any ideas? Anybody running MySQL cluster on 7.x?

Thanks,

--
Attila Nagy e-mail: Attila.Nagy@xxxxxx
Free Software Network (FSN.HU) phone: +3630 306 6758
http://www.fsn.hu/

_______________________________________________
freebsd-current@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to "freebsd-current-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • mysq/php/blowfish (was vtiger/mysql/encryption)
    ... MySQL stores and php encrypts/decrypts data. ... I used mysqldump and saw that the passwords in MySQL ... machines with varying success. ...
    (freebsd-questions)
  • Re: MySql Load balancing Solutions?
    ... I am part of a team running MySQL 4.1.X on 5 machines in a replication ... A positive advantage is that the 5 machines allows us the opportunity to ... slave to a "W"rite server until the original "W"rite server can be recovered. ... When it comes to management I won't lie, 4.0.XX's handling of Replication ...
    (freebsd-questions)
  • MYSQL connection problem
    ... Both machines have the same configuration. ... Both mysql were compiled from the ports with the same options. ... Here are the outputs of the following commands on machine 1): ... Connection closed by foreign host. ...
    (freebsd-questions)
  • Re: VS .NET 2005 Express + Mysql 5
    ... I even put the MySQL connector/.NET classes in my VS2005 toolbox. ... use Mysql 5 and Office 2007 in automation. ... versions of office installed on our client's machines. ... compatibility mode. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Possible Threading problem with -CURRENT / MySQL?
    ... NetGroup Processing Aps ... Possible Threading problem with -CURRENT / MySQL? ... We have used FreeBSD on non-smp machines for a long time (even the 5.x ... > all console out put from teh boot-loader-on will now go to teh serial ...
    (freebsd-current)