Changkun's Blog

Science and art, life in between.


  • Home

  • Ideas

  • Archives

  • Tags

  • Bio

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]

Changkun Ou

Changkun Ou

Stop Talking. Just Coding.

276 Blogs
165 Tags
Homepage GitHub Email YouTube Twitter Zhihu
Friends
    Frimin ZZZero march1993 qcrao maiyang Xargin Muniao
© 2008 - 2024 Changkun Ou. All rights reserved. | PV/UV: /
0%