» 2017 » June » 22 の記事

~ mysql Slave Error ~

connie 2017.06.22 | mysql | | No Comments

my.cnf 設定如下,可以避免slave error

binlog_format = mixed

replicate-ignore-table = xxxDB.xxxtable

slave_skip_errors=1062
#1062=duplicate key error

 

| HOME |

Smiley face

June 2017
S M T W T F S
 123
45678910
11121314151617
18192021222324
252627282930