dwanue IT Life

apt-get update
apt-get -y install libaio1 libaio-dev perl

groupadd mysql
useradd -g mysql mysql
cd /usr/local/
wget http://dev.mysql.com/get/Downloads/MySQL-Cluster-7.3/mysql-cluster-gpl-7.3.4-linux-glibc2.5-x86_64.tar.gz
tar xvfz mysql-cluster-gpl-7.3.4-linux-glibc2.5-x86_64.tar.gz
ln -s mysql-cluster-gpl-7.3.4-linux-glibc2.5-x86_64 mysql
cd mysql
scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data -u mysql
chown -R root:mysql .
chown -R mysql data
cp support-files/mysql.server /etc/init.d/
chmod 755 /etc/init.d/mysql.server
cd /usr/local/mysql/bin
mv * /usr/bin
cd ../
rm -fr /usr/local/mysql/bin
ln -s /usr/bin /usr/local/mysql/bin
vi /etc/my.cnf
{
[mysqld]
innodb_buffer_pool_size = 64M
ndbcluster
# IP address of the cluster management node
ndb-connectstring=10.1.1.17,10.1.2.17
[mysql_cluster]
# IP address of the cluster management node
ndb-connectstring=10.1.1.17,10.1.2.17
}

mkdir /var/lib/mysql-cluster
cd /var/lib/mysql-cluster
-------------------------------------------------------------------------------
####DATA NODE STEP:

ndbd –-initial

vi /etc/init.d/ndbd.sh

====================================================================
#!/bin/sh
### BEGIN INIT INFO
# Provides: ndbd.sh
# Required-Start: $remote_fs
# Required-Stop: $remote_fs
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: Start daemon at boot time
# Description: Enable service provided by daemon.
### END INIT INFO

ndbd &
====================================================================
chmod 755 /etc/init.d/ndbd.sh

/usr/sbin/update-rc.d -f ndbd.sh defaults

-------------------------------------------------------------------------------
####SQL NODE STEP:

service mysql.server start

/usr/local/mysql/bin/mysql_secure_installation

mysql -u root -p
CREATE USER 'climaxuser'@'%' IDENTIFIED BY '27940001';
grant all on *.* to 'climaxuser'@'%' identified by '27940001';
FLUSH PRIVILEGES;
quit

/usr/sbin/update-rc.d -f mysql.server defaults