1.先在主庫上創(chuàng)建一個用于復制的用戶
GRANT REPLICATION SLAVE,REPLICATION CLIENT ON *.* TO repl@'192.168.1.%' IDENTIFIED BY 'password';
2.修改主庫上的my.cnf加上
server_id = 6
log_bin = mysql-bin
sync_binlog=1
# innodb數(shù)據(jù)庫推薦加上這兩個配置
innodb_flush_log_at_trx_commit
innodb_support_xa = 1
3.修改備庫上的my.cnf,加上
log_bin = mysql-bin
server_id = 204
relay_log = /var/lib/mysql/mysql-relay-bin
log_slave_updates = 1
read_only = 1
sync_master_info=1
sync_relay_log=1
sync_relay_log_info=1
master-info-repository = TABLE
relay-log-info-repository = TABLE
4 輸入命令開始備份
CHANGE MASTER TO MASTER_HOST = 'server1',
MASTER_USER='repl',
MASTER_PASSWORD='XXXX',
MASTER_LOG_FILE='查看主庫上當前binlog的日志名稱',
MASTER_LOG_POS='查看主庫上當前binlog日志的索引位置';
5 開啟主從
START SLAVE;
6 查看開啟是否成功
show slave status\G;
