Posts in category Backups
Easy MySQL: how to backup databases t...
Here’s a simple answer to a simple question. “How do I run a backup of MySQL to another machine without writing to the local server’s filesystem?” – this is especially useful if you are running out of space on the local server and cannot write a temporary file to the filesystem during backups.
Method one ̵ [...]
Monolith DBA Toolkit 0.4.3 Released
The Monolith Toolkit of scripts for DBA routines. 0.4.3 has been released. You can download it here: http://code.google.com/p/monolith-toolkit/
Some information on the toolkit and what it contains:
mt-backup-parallel -> runs mysql backups in parallel super fast, has lots of reporting features
mt-check-replication -> script to report [...]
Parallel mysqldump backup script avai...
Large databases, long mysqldump times, long waits for globally locked tables. These problems basically never go away when you rely on mysqldump with –all-databases or a list of databases, as it dumps schemas serially. I’m not going to explain serial vs parallel processing here since that’s a larger topic. Suffice to say th [...]
“Dump Completed” on mysql...
If you’re verifying successful backups by using the last line of a mysqldump sql file that says “dump completed” – be aware that prior to version 5.0.27 mysqldump does not output that line. Confusion could ensue!
Rotating General Query & Slow Lo...
Sometimes you need to have the general query log on and even though it causes more disk I/O than you may want, it’s good for troubleshooting. This log can and probably will fill up your disks rather quickly. Then there’s the slow query log – setting log_slow_queries and log_queries_not_using_indexes will write out the que [...]
