best practice MySQl backup onto tape

[Jenny Chen]

Hi,

I'm planing to do hot backup MySQL(innodb db) onto tape drive, and propose
the following solution/script:

   # delete old mysql dumps
     rm -r -r /backup/mysql
     mkdir /backup/mysql

   # Dump all mysql databases
     mysqldump --all-databases -single-transaction --flush-logs >
all_databases.sql
     mysqldump --database=mysql --lock-all-tables --flush-logs > system.sql

   # Do backup
      tar cvf /dev/rmt/0 /backup/mysql

My question is: is there any other better solutions(including commercial
solutions) to do hot MySQL backup to tape that can provide better
performance, or can backup directly to the tape(no need to dump to disk
first), etc. comparing to use mysqldump.

Thanks in advance for your information, or comment on the above solution.


Regards,
Jenny