mysql主从同步的注意事项

On 2014年05月26日, in soft, by netoearth

Working on some replication topology automation, here are some rules that will prevent you from replicating from a MySQL server M to a slave S :

  • M does not have binary logs ( log_bin ) enabled
  • M is itself a slave and does not have log_slave_updates enabled
  • M has a higher major version than S (eg M is 5.6 and S is 5.5 , but do note log_bin_use_v1_row_events )
  • Both servers have same server_id
  • S has log_bin & log_slave_updates , uses STATEMENT binlog_format , and M uses ROW or MIXED binlog_format
  • S has log_bin & log_slave_updates , uses MIXED binlog_format , and M uses ROW binlog_format
  • S and M are using different replication filters (some rules could work; good luck if you’re that adventurous)
Tagged with:  

发表评论