CODEWITHSUNDEEP
mysqllogginginnodbflushfault-tolerance
Tobia
Tobia

Reputation: 9506

Innodb log flush to prevent data loss

I need to have a high power fault tollerance to my innodb engine and i can not change hardware configuration. Do you suggest to call

FLUSH ENGINE LOGS;

after a very important operations? Can it help to prevent data loss from poweroff or process crash?

Upvotes: 0

Views: 505

Answers (1)

jeremycole
jeremycole

Reputation: 2761

Using FLUSH ENGINE LOGS should be unnecessary. Your configuration of MySQL/InnoDB should have:

  • innodb_flush_logs_at_trx_commit = 1
  • sync_binlog = 1

Beyond that, if your hardware is not reliable, there's not much that can be done.

Upvotes: 1

Related Questions