MySQL主从复制搭建之一，从头搭建

向右看齐 2022-07-12 16:19 166阅读 0赞

首先安装mysql  
[http://blog.csdn.net/becivells/article/details/58326691][http_blog.csdn.net_becivells_article_details_58326691]  
也可以使用repo源

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm 
    rpm -ivh mysql-community-release-el7-5.noarch.rpm

注释：（安装这个包后，会获得两个 mySQL 的 yum repo 源： /etc/yum.repos.d/mysql-community.repo， /etc/yum.repos.d/mysql-community-source.repo

yum remove mariadb* -y
    yum install -y mysql-server

主服务器为192.168.205.134  
从服务器为192.168.205.135

1.主服务器配置  
修改配置文件在mysqld下增加

server-id = 1
    log_bin = mysql-bin
    lower_case_table_names=1#非必须

![这里写图片描述][SouthEast]  
建立同步账号  
GRANT REPLICATION SLAVE ON *.* TO ‘mysync’@’192.168.205.135’ IDENTIFIED BY ‘123456’;

重启mysql服务  
systemctl restart mysql

登录mysql  
show master status  
![这里写图片描述][SouthEast 1]

2.从服务器配置  
修改配置文件

relay-log = mysql-relay-bin
    log-slave-updates= 1
    read-only = 1
    server-id = 2
    lower_case_table_names=1#非必须

log-bin并不是从服务器必须的参数  
![这里写图片描述][SouthEast 2]

登录从服务器的mysql

CHANGE MASTER TO MASTER_HOST='192.168.205.134',MASTER_USER='mysync', MASTER_PASSWORD='123456',MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=120;
    flush privileges;
    start slave;
    show slave STATUS \G

如果两个都是yes那么就是成功了

3.注意：log-bin并不是从服务器必须的参数只有在从服务器作为主从集群服务器的主服务器时才必须。如果是虚拟机克隆的。有可能会提示uuid重复只需要删除auto.cnf 这个文件重新启动即可

[http_blog.csdn.net_becivells_article_details_58326691]: http://blog.csdn.net/becivells/article/details/58326691
[SouthEast]: /images/20220709/4872b5fea1194ca8844bf5816c615d80.png
[SouthEast 1]: /images/20220709/0d9f99ce998f4430b278363367b4a6a5.png
[SouthEast 2]: /images/20220709/3265e96e6c6d4998a485c4f1a79b63d0.png