MySQL Cluster7.1.18インストール

グループとユーザ追加（事前に追加していれば必要なし）

# groupadd mysql
# useradd -s /sbin/nologin -g mysql mysql　←ログイン不可ユーザの追加

インストール

$ ./configure --prefix=/usr/local/mysql-cluster-gpl-7.1.18
--with-charset=utf8
--with-extra-charsets=all
--sysconfdir=/usr/local/mysql-cluster/etc
--with-unix-socket-path=/usr/local/mysql-cluster/tmp/mysql.sock
--with-tcp-port=3308
--enable-thread-safe-client
--with-plugins=partition,innobase,ndbcluster
--localstatedir=/var/lib/mysql-cluster
$ make
# make install

シンボリックリンク作成

$ cd /usr/local
# ln -s mysql-cluster-gpl-7.1.18 mysql-cluster

初期設定

# mkdir /usr/local/mysql-cluster/etc
# cp ./support-files/my-huge.cnf /usr/local/mysql-cluster/etc/my.cnf
# vi /usr/local/mysql-cluster/etc/my.cnf
[mysqld]
 ndbcluster
> ndb-connectstring = 127.0.0.1
# /usr/local/mysql-cluster/bin/mysql_install_db --user=mysql
$ cd /var/lib
# ln -s mysql-cluster-gpl-7.1.18 mysql-cluster
$ cd /usr/local/src/mysql-cluster-gpl-7.1.18
# cp ./support-files/ndb-config-2-node.ini /var/lib/mysql-cluster/config.ini
# vi /var/lib/mysql-cluster/config.ini
[ndbd default]
 NoOfReplicas= 1
[ndb_mgmd]
 NodeId=1
 HostName= 127.0.0.1
[ndbd]
 NodeId= 2
 HostName= 127.0.0.1
これ以外の[ndbd]セクションは削除。
[mysqld]
 NodeId= 3
> HostName= 127.0.0.1
これ以外の[mysqld]セクションは削除。
 #PortNumber= 63132

起動スクリプト設定

# cp ./support-files/mysql.server /etc/init.d/mysql-cluster
起動スクリプト内のmysql-cluster-gpl-7.1.18をmysql-clusterに置換
# sed -i 's/mysql-cluster-gpl-7.1.18/mysql-cluster/g' /etc/init.d/mysql-cluster
編集
# vi /etc/init.d/mysql-cluster
 # chkconfig: 2345 65 35
 # Provides: mysql-cluster
# chmod +x /etc/init.d/mysql-cluster
# /sbin/chkconfig mysql-cluster on

ndb_mgmd、ndbmtdの初回起動

# /usr/local/mysql-cluster/libexec/ndb_mgmd --daemon --config-file /var/lib/mysql-cluster/config.ini
# /usr/local/mysql-cluster/libexec/ndbmtd --initial ←initialは初回のみ

一旦停止

# /usr/local/mysql-cluster/bin/ndb_mgm
ndb_mgm> shutdown
ndb_mgm> exit
# pkill ndb_mgmd

ndb_mgmd用起動スクリプトの作成

# vi /etc/init.d/ndb_mgmd

/etc/init.d/ndb_mgmd

#!/bin/bash
#
# Version: 0.1
#
# chkconfig: 2345 63 37
# description: Runs the ndb_mgmd
# processname: /usr/local/mysql-cluster/libexec/ndb_mgmd
# config: /var/lib/mysql-cluster/config.ini
# We require the /etc/delegeted.conf file, but supply it in the package, so it
# should always be there.
progname=ndb_mgmd
lockfile=/var/lock/subsys/ndb_mgmd
prog=/usr/local/mysql-cluster/libexec/ndb_mgmd
conffile=/var/lib/mysql-cluster/config.ini
[ -f $conffile ] || exit $?
# Source function library.
. /etc/init.d/functions
RETVAL=0
start() {
        echo -n $"Starting $progname: "
        daemon $prog --config-file $conffile
        RETVAL=$?
        echo
        [ $RETVAL = 0 ] && touch $lockfile
        return $RETVAL
}
stop() {
        echo -n $"Stopping $progname: "
        killproc $prog
        RETVAL=$?
        echo
        [ $RETVAL = 0 ] && rm -f $lockfile
        return $RETVAL
}
# See how we were called.
case "$1" in
  start)
        start
        ;;
  stop)
        stop
        ;;
  status)
        status $prog
        RETVAL=$?
        ;;
  restart)
        stop
        start
        ;;
  condrestart)
        if [ -f $lockfile ]; then
            stop
            start
        fi
        ;;
  reload)
        action $"Reloading $progname:" killall -HUP $prog
        ;;
  *)
        echo $"Usage: $0 {start|stop|restart|reload|condrestart|status}"
        exit 1
esac
exit $RETVAL

ndbmtd用起動スクリプトの作成

# vi /etc/init.d/ndbmtd

/etc/init.d/ndbmtd

#!/bin/bash
#
# Version: 0.1
#
# chkconfig: 2345 64 36
# description: Runs the ndbmtd
# processname: /usr/local/mysql-cluster/libexec/ndbmtd
# config:
# We require the /etc/delegeted.conf file, but supply it in the package, so it
# should always be there.
progname=ndbmtd
lockfile=/var/lock/subsys/ndbmtd
prog=/usr/local/mysql-cluster/libexec/ndbmtd
conffile=
[ -f $conffile ] || exit $?
# Source function library.
. /etc/init.d/functions
RETVAL=0
start() {
        echo -n $"Starting $progname: "
        daemon $prog
        RETVAL=$?
        echo
        [ $RETVAL = 0 ] && touch $lockfile
        return $RETVAL
}
stop() {
        echo -n $"Stopping $progname: "
        killproc $prog
        RETVAL=$?
        echo
        [ $RETVAL = 0 ] && rm -f $lockfile
        return $RETVAL
}
# See how we were called.
case "$1" in
  start)
        start
        ;;
  stop)
        stop
        ;;
  status)
        status $prog
        RETVAL=$?
        ;;
  restart)
        stop
        start
        ;;
  condrestart)
        if [ -f $lockfile ]; then
            stop
            start
        fi
        ;;
  reload)
        action $"Reloading $progname:" killall -HUP $prog
        ;;
  *)
        echo $"Usage: $0 {start|stop|restart|reload|condrestart|status}"
        exit 1
esac
exit $RETVAL

起動

# chmod +x /etc/init.d/ndb_mgmd
# chmod +x /etc/init.d/ndbmtd
# /sbin/chkconfig ndb_mgmd on
# /sbin/chkconfig ndbmtd on
# /sbin/service ndb_mgmd start
# /sbin/service ndbmtd start
# /sbin/service mysql-cluster start

アカウント作成

mysql> GRANT ALL ON *.* TO tappe@localhost IDENTIFIED BY 'パスワード' WITH GRANT OPTION;
mysql> GRANT ALL ON *.* TO tappe@'%' IDENTIFIED BY 'パスワード' WITH GRANT OPTION;