… other operations, so beware. Binary log corruption – Binary log may become corrupted and out of sync with database content. This will sometimes break…. sync_binlog Is helping by syncing binary log, but at performance penalty. If using Innodb you also might with to use innodb-safe-binlog…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… practice you have to be very careful such as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using… disk failure. Though it also can be things like Innodb corruption or soft crash which you can’t recover promptly enough…) – for example you may have master or relay binary log corruption. Master or Slave running out of space, Slave crashing (and…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… going from innodb_flush_log_at_trx_commit=1 and sync_binlog=1 to values 2 and 0 appropriately. Both can be… get corrupted in case of bad crash timing, though you may lose some uncommitted transactions and binlog may get out of sync with…
