CentOS服务器平台搭建mysql主从复制与读写分离的方法

在从服务器查看是否同步过来 如果一致说明成功

mysql> use test; 
Database changed 
mysql> select * from user; 
+----+ 
| id | 
+----+ 
| 1 | 
| 2 | 
| 3 | 
| 4 | 
| 5 | 
| 6 | 
+----+ 
2 rows in set (0.00 sec) 
mysql> select * from user; 
+----+ 
| id | 
+----+ 
| 1 | 
| 2 | 
| 3 | 
| 4 | 
| 5 | 
| 6 | 
+----+ 
6 rows in set (0.00 sec) 
mysql> select * from user; 
+----+ 
| id | 
+----+ 
| 11 | 
| 2 | 
| 3 | 
| 4 | 
| 5 | 
| 6 | 
+----+ 
6 rows in set (0.00 sec) 
mysql> select * from user; 
+----+ 
| id | 
+----+ 
| 11 | 
| 3 | 
| 4 | 
| 5 | 
| 6 | 
+----+ 
5 rows in set (0.00 sec) 
mysql> select * from user; 
+----+------+ 
| id | name | 
+----+------+ 
| 11 | NULL | 
| 3 | NULL | 
| 4 | NULL | 
| 5 | NULL | 
| 6 | NULL | 
+----+------+ 
5 rows in set (0.00 sec) 
mysql> desc user; 
+-------+--------------+------+-----+---------+-------+ 
| Field | Type     | Null | Key | Default | Extra | 
+-------+--------------+------+-----+---------+-------+ 
| id  | int(11)   | NO  |   | NULL  |    | 
| name | varchar(200) | YES |   | NULL  |    | 
+-------+--------------+------+-----+---------+-------+ 
2 rows in set (0.00 sec) 
mysql> show tables; 
+----------------+ 
| Tables_in_test | 
+----------------+ 
| test      | 
| user      | 
| user2     | 
+----------------+ 
3 rows in set (0.00 sec) 
mysql> 
mysql binlog日志查看：  
show binlog eventsG; 
*************************** 12. row *************************** 
  Log_name: mysql-bin.000007 
    Pos: 985 
 Event_type: Query 
 Server_id: 1 
End_log_pos: 1075 
    Info: use `test`; delete from user where id=2 
*************************** 13. row *************************** 
  Log_name: mysql-bin.000007 
    Pos: 1075 
 Event_type: Query 
 Server_id: 1 
End_log_pos: 1175 
    Info: use `test`; alter table user add name varchar(50) 
*************************** 14. row *************************** 
  Log_name: mysql-bin.000007 
    Pos: 1175 
 Event_type: Query 
 Server_id: 1 
End_log_pos: 1287 
    Info: use `test`; ALTER TABLE user MODIFY COLUMN name VARCHAR(200) 
*************************** 15. row *************************** 
  Log_name: mysql-bin.000007 
    Pos: 1287 
 Event_type: Query 
 Server_id: 1 
End_log_pos: 1376 
    Info: use `test`; create table user2(id int) 
15 rows in set (0.00 sec) 

很早的时候搭建的了，走不少弯路，根据当时记录的写了下

希望本文所述对大家CentOS服务器设置有所帮助。