Re: How to disable write cache in every way on mysql / innodb?

[Peter Brawley]

The design objectives you're asking about, eg get rid of all buffering, flush everything instantly &c, aren't realistic with a multiuser transactional database system. And in general, a system whose power can be disconnected often & arbitrarily isn't suitable for storing a relational database.

Mostly, we want relational databases on reliable servers with uninterruptible power supplies, automatic backup calibrated to minimise data loss from hardware and software crashes, often replication, and many other failover provisions.