Hello everyone,
I've trouble with the Installation of the SQL-Node for my
SQL-Server-Cluster.
I'm a bit stuck and would appreciate any help =)
Somehow its not possible to keep the connection between SQL-Node and
Management-Server, although the systems are in the same local network,
no firewall between them or installed on them.
Management-Server Log:
2012-10-18 15:22:18 [MgmSrvr] ALERT -- Node 2: Node 4 Disconnected
2012-10-18 15:22:19 [MgmSrvr] ALERT -- Node 3: Node 4 Disconnected
2012-10-18 15:22:21 [MgmSrvr] INFO -- Node 3: Communication to Node
4 opened
2012-10-18 15:22:22 [MgmSrvr] INFO -- Node 2: Communication to Node
4 opened
2012-10-18 15:32:04 [MgmSrvr] INFO -- Mgmt server state: nodeid 4
freed, m_r eserved_nodes 0000000000000002.
2012-10-18 15:32:38 [MgmSrvr] INFO -- Mgmt server state: nodeid 4
reserved f or ip 10.30.254.60, m_reserved_nodes 0000000000000012.
2012-10-18 15:32:38 [MgmSrvr] INFO -- Node 4: mysqld --server-id=0
2012-10-18 15:32:39 [MgmSrvr] INFO -- Node 2: Node 4 Connected
2012-10-18 15:32:39 [MgmSrvr] INFO -- Node 2: Node 4: API version 7.2.8
2012-10-18 15:32:39 [MgmSrvr] INFO -- Node 3: Node 4 Connected
2012-10-18 15:32:39 [MgmSrvr] INFO -- Node 3: Node 4: API version 7.2.8
2012-10-18 15:32:43 [MgmSrvr] WARNING -- Node 2: Node 4 missed heartbeat 2
2012-10-18 15:32:43 [MgmSrvr] WARNING -- Node 3: Node 4 missed heartbeat 2
2012-10-18 15:32:45 [MgmSrvr] WARNING -- Node 2: Node 4 missed heartbeat 3
2012-10-18 15:32:45 [MgmSrvr] WARNING -- Node 3: Node 4 missed heartbeat 3
2012-10-18 15:32:46 [MgmSrvr] WARNING -- Node 2: Node 4 missed heartbeat 4
2012-10-18 15:32:46 [MgmSrvr] ALERT -- Node 2: Node 4 declared dead
due to mi ssed heartbeat
2012-10-18 15:32:46 [MgmSrvr] INFO -- Node 2: Communication to Node
4 closed
2012-10-18 15:32:46 [MgmSrvr] INFO -- Node 3: Communication to Node
4 closed
2012-10-18 15:32:46 [MgmSrvr] ALERT -- Node 2: Node 4 Disconnected
2012-10-18 15:32:46 [MgmSrvr] ALERT -- Node 3: Node 4 Disconnected
2012-10-18 15:32:49 [MgmSrvr] INFO -- Node 2: Communication to Node
4 opened
2012-10-18 15:32:49 [MgmSrvr] INFO -- Node 3: Communication to Node
4 opened
Environment: SuSE SLES 11.2
Steps @ management Server:
zypper in mysql-ndb-management
zypper in mysql-ndb-extra
zypper in mysql-ndb-tools
*|mkdir /var/lib/mysql-cluster|*
*|cd /var/lib/mysql-cluster|*
*|vi config.ini|*
[ndbd default]
#Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=2G # How much memory to allocate for data storage
IndexMemory=500M
MaxNoOfConcurrentOperations=150000
MaxNoOfAttributes=10000
MaxNoOfOrderedIndexes=512
[tcp default]
# TCP/IP options:
portnumber=2202
[ndb_mgmd]
Id=1
hostname=dfbsvmdsmg01 # Hostname or IP address of MGM node
datadir=/var/lib/mysql-cluster # Directory for MGM node log files
[ndbd]
Id=2
hostname=dfbsvmndb01 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files
[ndbd]
Id=3
hostname=dfbsvmndb02 # Hostname or IP address
datadir=/usr/local/mysql/data # Directory for this data node's data files
[mysqld]
Id=11
# SQL node options:
hostname=dfbsvmmysql01 # Hostname or IP address
---
Steps taken on SQL-Node:
rpm -Uhv MySQL-Cluster-server-gpl-7.2.8-1.sles11.x86_64.rpm
rpm -Uhv MySQL-Cluster-client-gpl-7.2.8-1.sles11.x86_64.rpm
touch /etc/my.cnf
vim /etc/my.cnf
[mysqld]
ndbcluster
ndb-connectstring=dfbsvmdsmg01
[mysql_cluster]
ndb-connectstring=dfbsvmdsmg01
-------
Any suggestions?
Best regards,
Janos
--
Mit freundlichen Grüßen / Kind regards
Janos Lehnhardt
Daimler FleetBoard GmbH
IT-Management
HPC: Z400
70546 Stuttgart-Vaihingen/Germany
Phone +49-(0) 711 - 17-99090
Fax: +49-(0) 711 - 17-79084270
Mail: janos.lehnhardt@stripped
Internet: http://www.fleetboard.com
---
Daimler FleetBoard GmbH
Sitz und Registergericht/Domicile and Court of Registry: Amtsgericht Stuttgart
HRB-Nr./Commercial Register No.: 724754
Geschäftsführung/Managing Director: Markus Lipinsky, Patrick Hackenberger
If you are not the intended addressee, please inform us immediately that you have received
this e-mail in error, and delete it. We thank you for your cooperation.
