mysql 主从的创建

innobackupex-1.5.1 --ibbackup=xtrabackup  --defaults-file=/home/mysql/mysql/my.cnf --no-timestamp  --user=root --password=oracle  /tmp/mysql

innobackupex-1.5.1 --apply-log --defaults-file=/home/mysql/mysql/my3310.cnf  /tmp/mysql --copy-back 


/usr/local/mysql-5.6/bin/mysqld_safe --defaults-file=/home/mysql/mysql/my3310.cnf &


mysqladmin --defaults-file=/home/mysql/mysql/my3310.cnf password


GRANT REPLICATION SLAVE ON *.* TO '68.0.99' IDENTIFIED BY


GRANT REPLICATION SLAVE ON *.* TO 'kiwi'@'%' IDENTIFIED BY 'oracle';



change master to master_host='10.37.129.3';
change master to master_port=3306;
change master to  master_user='kiwi';
change master to  master_password='oracle';
change master to  master_log_file='mysql-bin.000004';
change master to  master_log_pos=120;


show slave status \G;


change master to master_host='10.37.129.3';
change master to master_port=3310;
change master to  master_user='kiwi';
change master to  master_password='oracle';
change master to  master_log_file='mysql-bin.000002';
change master to  master_log_pos=310;