当前系统环境:CentOS release 6.3 (Final)
1、确认libtool是否已经安装,如果没有安装的话,则先安装libtool
# yum -y install libtool
2、分别执行以下三条命令:
# autoreconf --force --install
# libtoolize --automake --force
# automake --force --add-missing
再重新编译安装,问题解决!
# groupadd mysql
# useradd -g mysql -d /home/mysqlc/var -M mysql
#./configure --prefix=/home/mysqlc/ --with-charset=utf8 --with-collation=utf8_general_ci \
--with-client-ldflags=-all-static -with-mysqld-ldflags=-all-static --enable-assembler \
--with-extra-charsets=complex --enable-thread-safe-client --with-big-tables \
--with-readline --with-ssl --with-embedded-server --enable-local-infile \
--with-unix-socket-path=/home/mysqlc/tmp/mysql.sock \
--sysconfdir=/home/mysqlc/etc --without-debug --with-mysqld-user=mysqlc --with-plugins=max
error: No curses/termcap library found
解决办法:
下载安装相应软件包
一、如果你的系统是RedHat系列:
yum list|grep ncurses
yum -y install ncurses-devel
yum install ncurses-devel
二、如果你的系统是Ubuntu或Debian:
apt-cache search ncurses
apt-get install libncurses5-dev
g++: command not found
yum -y install gcc+ gcc-c++
./configure --prefix=/home/mysql/ --with-charset=utf8 --with-collation=utf8_general_ci \
--with-client-ldflags=-all-static -with-mysqld-ldflags=-all-static --enable-assembler \
--with-extra-charsets=complex --enable-thread-safe-client --with-big-tables \
--with-readline --with-ssl --with-embedded-server --enable-local-infile \
--with-unix-socket-path=/home/mysql/tmp/mysql.sock \
--sysconfdir=/home/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugins=max
要想关闭簇,可在MGM节点所在的机器上,输入下述命令:
ndb_mgm -e shutdown
该命令将恰当地中止ndb_mgm、ndb_mgmd以及任何ndbd进程。注意,这里的“-e”选项用于将命令从shell传递到ndb_mgm客户端。
使用mysqladmin shutdown,可中止SQL节点。
要想重启簇,可简单地运行下述命令:
· 在管理主机上: ndb_mgmd -f /var/lib/mysql-cluster/config.ini
· 在每台数据节点主机上:ndbd
请记住,正常重启NDBD节点时,不要用“--initial”选项调用该命令。
· 在SQL主机上:mysqld &
./configure --prefix=/home/mysql/ --with-charset=utf8 --with-collation=utf8_general_ci \
--with-client-ldflags=-all-static -with-mysqld-ldflags=-all-static --enable-assembler \
--with-extra-charsets=complex --enable-thread-safe-client --with-big-tables \
--with-readline --with-ssl --with-embedded-server --enable-local-infile \
--with-unix-socket-path=/home/mysql/tmp/mysql.sock \
--sysconfdir=/home/mysql/etc --without-debug --with-mysqld-user=mysql --with-plugins=max
rpm -qa|grep mysql
从上而下
rpm -e xxx (--nodeps 强力卸载)
///创建sql节点
[MYSQLD]
character_set_server=utf8
ndbcluster #运行NDB存储引擎
ndb-connectstring=192.168.1.102 #mysql数据库所在地址
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
port=3306
lower_case_table_names=1 #表名是否区分大小写 1为不区分,不然linux下表名是区
[MYSQL_CLUSTER]
ndb-connectstring=192.168.1.130 #mysql cluster 管理节点IP
# chown root:mysql . -R
# ./bin/mysql_install_db --user=mysql
# vi ./etc/my.cnf
[mysqld]
basedir = /usr/local/mysql/
datadir = /usr/local/mysql/var
user = mysql
port = 3306
socket = /usr/local/mysql/tmp/mysql.sock
ndbcluster
ndb-connectstring=192.168.50.10
[mysql_cluster]
ndb-connectstring=192.168.50.10
启动 mysql 服务
# ./bin/mysqld_safe --user=mysql &
、、、、、、、、、、、、、
1.启动管理节点 ndb_mgmd -f cluster/config.ini(initial修改配置或者第一次启动)
进入管理节点命令bin/ndb_mgm
show