MySQLマスターバックアップ

server-id = 1

log-bin=mysql-bin

#         ，         ，          
binlog-do-db=test 

#          ，         ，          
binlog-ignore-db=mysql

grant replication slave on *.* to [email protected] identified by 'password';

mysql> SHOW MASTER STATUS;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_do_db | Binlog_ignore_db |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 | 106      |  test        |  mysql           |
+------------------+----------+--------------+------------------+

mysqldump -u root -p test > test.sql

mysql>source test.sql

#       ， required unique id between 2 and 2^32 - 1
server-id=2 

log-bin=mysql-bin

replicate-do-db=test  #         

replicate-ignore-db=mysql #      

#        ，       
slave_skip_errors=1032,1064

#              ，        ( )
master-connect-retry=60 

#MySQL5.5         

master-host=192.168.0.1

master-user=slave

master-password=password

master-port=3306

slave stop;

CHANGE MASTER TO MASTER_HOST='192.168.0.1',MASTER_USER='slave',MASTER_PASSWORD='password',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=106;

slave start;

SHOW SLAVE STATUS\G;

mysql>show processlist;

 slave     | 192.168.0.2:52493 | NULL  | Binlog Dump |    0 | Master has sent all binlog to slave; waiting for binlog to be updated