环境:centos7.5 关闭selinux/firewalld
主库A:mysql-a.example.com 10.3.8.247
主库B:mysql-a.example.com 10.3.8.248
两台主机都要在/etc/hosts文件中添加:
10.3.8.247 mysql-a mysql-a.example.com
10.3.8.248 mysql-b mysql-b.example.com
禁用防火墙/selinux:
systemctl diable firewalld
sed -i ‘/^SELINUX=/s/enforcing/disabled/’ /etc/sysconfig/selinux
reboot
配置时间同步:
[root@mysql-a ~]# sed -i “s/centos/cn/” /etc/chrony.conf
[root@mysql-a ~]# systemctl restart chronyd
[root@mysql-b ~]# sed -i ‘1i\server mysql-a iburst prefer’ /etc/chrony.conf
[root@mysql-b ~]# systemctl restart chronyd
安装MySQL5.7:
wget http://mirrors.aliyun.com/repo/Centos-7.repo -P /etc/yum.repos.d/
rpm -Uvh https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/e/epel-release-7-11.noarch.rpm
wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar
tar xf mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar
rpm -e mariadb-libs.x86_64 --nodeps
yum localinstall mysql-community-common-5.7.24-1.el7.x86_64.rpm -y
yum localinstall mysql-community-libs-5.7.24-1.el7.x86_64.rpm -y
yum localinstall mysql-community-libs-compat-5.7.24-1.el7.x86_64.rpm -y
yum localinstall mysql-community-client-5.7.24-1.el7.x86_64.rpm -y
yum localinstall mysql-community-server-5.7.24-1.el7.x86_64.rpm -y
systemctl enable mysqld
systemctl start mysqld
grep “password” /var/log/mysqld.log
mysqladmin -u用户名 -p’旧密码’ password 新密码
注意mysqld.log中的密码包含各种字符,需要用单引号括起来防止特殊字符解析成其它意义。
如果要将数据存放于指定目录,可如下设置:
mysqld --initialize --user=mysql --datadir=/data/mysql #新版的初始化方式
chown -R mysql:mysql /data/mysql