Backup ... backup... Backup... but of course.. you also need to
monitor and test those backups often otherwise they could be
worthless. Having your MySQL binlogs enabled can certainly help you in times of
an emergency as well. The MySQL binlogs are often
referenced in regards to MySQL replication, for a good reason,
they store all of the queries or events that alter data (row-based is a little different but this an
example). The binlogs have a minimal impact on server performance
when considering the recovery options they provide.
[anothermysqldba]> show variables like 'log_bin%';
+---------------------------------+--------------------------------------------+
| …
Community journal
Follow the feed
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Showing entries 1 to 1 of 1
« Previous |
Next »