rjames@stripped ("Rick James") writes:
> If you have no slaves, you don't need to write the binlogs.
That's not entirely true.
If you don't care about db recovery then you don't need the
binlogs. That is if you have a server crash and the db files get
corrupted the normal way to recover if you can't fix the files
yourself is to restore from an older backup and then reapply the
binlogs from that point until the server crash. This will end up
giving you the state of the server when the crash/damage took place.
If you stop using binlogs and have a "busy day" and run something like
"DROP DATABASE XXXX" then without binlogs or application logs to redo
the changes you lose all the data in between.
Whether this is an issue for your situation of course depends
on the usage, but advising that binlogs are not necessary unless
you need replication is not fully correct.
Simon
