MySQL Forums
Forum List  »  NDB clusters

Data Node sync Problem.
Posted by: Bhairav Dhanwade
Date: October 09, 2014 02:52AM

Hello,

We have 6 individual cantos 64 BIT virtual machines on XEN Server.

We are able to create table. But, when we are trying to insert data in this table we showing only process is running long time. And after long time we are not getting any response from server.

Also we have tested same scenario with single data node it is working fine.

Data Node RAM : 19GB Both.

CREATE TABLE `TB_Name` (
`T1` BIGINT(20) NOT NULL,
`T2` BIGINT(20) NOT NULL,
`T3` INT(11) NOT NULL,
`T4` SMALLINT(6) DEFAULT NULL,
`T5` SMALLINT(6) DEFAULT NULL,
PRIMARY KEY (`T1`),
UNIQUE KEY `UK_CoEE` (`T2`,`T3`)
) ENGINE=NDBCLUSTER DEFAULT CHARSET=latin1;

INSERT INTO `TB_Name`(`T1`,`T2`,`T3`,`T4`,`T5`) VALUES (325302462008513,2460,244,1,7) ,(88727112009284,1,245,1,25);

+----+-------------+--------------------+---------+---------+------+-----------------------------------+-----------------------------------------------------------------------------------------------
| Id | User | Host | db | Command | Time | State | Info
+----+-------------+--------------------+---------+---------+------+-----------------------------------+-----------------------------------------------------------------------------------------------
| 4 | root | localhost | DB_Name | Query | 1519 | query end | INSERT INTO `CoExtElement` VALUES (325302462008513,2460,244,1,7),(88727112009284,1,245,1,25)
+----+-------------+--------------------+---------+---------+------+-----------------------------------+-----------------------------------------------------------------------------------------------


Configuration Part :

------------------------------------------------------------------------
[NDBD DEFAULT]
MaxBufferedEpochs=5000
BackupMaxWriteSize=54M
BackupDataBufferSize=100M
BackupLogBufferSize=50M
BackupMemory=55M
BackupReportFrequency=10
MemReportFrequency=30
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15
DataMemory=14032M
IndexMemory=1024M
MaxNoOfTables=4596
MaxNoOfSubscribers=10000
MaxNoOfTriggers=3500
NoOfReplicas=2
StringMemory=25
DiskPageBufferMemory=1048M
SharedGlobalMemory=512M
LongMessageBuffer=32M
MaxNoOfConcurrentTransactions=195000
BatchSizePerLocalScan=512
FragmentLogFileSize=256M
NoOfFragmentLogFiles=16
RedoBuffer=128M
MaxNoOfExecutionThreads=2
StopOnError=false
LockPagesInMainMemory=1
TimeBetweenEpochsTimeout=32000
TimeBetweenWatchdogCheckInitial=60000
TransactionDeadlockDetectionTimeout=8640000
TransactionInactiveTimeout=60000
HeartbeatIntervalDbDb=15000
HeartbeatIntervalDbApi=15000
MaxNoOfConcurrentOperations=510000
MaxNoOfLocalOperations=561000
MaxNoOfAttributes=314572
MaxNoOfOrderedIndexes=8000
RealtimeScheduler=1
Datadir=/home/mysql/data/

[MYSQLD DEFAULT]

[TCP DEFAULT]
SendBufferMemory=64M
ReceiveBufferMemory=24M

[NDB_MGMD DEFAULT]
Portnumber=1186

[NDB_MGMD]
NodeId=1
Hostname=192.168.0.53
LogDestination=FILE:filename=ndb_1_cluster.log,maxsize=10000000,maxfiles=6
DataDir=/var/lib/mysql-cluster/


[NDB_MGMD]
NodeId=2
Hostname=192.168.0.55
LogDestination=FILE:filename=ndb_2_cluster.log,maxsize=10000000,maxfiles=6
DataDir=/var/lib/mysql-cluster/

[NDBD]
NodeId=3
Hostname=192.168.0.57
datadir=/home/mysql/data/

[NDBD]
NodeId=4
Hostname=192.168.0.65
datadir=/home/mysql/data/

[MYSQLD]
NodeId=5
hostname=192.168.0.51

[MYSQLD]
NodeId=6
hostname=192.168.0.56

------------------------------------------------------------------------
[root@mgm ~]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=3 @192.168.0.57 (mysql-5.6.19 ndb-7.3.6, Nodegroup: 0, *)
id=4 @192.168.0.65 (mysql-5.6.19 ndb-7.3.6, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.53 (mysql-5.6.19 ndb-7.3.6)
id=2 @192.168.0.55 (mysql-5.6.19 ndb-7.3.6)

[mysqld(API)] 2 node(s)
id=5 @192.168.0.51 (mysql-5.6.19 ndb-7.3.6)
id=6 @192.168.0.56 (mysql-5.6.19 ndb-7.3.6)
------------------------------------------------------------------------

[root@mysqld ~]# cat /etc/my.cnf
[client]
socket=/home/mysql-Cluster/mysql.sock
[mysqld]
max_connections=100
datadir=/home/mysql-Cluster
socket=/home/mysql-Cluster/mysql.sock
ndbcluster
ndb-connectstring=192.168.0.53, 192.168.0.55
ndb-force-send=1
ndb-use-exact-count=0
ndb-extra-logging=1
ndb-batch-size=24M
ndb-autoincrement-prefetch-sz=1024
default-storage-engine=NDB
max_allowed_packet = 5G
skip-name-resolve

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql_cluster]
ndb-connectstring=192.168.0.53, 192.168.0.55
[root@mysqld ~]#

Thanks,
Bhairav

Options: ReplyQuote


Subject
Views
Written By
Posted
Data Node sync Problem.
1560
October 09, 2014 02:52AM
697
October 13, 2014 03:32AM


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.