5.1.6-alpha NDB: Could not get apply status share
Hello,
I had a basic (working) cluster config using 4.1.18 on Red Hat ES4 (x86)
I removed all rpms for mysql-max, mysql-server, mysql-client, ndb-storage and ndb-management,
and installed the latest 5.1.6-alpha RPMs.
ndb_mgmd comes up fine, and shows the NDBD node connected, but not the MySQL instance,
and the MySQL instance has the following error in the mysql .err log -
060224 15:55:27 mysqld started
060224 15:55:37 [Note] Starting MySQL Cluster Binlog Thread
060224 15:55:37 InnoDB: Started; log sequence number 0 43655
060224 15:55:37 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.6-alpha' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
060224 15:55:37 [ERROR] NDB: Could not get apply status share
Sure enough, there is no apply status share table in the cluster_replication database.
This was from freshly starting mysql after having done a /usr/sbin/ndbd --initial.
I'm hoping that there are people out there happily running cluster with 5.1.6-alpha and that I've just
got a config error that was not apparent with 4.1.18 ?
My my.cnf on the node concerned is -
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysql_cluster]
ndb-connectstring=192.168.26.100
[mysqld]
ndbcluster
ndb-connectstring=192.168.26.100
datadir=/mysqldata/datadir
port = 3306
socket = /var/lib/mysql/mysql.sock
My cluster config.ini is (without having yet set up the second NDBD node) -
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Managment Server
[NDB_MGMD]
HostName=192.168.26.100 # the IP of THIS SERVER
# Storage Engines
[NDBD]
HostName=192.168.26.91 # the IP of the FIRST SERVER
DataDir=/mysqldata/datadir
[NDBD]
HostName=192.168.26.92 # the IP of the FIRST SERVER
DataDir=/mysqldata/datadir
#[NDBD]
#HostName=192.168.26.92 # the IP of the SECOND SERVER sovloaddb2
#HostName=192.168.26.13 # load111
#DataDir=/var/lib/mysql-cluster
# 2 MySQL Clients
# I personally leave this blank to allow rapid changes of the mysql clients;
# you can enter the hostnames of the above two servers here. I suggest you dont.
[MYSQLD]
#HostName=192.168.26.91 # the IP of the FIRST SERVER
[MYSQLD]
#HostName=192.168.26.92 # the IP of the SECOND SERVER
and ndb_mgm shows -
ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.26.91 (Version: 5.1.6, starting, Nodegroup: 0, Master)
id=3 (not connected, accepting connect from 192.168.26.92)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.26.100 (Version: 5.1.6)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)