MySQL Forums
Forum List  »  NDB clusters

5.1.6-alpha NDB: Could not get apply status share
Posted by: David Abbott
Date: February 24, 2006 10:08AM

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)

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.