MySQL-5.7-主从同步配置

yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
yum list installed | grep mysql
yum repolist all | grep -E "mysql[0-9]+-community/x86"
yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum install -y mysql-community-server
systemctl start mysqld
systemctl status mysqld.service
grep 'temporary password' /var/log/mysqld.log

vim /etc/my.cnf

[mysqld]

log-bin=master-bin
binlog-format=ROW
server-id=1

vim /etc/my.cnf

[mysqld]

log-bin=master-bin
binlog-format=ROW
server-id=2
read-only = 1

mysql -uroot -p
alter user 'root'@'localhost' identified by 'anyWhere@2024'
flush privileges;

create user 'tongbu'@'172.31.%' identified by 'anyWhere@2024';
grant replication slave on *.* to 'tongbu'@'172.31.%';

mysqldump -uroot -p --all-databases --master-data > db_backup.sql

mysql -uroot -p < db_backup.sql

change master to master_host='172.31.12.203',master_user='tongbu',master_password='anyWhere@2024',master_log_file='master-bin.000001', master_log_pos=613;

# 在主库SHOW MASTER STATUS获取的File值
# 在主库SHOW MASTER STATUS获取的Position值

START SLAVE;

SET GLOBAL rpl_semi_sync_master_enabled = 1;

SET GLOBAL rpl_semi_sync_slave_enabled = 1;

SHOW SLAVE STATUS\G;