List:Cluster« Previous MessageNext Message »
From:Janos Lehnhardt Date:October 18 2012 3:09pm
Subject:Installation of SQL-Node - connection established & heartbeat not
working
View as plain text  
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.


Thread
Installation of SQL-Node - connection established & heartbeat notworkingJanos Lehnhardt18 Oct
  • Re: Installation of SQL-Node - connection established & heartbeatnot workingJohan De Meersman18 Oct
    • Re: Installation of SQL-Node - connection established & heartbeatnot workingJanos Lehnhardt19 Oct
  • Re: Installation of SQL-Node - connection established & heartbeatnot workingMagnus BlĂ„udd26 Oct