Linux下MySQL的主從熱備（自動同步）配置

個人在5.5上配置成功

 

環境說明：Master：192.168.1.200Slave：192.168.1.132

 

MySQL 的 Master 配置：配置my.cnf：

 

# vi /etc/my.cnf

 

[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0server-id=200log-bin=mysql-binrelay-log=relay-binrelay-log-index=relay-bin-index

 

*配置好後，重啟Master 的 MySQL服務！！！

 

service mysqld restart

 

//--------------------------------------------------MySQL 的 Slave 配置：配置my.cnf：

 

# vi /etc/my.cnf

 

[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0server-id=132log-bin=mysql-binreplicate-do-db=testlog-slave-updates=1

 

*配置好後，重啟Slave 的 MySQL服務！！！

 

service mysqld restart

 

//--------------------------------------------------登入Slave，然後執行下面命令：

 

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;

 

查看這兩項是否為YES，yes為正常。Slave_IO_Running: YesSlave_SQL_Running: Yes