MySQL Performance Blog » MySQL Crash Recovery

mysql

Binary log corruption - Binary log may become corrupted and out of sync with database content. This will sometimes break replication but if you’re just planning on using binary log for point in time recovery it can go unnoticed. sync_binlog Is helping by syncing binary log, but at performance penalty. If using Innodb you also might with to use innodb-safe-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5.0 XA is taking care of this synchronization.

  • sync_binlog=1にしないと、クラッシュ時にbinlogが失われるかもしれない。（ディスクにflushしてないので）
  • MySQL 5.0なら、innodb_support_xa = ONにすれば、クラッシュリカバリ時にInnoDBのログとbinlogの整合性を保つことができる。
  • でも、sync_binlog=1にすると、パフォーマンスに影響あるよ。