Posts Tagged ‘MySQL Cluster’

How to check Memory and Index Usage in MySQL CLuster

November 22nd, 2010

How to check Memory and Index Usage in MySQL CLuster,on the management Node connect to ndb_mgm client utility

run /usr/bin/ndb_mgm

output
– NDB Cluster — Management Client –

run show command
ndb_mgm> show

Connected to Management Server at: localhost:1186
Cluster Configuration
———————
[ndbd(NDB)]     2 node(s)
id=2    @xx.xxx.xx.xxx  (mysql-5.1.47 ndb-7.1.8, Nodegroup: 0, Master)
id=3    @yy.yyy.yy.yyy  (mysql-5.1.47 ndb-7.1.8, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @zz.zzz.zz.zzz  (mysql-5.1.47 ndb-7.1.8)

[mysqld(API)]   1 node(s)
id=4    @bb.bb.bb.bb  (mysql-5.1.47 ndb-7.1.8)

now this setup has 2 data nodes to check the Memory and Index Usage for node 2

ndb_mgm> 2 REPORT MemoryUsage;
Node 2: Data usage is 5%(3846 32K pages of total 65536)
Node 2: Index usage is 0%(229 8K pages of total 131104)

this will give you two things how much in percentage used and how much total memory we have allocated
Memory : 32K*65536  (32k data page size and 65536 no of pages
INdex  : 8k*131104  (8K data page size and 131104 no of blocks)

How to disable the iptables firewall in Linux

November 2nd, 2010

while doing the MySQL Cluster Set up I needed to disable the firewall on the linux  so sharing how to do that

To Disable Firewall (Red hat/CentOS/Fedora Core)

/etc/init.d/iptables save
/etc/init.d/iptables stop

To Enable  Firewall (Red hat/CentOS/Fedora Core)

Type the following command to turn on iptables firewall:
/etc/init.d/iptables start