MySQL 5.7 主从复制配置

软件准备

• mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz（下载地址）
  

主从节点部署 MySQL

• 解压 MySQL，创建目录

[root@hadoop001 ~]# cd /usr/local
[root@hadoop001 local]# tar -xzvf mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz
[root@hadoop001 local]# mv mysql-5.7.11-linux-glibc2.5-x86_64 mysql
[root@hadoop001 local]# mkdir mysql/arch mysql/tmp

• 创建 mysqladmin 用户及用户组

[root@hadoop001 local]# groupadd -g 101 dba
[root@hadoop001 local]# useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin
useradd: warning: the home directory already exists.
Not copying any file from skel directory into it.
[root@hadoop001 local]# id mysqladmin
uid=514(mysqladmin) gid=101(dba) groups=101(dba),0(root)

# 此时切换到 mysqladmin 用户会发现没有正常显示
# 退出该用户然后拷贝环境变量的配置文件到 mysqladmin 用户的家目录
[root@hadoop001 local]# su - mysqladmin
-bash-4.2$ exit
logout
[root@hadoop001 local]# cp /etc/skel/.* /usr/local/mysql
cp: omitting directory ‘/etc/skel/.’
cp: omitting directory ‘/etc/skel/..’
cp: omitting directory ‘/etc/skel/.mozilla’
[root@hadoop001 local]# su - mysqladmin
Last login: Sat Dec 21 22:02:59 CST 2019 on pts/0
[mysqladmin@hadoop001 ~]$

• 配置 mysqladmin 用户的环境变量

[root@hadoop001 local]# vi mysql/.bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

#env
export MYSQL_HOME=/usr/local/mysql
export PATH=${MYSQL_HOME}/bin:$PATH

• 配置 mysql 配置文件 my.cnf

[root@hadoop001 local]# vi /etc/my.cnf

# 下面的可以直接拷贝使用

[client]
port