• 所有节点

tar xf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz 
​
useradd -s /sbin/nologin mysql
​
mkdir /application/mysql -pv
​
mkdir /data/mysql/data -pv
​
echo  "PATH=/application/mysql/bin:$PATH" > /etc/profile.d/mysql.sh
​
source  /etc/profile.d/mysql.sh
​
mv mysql-5.7.26-linux-glibc2.12-x86_64/* /application/mysql/
​
mysqld --initialize-insecure  --user=mysql --basedir=/application/mysql --datadir=/data/mysql/data 
​
vim  /etc/my.cnf 
[mysqld]
user=mysql
basedir=/application/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
server_id=6
port=3306
log_bin=/data/mysql/binlog/mysql-bin
character_set_server=utf8
[mysql]
socket=/tmp/mysql.sock
​
chown -R mysql.mysql /data/
​
service mysqld restart
​
mysql
​
grant replication slave on *.* to repl@'%' identified by '123';

• 互相操作

mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000001 |      437 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
​
help change master to;
​
CHANGE MASTER TO
  MASTER_HOST='10.0.0.11',
  MASTER_USER='repl',
  MASTER_PASSWORD='123',
  MASTER_PORT=3306,
  MASTER_LOG_FILE='mysql-bin.000002',
  MASTER_LOG_POS=154;

完成