创建简单主从服务器

1.创建replication账号(Master 和 Slave)

GRANT REPLICATION SLAVE,REPLICATION CLIENT ON *.* TO repl@'192.168.200.%' IDENTIFIED BY 'bravezhang';

2.修改my.cnf

主服务器: Server ID为110
从服务器: Server ID为111

3.主服务器查看状态

SHOW MASTER STATUS;

+---------------+----------+--------------+------------------+

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| binlog.000006 | 107 | | |
+---------------+----------+--------------+------------------+
1 row in set (0.00 sec)
确定二进制文件和起始位置

4.在从服务器上指向主服务器

CHANGE MASTER TO MASTER_HOST='192.168.200.110', MASTER_USER='repl', MASTER_PASSWORD='yourpassword', 

MASTER_LOG_FILE='mysql-bin.000006', MASTER_LOG_POS=107;

5.开始复制

SHOW SLAVE STATUS \G;
START SLAVE;
SHOW SLAVE STATUS \G;

6.查看状态

SHOW PROCESSLIST \G;