I have MySQL binary logging switched on. My understanding is that binary logging is used by InnoDB for (a) replication to a slave database and (b) enabling InnoDB to recover and restore a database backup to a particular point in time using transaction rollback/forward.
In my circumstances, I am not replicating anything to a slave database nor plan to, and for my purposes a once-a-day mysqldump backup of the database is sufficient. To restore a database I've just been using the ordinary mysql cli command to load the dump into the database. Works fine for me and my needs.
So I'm wondering given my circumstances and needs do I really need mysql to be using binary logging at all? (1) Is binary logging a hit on VPS performance? (2) Would there be any negative effects or risks if I simply turned off binary logging altogether?
Thanks in advance for your thoughts.
I should also add that I am also running a Moodle 1.9.17+ installation on the same website and VPS account but in its own database completely separate from the Moodle 2.2.2 database.
Would turning off MySQL binary logging negatively affect such a Moodle 1.9.17 installation?