mysql master slave搭建

標籤：

1、

 

2、配置master

修改/etc/my.cnf增加

[mysqld]log-bin = master-binlog-bin-index = master-bin.indexserver-id = 1

　　

3、master建立一個複製使用者

CREATE USER repl_user;GRANT REPLICATION SLAVE ON *.* TO repl_user IDENTIFIED BY ‘123456‘;

　　

重啟master

 

4、配置slave

修改/etc/my.cnf增加

[mysqld]server-id = 2relay-log-index = slave-relay-bin.indexrelay-log slave-relay-bin

　　

重啟slave

5、串連master和slave

CHANGER MASTER TOMASTER_HOST = ‘master-1‘,MASTER_PORT = 3306,MASTER_USER = ‘repl_user‘,MASTER_PASSWORD = ‘123456‘;START SLAVE;

　　

 

mysql master slave搭建