Linux上MySQL 5.5設定Master-Slave

[Master]
1.修改設定檔
vim /etc/my.cnf

[mysqld]
server-id=1
log-bin=mysql-bin
#binlog-do-db=DB名稱 //指定DB複製

2.重啟server
service mysql restart

3.匯出資料庫
mysqldump -u 帳號 -p --master-data --all-databases > 名稱.sql

4.給予Slave權限
mysql> CREATE USER '帳號'@'Slave ip' IDENTIFIED BY '密碼';
mysql> GRANT REPLICATION SLAVE ON *.* TO '帳號'@'Slave ip';
mysql> FLUSH PRIVILEGES;



[Slave]
1.匯入資料庫
mysql -u 帳號 -p --default-character-set=utf8 < 名稱.sql

2.修改設定檔
vim /etc/my.cnf

[mysqld]
server-id=2

3.重啟server
service mysql restart

4.設定Master
mysql> CHANGE MASTER TO MASTER_HOST='Master ip', MASTER_PORT=3306, MASTER_USER='帳號', MASTER_PASSWORD='密碼';

5.啟動Slave
mysql> START SLAVE;

6.查看Slave狀態
mysql> SHOW SLAVE STATUS \G;