經常用于MySQL Replication相關的指令和選項

mysql> CREATE USER 'repl'@'192.168.1.50' IDENTIFIED BY 'repl';

mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.1.50';

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;

show master status;

show slave status\G;

show processlist\G;

mysql> start slave io_thread;

mysql> start slave sql_thread;

mysql> stop slave io_thread;

mysql> stop slave sql_thread;

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.%.(指定資料庫的所有資料庫的表)

reset master

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

mysqlbinlog ./forummysql01-bin.002937 > /home/jss/bin-002937.log

tail -50 /home/jss/bin-002937.log

選項

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