MySQL Forums
Forum List  »  NDB clusters

Phase 5, dual ndbd_mgmd & stuff
Posted by: Marcel Prisi
Date: June 16, 2006 03:15AM

Hi all,

I have a partially working cluster with the following setup

2 * Sun X4200 / 8Gb RAM / Centos 4.3 x86_64 (mysqld & ndbd) .46 & .47 mysql-max-5.0.22-linux-x86_64-glibc23.tar.gz
2 * Sun x2100 /2 Gb RAM / Debian Sarge i386 (ndb_mgmd & others) .42 & .45 mysql-max-5.0.22-linux-i686.tar.gz

All is networked through gbit switch, and all machines use ethernet bonding.

I suppose mixing i386(ndb_mgmd) & x86_64(mysqld&ndbd) is no trouble ?

Configs at the end.

I double checked config.ini's, they are identical.

- about 4 times out of 5, both ndb_mgmd's don't see each other, they both seem to think that the other died, and once in a while, after some stop/starts, it works ... has anyone seen this ?

I had to reboot both ndbd nodes in order to install a kernel update, so I stopped ndbd1 (using ndb_mgm) and then rebooted it, it came back OK.

When it was fully back up after a few minutes, (Node 3: started (Version 5.0.22)), I did the same to ndbd2.

- It was about an hour ago, and I still have : Node 4: starting (Phase 5) (Version 5.0.22) what is the problem ?

One of the mysqld seems to regularly disappear and come back. I saw this in the error log :

mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=4
max_connections=400
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2030012 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.


Number of processes running now: 0
060616 11:13:35 mysqld restarted

Any clues ??

- I installed phpMyAdmin for one of our developers, but it is so slow that it is barely usable, getting the list of tables in a database takes ages. Is there any error in my setup ?

Thanks for helping.

config.ini

[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas
DataMemory=4G # How much memory to allocate for data storage
IndexMemory=512M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
MaxNoOfAttributes = 15000
MaxNoOfOrderedIndexes = 6000
MaxNoOfUniqueHashIndexes = 6000
MaxNoOfConcurrentOperations = 49152
MaxNoOfConcurrentTransactions = 8192
# This next line should be used in normal use of the
# cluster.
#TimeBetweenLocalCheckPoints = 20
# This next line should be used if doing heavy loading of
# data into the cluster.
TimeBetweenLocalCheckPoints = 6

# TCP/IP options:
[TCP DEFAULT]
portnumber=2202 # This the default; however, you can use any
# port that is free for all the hosts in cluster
# Note: It is recommended beginning with MySQL 5.0 that
# you do not specify the portnumber at all and simply allow
# the default value to be used instead

# Management process options:
[NDB_MGMD]
hostname=192.168.200.45 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

[NDB_MGMD]
hostname=192.168.200.42 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

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

# Options for data node "B":
[NDBD]
hostname=192.168.200.47 # Hostname or IP address
datadir=/lvm/mysql-cluster # Directory for this data node's datafiles

# SQL node options:
[MYSQLD]
hostname=192.168.200.46 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)
[MYSQLD]
hostname=192.168.200.47 # Hostname or IP address

/etc/my.cnf :

[mysqld]
ndbcluster
ndb-connectstring=192.168.200.42
port = 3306
socket = /tmp/mysql.sock
skip-locking
datadir=/lvm/mysql
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
max_connections = 400
...
[mysql_cluster]
ndb-connectstring=192.168.200.42

Options: ReplyQuote


Subject
Views
Written By
Posted
Phase 5, dual ndbd_mgmd & stuff
1824
June 16, 2006 03:15AM


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.