MySQL数据库两台主机同步实战

数实战复制1 default-character-set=utf8 2 3 log-bin=MySQL-bin 4 5 relay-log=relay-bin 6 7 relay-log-index=relay-bin-index 8 9 server-id=1 10 11 master-host=10.240.136.149 12 13 master-user=tongbu 14 15 master-password=123456 16 17 master-port=3306 18 19 master-connect-retry=30 20 21 binlog-do-db=umsdb 22 23 replicate-do-db=umsdb 24 25 replicate-ignore-table=umsdb.boco_tb_menu 26 27 replicate-ignore-table=umsdb.boco_tb_connect_log 28 29 replicate-ignore-table=umsdb.boco_tb_data_stat 30 31 replicate-ignore-table=umsdb.boco_tb_log_record 32 33 replicate-ignore-table=umsdb.boco_tb_workorder_record1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.

本文地址：http://www.bzuk.cn/news/098f8699815.html