从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 statusG
出现Slave_IO_Running: Yes
Slave_SQL_Running: Yes
正常