sync mysql

mysqldump -u root -p --all-databases > vsei_all.sql

server2 抓檔

sudo rsync -avh -e "ssh -p 87" spencerchang@206.198.231.21:/web/vsei_all.sql /web/

server2 匯入

mysql -u root -p < vsei_all.sql

[Master]

[mysqld]

sudo vim /etc/mysql/mysql.cnf

lower_case_table_names=1

bind-address=0.0.0.0

log-bin=mysql-bin

server-id=100

GRANT REPLICATION SLAVE ON *.* to 'mysql賬號'@'192.168.71.137' identified by '密碼';

sudo service mysql restart

[Slave]

[mysqld]

sudo vim /etc/mysql/mysql.cnf

log_bin=mysql-bin

server_id=110

relay_log=mysql-relay-bin

log_slave_updates=1

read_only=1

sudo service mysql restart

SQL語法

看第一台的資訊 mysql> SHOW SLAVE STATUS \G;

mysql>

CHANGE MASTER TO

MASTER_HOST='206.198.231.21',

MASTER_USER='repl',

MASTER_PASSWORD='',

MASTER_LOG_FILE='mysql-bin.000097',

MASTER_LOG_POS=7459686;

mysql> start SLAVE;