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
& 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 & recovery support?
I have absolutely no experience with databases and MySQL.