MySQL主从复制

master（主）:

ip:192.168.188.128
my.cnf配置[mysqld]下添加：

server-id=128
log-bin=mysql-bin

创建一个用户repl并授予权限：

CREATE USER 'repl'@'192.168.188.%' IDENTIFIED BY 'mysql';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.188.%';
flush privileges;

重启数据库后，登陆MySQL查看数据库主库的状态：

    SHOW MASTER STATUS;
        +------------------+----------+--------------+------------------+-------------------+
        | File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
        +------------------+----------+--------------+------------------+-------------------+
        | mysql-bin.000025 |      120 |              |                  |                   |
        +------------------+----------+--------------+------------------+-------------------+

savle（从）:

ip:192.168.188.129
my.cnf配置[mysqld]下添加：server_id=129
重启数据库后，登陆MySQL，执行以下操作：
停止slave:stop slave;
重设slave：reset slave;
连接到master:

change master to master_host='192.168.188.128',
master_port=3306,
master_user='repl',
master_password='mysql', 
master_log_file='mysql-bin.000025',
master_log_pos=120;

启动salve：start slave;
查看slave状态：show slave status \G;
看到以下两个yes,说明启动成功：

Slave_IO_Running: Yes
Slave_SQL_Running: Yes