经常用于MySQL Replication相关的命令和选项

1. mysql> CREATE USER 'repl'@'192.168.1.50' IDENTIFIED BY 'repl';
   
2. mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.1.50';
3. CHANGE MASTER TO
     MASTER_HOST='10.0.17.152',
     MASTER_USER='repl',
     MASTER_PASSWORD='repl',
     MASTER_PORT=3306,
     MASTER_LOG_FILE='mysql-bin.000006',
     MASTER_LOG_POS=24218404,
     MASTER_CONNECT_RETRY=10;
4. show master status;
5. show slave status\G;
6. show processlist\G;
   mysql> start slave io_thread;
   mysql> start slave sql_thread;
   
7. mysql> stop slave io_thread;
   mysql> stop slave sql_thread;

8. • Replication slave 1 should use --replicate-wild-do-table=databaseA.%.

   • Replication slave 2 should use --replicate-wild-do-table=databaseB.%.

   • Replication slave 3 should use --replicate-wild-do-table=databaseC.%.(指定数据库的所有数据库的表)

9. reset master

10. mysqlbinlog --start-position=243387732 forummysql01-bin.002937

11. mysqlbinlog ./forummysql01-bin.002937 > /home/jss/bin-002937.log
12. tail -50 /home/jss/bin-002937.log
13. 选项
    

server-id = 323307

log_slave_updates = 1

auto_increment_increment=2

auto_increment_offset=2

read-only（保证只读）
log-bin
MASTER_CONNECT_RETRY=10

replicate-do-db
replicate-do-table
replicate-ignore-db
replicate-ignore-table
replicate-wild-do-table
slave-skip-errors

max_allowed_packet