title: 配置MySQL主从热备实现读写分离 id: 905 tags:
- Code
环境说明: Master(Ubuntu 14.04) MySQL:5.5.40-0ubuntu0.14.04.1 Slave(Mac OS X 10.10) MySQL:5.6.20 MySQL Community Server (GPL)
先配置Master: [code lang=“bash”] vi /etc/mysql/my.cnf [/code] 配置内容如下: [code lang=“bash”] [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql
Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0 server-id=200 log-bin=mysql-bin relay-log=relay-bin relay-log-index=relay-bin-index [/code] 保存配置后,重启MySQL服务。 [code lang=“bash”] service mysqld restart [/code]
接下来配置Slave: [code lang=“bash”] vi /usr/local/mysql/my.cnf [/code]
[code lang=“bash”] [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql
Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0 server-id=132 log-bin=mysql-bin replicate-do-db=test log-slave-updates=1 [/code] 保存配置后,重启MySQL服务。 [code lang=“bash”] service mysqld restart [/code]
登录Slave,然后执行下面命令: [code lang=“mysql”] mysql> stop slave; mysql> change master to master_host=‘192.168.1.200’,master_user=‘root’,master_password=‘123456’; mysql> start slave; mysql> show slave status\G; [/code]
查看这两项是否为YES,yes为正常。 [code lang=“bash”] Slave_IO_Running: Yes Slave_SQL_Running: Yes [/code]