學習筆記:MySQL Cluster 的binlog

denniswwh發表於2009-08-26

MySQL Cluster中,如果啟用了binlog,在任何sql node的更新操作,都會寫入所有node的binlog,當然,這是有條件的:更新操作的node上binlog_format=mixed或者row,反之,如果是statement,就只會在更新操作的node上寫入binlog。

另外,MySQL Cluster Replication是要求binlog是row-based,所以要將master的binlog設定為mixed或row。手冊中如是說:

Replication of a MySQL Cluster as described in this section and those following is dependent on row-based replication. This means that the replication master MySQL server must be started with --binlog-format=ROW or --binlog-format=MIXED

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/124805/viewspace-1026385/,如需轉載,請註明出處,否則將追究法律責任。

相關文章