bitscn.com
    ost -uroot
mysql>show slave statusg
*************************** 1. row ***************************
slave_io_state: waiting for master to send event
master_host: rep1
master_user: rep
master_port: 3306
connect_retry: 60
master_log_file: binlog.000001
read_master_log_pos: 98
relay_log_file: relay.000003
relay_log_pos: 232
relay_master_log_file: binlog.000001
slave_io_running: yes
slave_sql_running: yes
replicate_do_db:
replicate_ignore_db:
replicate_do_table:
replicate_ignore_table:
replicate_wild_do_table:
replicate_wild_ignore_table:
last_errno: 0
last_error:
skip_counter: 0
exec_master_log_pos: 98
relay_log_space: 232
until_condition: none
until_log_file:
until_log_pos: 0
master_ssl_allowed: no
master_ssl_ca_file:
master_ssl_ca_path:
master_ssl_cert:
master_ssl_cipher:
master_ssl_key:
seconds_behind_master: 0
1 row in set (0.00 sec)
可以看到，slave_io_running 和 slave_sql_running 两列的值都为 yes，这表明 slave 的 i/o 和 sql 线程都在正常运行。
至此，同步设定成功。
bitscn.com