Re: Upgrade to MySQL 5.0.24

[mikeh]

I shut down everything on .68

Un-tarred the mysql-max-5.0.24-linux-i686-glibc23 distribution into /usr/local/ and softlinked to mysql...
I then copied the data directory from mysql-max-5.0.22-linux-i686-glibc23 to mysql.

I have done this in the past upgrading from 5.0.15 to 20a and to 22

I run /usr/local/mysql/bin/ndb_mgmd on the command line and it sits there for a bit and then exits with nothing in any logs...
If I strace it I see;

socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 3
connect(3, {sa_family=AF_INET, sin_port=htons(1186), sin_addr=inet_addr("192.168.1.68")}, 16) = -1 ECONNREFUSED (Connection refused)
close(3) = 0

in the output. Maybe significant?

Now ndb_mgm works...

[root@dev bin]# ./ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 192.168.1.70:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=3 @192.168.1.70 (Version: 5.0.15, Nodegroup: 0, Master)
id=4 (not connected, accepting connect from 192.168.1.68)

[ndb_mgmd(MGM)] 2 node(s)
id=1 @192.168.1.70 (Version: 5.0.15)
id=2 (not connected, accepting connect from 192.168.1.68)

[mysqld(API)] 2 node(s)
id=5 @192.168.1.70 (Version: 5.0.15)
id=6 (not connected, accepting connect from 192.168.1.68)

ndb_mgm>

config.ini is;

[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas

[TCP DEFAULT]

[MGM]
Id=1
Hostname=192.168.1.70 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node logfiles

[MGM]
Id=2
Hostname=192.168.1.68 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node logfiles

[NDBD]
Id=3
Hostname=192.168.1.70 # Hostname or IP address
DataDir=/var/lib/mysql-cluster # Directory for this data node's datafiles

[NDBD]
Id=4
Hostname=192.168.1.68 # Hostname or IP address
DataDir=/var/lib/mysql-cluster

[MYSQLD]
Id=5
Hostname=192.168.1.70 # Hostname or IP address

[MYSQLD]
Id=6
Hostname=192.168.1.68 # Hostname or IP address

If I change the link back all starts correctly.