MySQL Forums
Forum List  »  NDB clusters

Trouble start cluster on AIX
Posted by: Beate Schlesiona
Date: November 16, 2005 05:26AM

Hi, I try to install a cluster on AIX. I tried with 1 MGM Node and two Data Nodes, then only with 1 MGM and 1 Data, only for the test.
The steps:
1. I put ndb_mgm* in the directory /opt/local/bin.

tar -xvf mysql-max-4.1.14-ibm-aix5.2.0.0-powerpc.tar
cd mysql-max-4.1.14-ibm-aix5.2.0.0-powerpc/bin
cp ndb_mgm* /usr/local/bin
cd /opt/local/bin
chmod +x ndb_mgm*

2. Then I created the directory /var/lib/mysql-cluster
mkdir /var/lib/mysql-cluster
cd /var/lib/mysql-cluster

3. I created config.ini
vi config.ini
# Options affecting ndbd processes on all data nodes:
[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas

# TCP/IP options:
[TCP DEFAULT]
portnumber=2202

# Management process options:
[NDB_MGMD]
hostname=---.---.---.137 # IP of MGM node (in original is completly!!!)
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

# Options for data node "A":
[NDBD]
# (one [NDBD] section per data node)
hostname=---.---.---.137 # Hostname or IP address
datadir=/opt/local/mysql/data # Directory for this data node's datafiles

# Options for data node "B":
[NDBD]
hostname=---.---.---.135 # Hostname or IP address
datadir=/opt/local/mysql/data # Directory for this data node's datafiles

# SQL node options:
[MYSQLD]
[MYSQLD]

4. Then I installed the Data Nodes

cd /opt/local
ln -s mysql-max-4.1.14-ibm-aix5.2.0.0-powerpc mysql
cd mysql
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data
chgrp -R mysql .

5. I created the file my.cnf
vi /etc/my.cnf


# Options for mysqld process:
[MYSQLD]
ndbcluster # run NDB engine
ndb-connectstring=---.---.---.137 # location of MGM node

# Options for ndbd process:
[MYSQL_CLUSTER]
ndb-connectstring=---.---.---.137 # location of MGM node

6. I started the mgm Server

cd /opt/local/bin
ndb_mgmd -f /var/lib/mysql-cluster/config.ini

7. I started the data node:

cd /opt/local/mysql/bin
./ndbd --initial

The first error was, that my limit was to low. I But now ( the limit is now okay), I don't understand the message at all!

The err-log:

Date/Time: Wednesday 16 November 2005 - 11:06:06
Type of error: error
Message: Send signal error
Fault ID: 2339
Problem data: Signal (GSN: 95, Length: 7, Rec Block No: 0)
Object of reference: SimulatedBlock.cpp:199
ProgramName: ./ndbd
ProcessID: 1282134
TraceFile: /opt/local/mysql/data/ndb_2_trace.log.4
Version 4.1.14
***EOM***
Does nobody the reason?
Can someone help me?
Beate

Options: ReplyQuote


Subject
Views
Written By
Posted
Trouble start cluster on AIX
2191
November 16, 2005 05:26AM


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.