Re: Auto-Installer Errors- CentOS server setup

[Sergey Anokhin]

Dustin Platter Wrote:
-------------------------------------------------------
> I am looking for some help with setting up a MySQL
> Cluster on a pair of Linux servers. I'm fairly new
> to working with servers, so I may be overlooking
> something simple. We have two physical servers
> each running two virtual managers. The second VM
> of each physical is to be our database Cluster
> (that way if one server is off, the other steps
> in). The operating system is CentOS 6.5, and we
> can call the user 'adminuser'. He should have full
> access to the system.
>
> Error message: Command
> '/home/adminuser/MySQL_Cluster_7.3.4/bin/ndbmtd--n
> db-nodeid=1--ndb-
> connectstring=MyIPaddress:1186,',running on
> MyIPaddress exited with 1.
> timestamp [ndbd] INFO '--Angel connected to
> 'MyIPaddress:1186'
> timestamp [ndbd] ERROR --Failed to allocate
> nodeid, error: 'Error:Could not alloc node id at
> MyIPaddress port 1186: Id 1 already allocated by
> another node.'
>
>
> Note: The system is on an internal server with no
> internet connection.
>
> Install Settings: Application area is 'web
> application' with medium write load. Username is
> 'adminuser' with password. Host list is the IP
> address of the two physical servers. Server 1 has
> a management node, 2 API nodes, an SQL node, and a
> multi-threaded data node. Server 2 has 2 API
> nodes, an SQL node, and a multi-threaded data
> node.
>
>
> I would appreciate any guidance with resolving
> this issue.

Hi! Please show me your config.ini?
What says "netstat -nlp | grep 1186" when you see an error message?

As far as I understand the situation usually do not put ndbmtd node id = 1
For examlpe my config.ini:
cat /var/lib/mysql-cluster/config.ini
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=256M
IndexMemory=32M
RedoBuffer=16M
DiskPageBufferMemory=64M
SharedGlobalMemory=20M
#SharedGlobalMemory=200M
#MaxNoOfOrderedIndexes=8196
#MaxNoOfUniqueHashIndexes=2048
#MaxNoOfAttributes=9600
TimeBetweenLocalCheckpoints=10
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]

[NDB_MGMD]
NodeId=1
HostName=10.15.10.25

[NDB_MGMD]
NodeId=2
HostName=10.15.10.28

[NDBD]
NodeId=3
HostName=10.15.10.26
DataDir= /var/lib/mysql-cluster

[NDBD]
NodeId=4
HostName=10.15.10.27
DataDir=/var/lib/mysql-cluster

PS Why do you use such a long line to start ndbmtd? Why not use it to run a startup script? I found this on the internet, you can rewrite it in the case of ndbmtd:

#!/bin/sh
#
# ndbd: MySQL Cluster Storage node
#
# chkconfig: 2345 90 20
# description: MySQL Cluster Storage node
#


# Source function library.
. /etc/init.d/functions

start()
{
echo -n $"Starting ndbd: "
daemon /usr/sbin/ndbd

touch /var/lock/subsys/ndbd
echo
}

stop()
{
echo -n $"Shutting down ndbd: "
killproc ndbd

rm -f /var/lock/subsys/ndbd
echo
}


[ -f /usr/sbin/ndbd ] || exit 0

# See how we were called.
case "$1" in
start)
start
;;
stop)
stop
;;
restart|reload)
stop
start
;;
condrestart)
[ -e /var/lock/subsys/ndbd ] && (stop; start)
;;
*)
echo $"Usage: $0 {start|stop|restart|reload|condrestart}"
exit 1
esac

I understand ndbmtd to run (as well as ndbd) does not require specific command line options?