When using mysqldump should I be using
--single-transaction? should i always use
What are best practices for dumping multiple MySQL databases? (
It is entirely going to depend on your requirements. Read the manpage, use the flags to create the type of dumps you need, and then test the restoration. Be careful with locking, as it will likely prevent your application(s) from working on varying levels.
There are numerous backup strategies for MySQL, which differ between engine types. The same methods to backup MyISAM are not always able to be applied to InnoDB. This topic is well covered on Serverfault, I suggest you search the site.
One of my preferred strategies:
I would recommend reading through some of the posts on the MySQL Performance Blog (Author of the excellent book on the subject of MySQL Performance) relating to backups: http://www.mysqlperformanceblog.com/category/backups/. (Xtrabackup is covered).
Beware that the Maatkit tools are great for many tasks including dumps but probably not a good backup tool. -ab