mysql 快速设置主从同步

MySQL主从同步用在读写分离或数据备份，快速设置步骤如下：

设置步骤

1.先开启master slave的bin-log 并设置 server-id，然后重启mysql检查是否设置OK。
2.得到master的MASTER_LOG_FILE 和MASTER_LOG_POS，在master上运行以下语句：

mysql> show master status\G
*************************** 1. row ***************************
            File: mysql-bin.000085
        Position: 223251
    Binlog_Do_DB: 
Binlog_Ignore_DB: 
1 row in set (0.00 sec)

3.在master上加入slave用户slave1，并给予slave权限

create user slave1@'%' identified by 'slave1';
grant replication slave on *.* to slave1@'%';
flush privileges;

4.登陆slave，进行配置并且开启：

CHANGE MASTER TO 
MASTER_HOST='192.168.1.223',
MASTER_USER='slave1',
MASTER_PASSWORD='slave1',
MASTER_LOG_FILE='mysql-bin.000085',
MASTER_LOG_POS=223251;

start slave;

5.在master上看是否有主从同步：

mysql> show processlist;
+--------+------------+---------------------+------------------+-------------+------+-----------------------------------------------------------------------+------------------+
| Id     | User       | Host                | db               | Command     | Time | State                                                                 | Info             |
+--------+------------+---------------------+------------------+-------------+------+-----------------------------------------------------------------------+------------------+
| 190305 | root       | localhost           | master1          | Query       |    0 | NULL                                                                  | show processlist |
| 190324 | slave1     | 192.168.1.204:51903 | NULL             | Binlog Dump | 6704 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL             |
| 190765 | root       | 127.0.0.1:55186     | rap_db           | Sleep