Mysql Cluster 8.0.26搭建
一、基础环境部署
1、基本环境(每个节点都需要)
1.1 关闭防火墙
systemctl stop firewalld # 关闭防火墙
systemctl disable firewalld #设置开机不自启
1.2 关闭selinux
setenforce 0
修改/etc/selinux/config
sed -s 's/enforcing/disabled/g' /etc/selinux/config
1.3 修改hosts文件
172.25.16.* mysql01
172.25.16.* mysql02
172.25.16.* mysql03
1.4 设置免密登录
ssh-keygen -t rsa
ssh-copy-id mysql01
ssh-copy-id mysql02
ssh-copy-id mysql03
1.5 sysctl.conf 优化
cat>>/etc/sysctl.conf <<EOF
fs.aio-max-nr = 1048576
fs.file-max = 681574400
kernel.shmmax = 137438953472
kernel.shmmni = 4096
kernel.sem = 250 32000 100 200
net.ipv4.ip_local_port_range = 9000 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
EOF
1.6 limit 优化
cat>>/etc/security/limits.conf <<EOF
mysql soft nproc 65536
mysql hard nproc 65536
mysql soft nofile 65536
mysql hard nofile 65536
EOF
cat>>/etc/pam.d/login <<EOF
session required /lib/security/pam_limits.so
session required pam_limits.so
EOF
cat>>/etc/profile<<EOF
if [ $USER = "mysql" ]; then
ulimit -u 16384 -n 65536
fi
EOF
source /etc/profile
2、mysql安装
2.1 mysql安装包下载
wget https://cdn.mysql.com//Downloads/MySQL-Cluster-8.0/mysql-cluster-community-8.0.26-1.el7.x86_64.rpm-bundle.tar
解压安装
tar -xvf mysql-cluster-community-8.0.26-1.el7.x86_64.rpm-bundle.tar
rpm -ivh mysql-cluster-community-common-8.0.26-1.el7.x86_64.rpm mysql-cluster-community-l