mysqlcluster data nodes synchronization rate
mysql cluster version: MySQL-Cluster-gpl-7.4.12-1.el6.x86_64
num of datanode: 2
num of sql: 2
num of mgmt: 2
Recently one on my datanode server was down(node4) due to power outage. when i brought the disconnected datanode up i realized that the synchronization is very slow when it reached 17%.
[root@mgm1 ~]# ndb_mgm -e "all report memory"
Connected to Management Server at: localhost:1186
Node 3: Data usage is 18%(493874 32K pages of total 2621440)
Node 3: Index usage is 6%(71005 8K pages of total 1048608)
Node 4: Data usage is 17%(458693 32K pages of total 2621440)
Node 4: Index usage is 6%(70800 8K pages of total 1048608)
i checked the latest row on specific table and saw that the result is same which means result is same when accessing through both SQL nodes when table is updated.
Would you kindly enlighten me
Q1: How to know what is causing this slowness. I guess it is due to huge number of table indexes but not sure that index build up is taking this much time.
Q2: will it have negative impact if i do DML(insert/update) on SQL nodes when sync is on progress ?
note: (freeradius is connected to the sql nodes which constantly inserts data)
Subject
Views
Written By
Posted
mysqlcluster data nodes synchronization rate
1324
April 18, 2017 09:13PM
731
April 21, 2017 02:30PM
1514
April 22, 2017 12:40PM
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.