MySQL主从复制

MySQL主从复制原理

        MySQL的复制类型

                基于语句的复制

                基于行的复制

                混合类型的复制

MySQL主从复制的工作过程

打开三台虚拟机centos7两核四G

先改名字第一台主机master第二台slave1第三台slave2

然后部署MySQL服务

修改密码

退出

vi /etc/my.cnf   内容在下面
systemctl restart mysqld
ls /usr/local/mysql/data/
source /etc/profile
mysql -uroot -p123                //登录到master节点数据库进行下面操作
grant replication slave on *.* to 'myslave'@'192.168.93.%' identified by '123456';
flush privileges;
show master status;

第二台机器
[root@slave1 ~]# vi /etc/my.cnf
[client]
socket=/usr/local/mysql/data/mysql.sock
[mysqld]
log-bin=master-bin
binlog-format = MIXED
server-id = 2
socket=/usr/local/mysql/data/mysql.sock
bind-address = 0.0.0.0
skip-name-resolve
port = 3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
max_connections=2048
character-set-server=utf8
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=16M
[root@slave1 ~]# source /etc/profile
[root@slave1 ~]# systemctl restart mysqld
[root@slave1 ~]#  ls /usr/local/mysql/data/
mysql -uroot -p
change master to master_host='192.168.93.133',
master_user='myslave',
master_password='123456',
master_log_file='master-bin.000001',
master_log_pos=603;
start slave;
show slave status\G;
如果报错
 stop slave ;
 reset slave;

第三台机器和第二台机器操作一样