两台虚拟机实现Mysql主从复制

1、开启时间同步

关闭防火墙

#两台都要

systemctl stop firewalld

setenforce 0

getenforce

 

修改hosts文件

#两台都要修改

vi /etc/hosts

192.168.233.140 master

192.168.233.141 slave

 

主master

yum install ntp -y

编辑配置文件 

vim /etc/ntp.conf

#注释掉server0、server1、server2、server3

#添加以下两行

server 127.127.1.0

fudge 127.127.1.0 stratum 10

启动

systemctl enable ntpd

systemctl start ntpd

 

从slave

yum install ntpdate -y

ntpdate master

systemctl enable ntpdate

2、使用源码安装MySQL

把源码放入到/usr/local/src里面（源码下载地址：链接: https://pan.baidu.com/s/1irNcXonxwCitEiOGn3G4tw 提取码: 82ff ）

tar zxvf mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz

mv mysql-5.6.43-linux-glibc2.12-x86_64 /usr/local/mysql

useradd -s /sbin/nologin mysql

cd /usr/local/mysql/

mkdir -p /data/mysql

chown -R mysql:mysql /data/mysql/

yum install -y perl perl-devel

yum install -y perl-Data-Dumper

./scripts/mysql_install_db --datadir=/data/mysql/ --user=mysql

cp support-files/my-default.cnf /etc/my.cnf

cp support-files/mysql.server /etc/init.d/mysqld

chmod 755 /etc/init.d/mysqld

编辑配置文件

vim /etc/init.d/mysqld

查找 datadir 修改为 datadir=/data/mysql

把启动脚本加入系统服务项，设定开机启动

chkconfig --add mysqld

chkconfig mysqld on

 启动MySQL

service mysqld start

 

做个链接可以用mysql -uroot -p

ln -s /usr/local/mysql/bin/mysql /usr/bin

 

设置环境变量

PATH=$PATH:/usr/local/mysql/bin/

echo "PATH=$PATH:/usr/local/mysql/bin/" >> /etc/profile

生效

source /etc/profile

 

创建root用户密码

mysqladmin -u root password '000000';

 

3、进行配置

主master

vi /etc/my.cnf

#添加以下内容

server-id = 11

log-bin = master-bin

log-slave-updates = true

 

重启MySQL

systemctl restart mysqld

 

登录数据库

mysql -uroot -p000000

grant replication slave on *.* to 'slave'@'192.168.233.%' identified by '000000';

flush privileges;

show master status;

 

 

从slave

vi /etc/my.cnf

 

#添加以下内容

server-id = 22

relay-log = relay-log-bin

relay-log-index = slave-relay-bin.index

重新启动MySQL

systemctl restart mysqld

 

---

由于用的是MySQL5.6.43，需要解决一些问题

mysql -uroot -p000000

use mysql;

drop table slave_master_info;

drop table slave_relay_log_info;

drop table slave_worker_info;

drop table innodb_index_stats;

drop table innodb_table_stats;

source /usr/local/mysql/share/mysql_system_tables.sql

重新启动MySQL

systemctl restart mysqld

 

---

进入数据库

mysql -uroot -p000000
change master to master_host='192.168.233.140',master_user='slave',master_password='000000',master_log_file='master-bin.000001',master_log_pos=338;

start slave;

show slave status\G

 

​

 

如果出现NO 解决方法 原文链接：https://www.linuxidc.com/Linux/2014-02/96945.htm

 

4、验证

​