Data Node sync Problem.
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