Configuring MySQL for Power Failure I have an embedded device running a MySQL database with a web based application.

The problem is when I shutdown my embedded device it just cuts off the power, and I can not have a controlled shutdown. Given this situation how can I configure MySQL to prevent it from failures and in case of a failure, I should have maximum support to recover my database. 

While searching this, I came across InnoDB Engine as well as some configuration options to set like sync_binlog=1 &amp; innodb_flush_log_at_trx_commit=1. I have noticed my default Engine is InnoDB and binary logs are also enabled. 

What are other configurations to make for best possible failure &amp; recovery support?

I have absolutely no experience with databases and MySQL.
You can do many things to prevent this.


Move DB server to somewhere else (hosting)
Buy an UPS
Change to a simpler DB software (SQLite, Files)
Make your code to always save the latest changes, so when power up, programs keep running from last saved point.