I'm asking this here because i view this community a little better than others.
1. Is it worth turning on Binary Logs for mysql and take the performance hit? Or would full backups say every 2 or 3 hours be a bad idea?
2. I know this differs for everyone but what is the "standard", or best practice frequency for binary logs.
3. Is this turned on by default with the ispconfig install? I read on http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
that mysql has to be started with a specific parameter in order to get the binary logs to work. So is this turned on by default, where do i check, where do i set this?
Basically I'm just looking for your general thoughts and experience as I'm only used to doing full mysqldumps. Currently the db I'm concerned with isn't large at all but obviously over time this will no longer be the case. I don't want to take to much of a performance hit, or have a pain to restore stuff, so in that sense full backups are easier. But at what size db are full backups frequently no longer a good option?