Excellent tool to create configuration files for the cluster
http://www.severalnines.com/config/
Tuesday, May 4, 2010
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)
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...
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
Subscribe to:
Posts (Atom)
