主机:centos7.2(五台)
管理节点:management-server 192.168.122.121
存储节点:data-node 192.168.122.122\192.168.122.123
应用节点:mysql-server 192.168.122.124\192.168.122.125
安装包:mysql-cluster-community-7.5.5-1.el7.x86_64.rpm-bundle.tar(其他版本均可在Oracle官网下载)
环境:1.相同网段的IP
2.hosts主机名(我这里设置为man\data1\data2\sql1\sql2\)
3.关闭防火墙
4.时间同步
5.yum install -y createrepo
6.删除旧的数据库: db=`rpm -qa |grep mariadb` ; yum remove ${db} -y && rm -rf /etc/my.cnf*
步骤一:配置yum源
yum install -y vsftpd
tar -xf mysql-cluster-community-7.5.5-1.el7.x86_64.rpm-bundle.tar -C /var/ftp/pub
createrepo /var/ftp/pub
cat > /etc/yum.repos.d/mysqlcluster.repo << EOT
[mysqlcluster]
name=myclu
baseurl=ftp://192.168.122.121/pub
enabled=1
gpgcheck=0
EOT
使用scp或rsync将/etc/yum.repos.d/mysqlcluster.repo同步到其他主机上
yum clean all && yum makecache
步骤二:安装对应的包
管理节点:
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
yum install mysql-cluster-community-management-server mysql-cluster-community-client
存储节点:
yum install -y mysql-cluster-community-data-node
应用节点:
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
yum install -y mysql-cluster-community-server
安装完成
步骤三:配置
管理节点
mkdir /var/lib/mysql-cluster
cat /var/lib/mysql-cluster/config.ini << EOT
[ndbd default]
NoOfReplicas=2
DataDir=/var/lib/mysql-cluster
[ndb_mgmd]
HostName=192.168.122.121
DataDir=/var/lib/mysql-cluster
[ndbd]
HostName=192.168.122.122
[ndbd]
HostName=192.168.122.123
[mysqld]
HostName=192.168.122.124
[mysqld]
HostName=192.168.122.125
EOT
存储节点:
cat > /etc/my.cnf << EOT
[mysqld]
ndbcluster
ndb-connectstring=192.168.122.121
[mysql_cluster]
ndb-connectstring=192.168.122.121
EOT
mkdir /var/lib/mysql-cluster
应用节点:
cat >> /etc/my.cnf <<EOT
ndbcluster
ndb-connectstring=192.168.122.121
default_storage_engine=ndbcluster
[mysql_cluster]
ndb-connectstring=192.168.122.121
EOT
配置完成
步骤四:启动
管理节点:(优先)
ndb_mgmd -f /var/lib/mysql-cluster/config.ini
ss -ntupl |grep ndb
存储节点:
ndbd
应用节点:
systemctl start mysqld
步骤五:登录
grep password /var/log/mysqld.log
#调用日志,查看密码,并使用该密码登录
mysql> set global validate_password_policy=0;
#设置MYSQL的全局模式为0
mysql> set global validate_password_length=6;
#设置MYSQL的密码长度
mysql> set password=password('000000');
#更改密码
步骤六:测试
往其中一台数据库创建表格,查看另外一台数据库是否存在同样表格