Tuesday, May 4, 2010

Create configuration file

Excellent tool to create configuration files for the cluster
http://www.severalnines.com/config/ 

REDO log error

The cluster ran fine today and handled the load fairly well. however towards the market close, i got the following error...
Error in ndbapi.cpp, line: 103, code: 410, msg: REDO log files overloaded, consult online manual (decrease TimeBetweenLocalCheckpoints, and|or increase NoOfFragmentLogFiles).

Going to investigate.
(http://johanandersson.blogspot.com/2007/05/good-configuration.html)

Monday, May 3, 2010

Fresh install

1) After unpacking, follow these steps...

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
shell> bin/mysqld_safe --user=mysql &

2) cp bin/ndb_mgm* /usr/local/bin (Copy the ndb related binaries)


3) create config file...

mkdir /var/lib/mysql-cluster
cd /var/lib/mysql-cluster
nano config.ini