mysql学习之-ndbcluster配置.txt
10墨值下载
管理节点
echo "export PATH=$PATH:/usr/local/mysql/bin">> /etc/profile
tar zxvf mysql-cluster-gpl-7.6.18-linux-glibc2.12-x86_64.tar.gz
mv mysql-cluster-gpl-7.6.18-linux-glibc2.12-x86_64 mysql
cp bin/ndb_mgm* /usr/local/bin
chmod +x /usr/local/bin/ndb_mgm*
cd mysql
mkdir data
mkdir -p /var/lib/mysql-cluster
vi /usr/local/mysql/config.ini
[ndbd default]
NoOfReplicas=2
[ndb_mgmd]
NodeId=1
HostName=10.4.7.254
DataDir=/var/lib/mysql-cluster
[ndbd]
NodeId=11
HostName=10.4.7.252
DataDir=/usr/local/mysql/data
[ndbd]
NodeId=12
HostName=10.4.7.253
DataDir=/usr/local/mysql/data
[mysqld]
NodeId=21
HostName=10.4.7.254
[mysqld]
NodeId=22
HostName=10.4.7.100
vi /etc/my.cnf
[mysqld]
character_set_server=utf8
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
ndbcluster
ndb-connectstring=10.4.7.254
[mysql_cluster]
ndb-connectstring=10.4.7.254
启动管理节点
ndb_mgmd --config-file=/usr/local/mysql/config.ini --configdir=/usr/local/mysql
查看状态
ndb_mgm -e show
停止
ndb_mgm -e shutdown
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-
数据节点：
cd /usr/local
tar zxvf mysql-cluster-gpl-7.6.18-linux-glibc2.12-x86_64.tar.gz
mv mysql-cluster-gpl-7.6.18-linux-glibc2.12-x86_64 mysql
cd mysql
mkdir data
vi /etc/my.cnf
[mysqld]
character_set_server=utf8
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
ndbcluster
ndb-connectstring=10.4.7.254
[mysql_cluster]
ndb-connectstring=10.4.7.254
cd /usr/local/mysql/bin
初始化
/usr/local/mysql/bin/mysqld --initialize-insecure
--datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
启动数据节点：
/usr/local/mysql/bin/ndbd --initial（仅第一次启动）
或第二次启动
/usr/local/mysql/bin/ndbd
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-
sql 节点:
cd /usr/local
tar zxvf mysql-cluster-gpl-7.6.18-linux-glibc2.12-x86_64.tar.gz
mv mysql-cluster-gpl-7.6.18-linux-glibc2.12-x86_64 mysql
cd mysql
mkdir data
vi /etc/my.cnf
[mysqld]
character_set_server=utf8
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
ndbcluster
ndb-connectstring=10.4.7.254
[mysql_cluster]
ndb-connectstring=10.4.7.254
cd /usr/local/mysql/bin
初始化
/usr/local/mysql/bin/mysqld --initialize-insecure
--datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
/usr/local/mysql/bin/mysqld --user=root &
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
of 3
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论