Backup of disparate databases in MySQL

Question

MySQL

Please tell me the solution for the subject, which is suitable for backing up MySQL databases under the following conditions:

• The total database size is about 8GB.
• The total number of databases is 100+.
• Almost every database has both MyISAM tables and innoDB.
• There are databases in which tables have different encodings.
• Archive consistency.

Answer 1

and what mysqldump does not suit?

Answer 2

Remote encrypted backup of MySQL using LVM snapshot

Answer 3

maatkit.org

Answer 4

or mk-parallel-dump/mk-parallel-restore. Used for quite some time on a good sized base.