replication简单几步完成配置 m-s1.在master上赋权grant replication slave on *.* on ‘sync’@’slaveip’ identied by ‘password’;flush privileges;2.master配置[mysqld]log-binbinlog-format=row –提供性能sync-binlog=1 –官方建议打开server-id=13.制作master完整备份innobackupex –user=dba –password=beifen /var/lib/backup/innobackupex –use-memory=500m –apply-log /var/lib/backup/2015-06-13_10-38-21/4.拷贝全备到slave并恢复备份scp /var/lib/backup/2015-06-13_10-38-21/ slaveip:/var/lib/backup/cd /var/lib/backup/2015-06-13_10-38-21/service mysql stopmv * /var/lib/mysqlchown -R mysql.mysql /var/lib/mysql5.slave配置[mysqld]server-id=26.查看并记录二进制日志中的position idcd /var/lib/mysqlcat xtrabackup_binlog_info7.配置slave replication在slavechange master tomaster_host=’master_ip’,master_user=’dba’,master_password=’beifen’,master_log_file=’host2-bin.0000001′,master_log_pos=120;8.启动replication，，并检查结果在slavestart slaveshow slave status \G;
看着它洗涤一缕缕阳光，看着它映衬一片片星辉，
