1.先在主库上创建一个用于复制的用户

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数据库推荐加上这两个配置
  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;