Skip navigation links

MySQL Forums :: Cluster :: Regarding cluster config for mysql-5.1.30 ndb-6.3.20


Advanced Search

Regarding cluster config for mysql-5.1.30 ndb-6.3.20
Posted by: vijay baskar ()
Date: September 20, 2009 07:01PM

Hi there,

I would like someone to review the mysql cluster configuration listed before.

Version information: mysql-5.1.30 ndb-6.3.20

Iam using 2 mgmd nodes and 2 data nodes and api nodes connected to each data nodes.

Two hosts has 4 GB RAM each and the no of tables that I want to store is 300 including BLOB etc.

My ndbconfig.ini file in two hosts.


[DB DEFAULT]
NoOfReplicas: 2
MaxNoOfConcurrentOperations: 100000
DataMemory: 900M
Diskless: 1
IndexMemory: 96M
BackupMemory: 4M
BackupDataBufferSize: 2M
BackupLogBufferSize: 2M
BackupWriteSize: 32k
HeartbeatIntervalDbDb: 3000
HeartbeatIntervalDbApi: 3000
TimeBetweenLocalCheckpoints: 20
TimeBetweenGlobalCheckpoints: 1500
TimeBetweenWatchDogCheck: 30000
TransactionInactiveTimeOut: 5000
MaxNoOfConcurrentTransactions: 2024
MaxNoOfConcurrentScans: 150
MaxNoOfTables: 500
NoOfFragmentLogFiles: 8
LockPagesInMainMemory: 1
StartPartialTimeout: 10000
StartPartitionedTimeout: 10000
StopOnError: 0
DataDir: /opt/MGC/var
ODirect: 1

[COMPUTER]
Id:1
HostName: 10.4.1.254

[COMPUTER]
Id:2
HostName: 10.4.1.253

[NDB_MGMD]
Id: 1
ExecuteOnComputer: 1
ArbitrationRank: 1
PortNumber:10001
DataDir: /opt/MGC/var
LogDestination: FILE:filename=/opt/MGC/var/ndb_cluster1.log,maxsize=1000000,maxfiles=5

[NDB_MGMD]
Id: 2
ExecuteOnComputer: 2
ArbitrationRank: 1
PortNumber:10001
DataDir: /opt/MGC/var
LogDestination: FILE:filename=/opt/MGC/var/ndb_cluster1.log,maxsize=1000000,maxfiles=5

[DB]
Id: 3
ExecuteOnComputer: 1

[DB]
Id: 4
ExecuteOnComputer: 2

[API DEFAULT]
ArbitrationRank: 0

[API]
Id: 10

[API]
Id: 11

[API]
Id: 12

[API]
Id: 13

[API]
Id: 14

[API]
Id: 15

===============

ndb_mgm --connect-string="host=10.4.1.254:10001" -e show
Connected to Management Server at: 10.4.1.254:10001
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=3 @10.4.1.254 (mysql-5.1.30 ndb-6.3.20, Nodegroup: 0, Master)
id=4 @10.4.1.253 (mysql-5.1.30 ndb-6.3.20, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=1 @10.4.1.254 (mysql-5.1.30 ndb-6.3.20)
id=2 @10.4.1.253 (mysql-5.1.30 ndb-6.3.20)

[mysqld(API)] 6 node(s)
id=10 @10.4.1.253 (mysql-5.1.30 ndb-6.3.20)
id=11 @10.4.1.254 (mysql-5.1.30 ndb-6.3.20)
id=12 (not connected, accepting connect from any host)
id=13 (not connected, accepting connect from any host)
id=14 (not connected, accepting connect from any host)
id=15 (not connected, accepting connect from any host)


Problem is cluster is not always stable and I get the following errors:

more ndb_3_error.log
Current byte-offset of file-pointer is: 568

Time: Sunday 20 September 2009 - 18:50:21
Status: Temporary error, restart node
Message: Partitioned cluster detected. Please check if cluster is already running (Arbitration error)
Error: 2307
Error data: We(3) have been declared dead by 4 reason: Our cluster: 0000000000000008(8)
Error object: QMGR (Line: 3354) 0x00000000
Program: /opt/MGC/bin/ndbd
Pid: 2644
Trace: /opt/MGC/var/ndb_3_trace.log.1
Version: mysql-5.1.30 ndb-6.3.20-GA
***EOM***


Pls let me know how to attach the log files in this forum.

//Vijay

Options: ReplyQuote


Subject Views Written By Posted
Regarding cluster config for mysql-5.1.30 ndb-6.3.20 1926 vijay baskar 09/20/2009 07:01PM
Re: Regarding cluster config for mysql-5.1.30 ndb-6.3.20 1174 Matthew Montgomery 09/21/2009 02:52PM


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.