mysql主从配置
从mysql：xxx.xxx.x.101
1． 安装mysql，详见mysql5.5.35安装文档
2． 主mysql配置：
Vim /etc/my.cnf
更改log-bin=mysql-bin #必须开启
server-id = 1 #单独表示，不能和从mysql一样
3． 登陆mysql
添加授权用户：grant replication slave on *.* to 'slave'@'xxx.xxx.x.101' identified by 'rootpwd';
4． 查看主mysql状态
Show master status；
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000021 | 186 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
5． 从mysql配置
Vim /etc/my.cnf
log-bin=mysql-bin #必须开启
server-id= 2 #id不能和主mysql相同
6． 登陆mysql
mysql>change master to master_host='xxx.xxx.x.100',master_user='slave',master_password='rootpwd', master_log_file='mysql-bin.000020',master_log_pos=263;
查看从mysql状态：
mysql> show slave status\G
出现Slave_IO_Running: Yes
Slave_SQL_Running: Yes
正常
