MySQL backups with NBU

[Chad_Wansing]

Ok, so I'd like to think I've researched this issue pretty thoroughly, but I've come up with nearly nothing. Please tell me there's a better way to do an NBU backup of a MySQL database than to do an export and then pick it up with the standard backup rotation. At least we can do hot backups to the export, but surely there's a better way......

[DavidParker]

Sounds like you're hoping for an Agent (like MSSQL and Oracle and Sybase, etc).
Unfortunately I don't believe that there is an Agent for MySQL.

Here is an idea that might be a step further for your situation.
Setup a policy that allows 'User' backups 24x7.
Modify your script that does the MySQL export and add a command to initiate a 'User' backup (using the /usr/openv/netbackup/bin/bpbackup command).

That way, as soon as you export the DB to file, you immediately send it to tape. No waiting for nightly jobs to pick it up!

Hope that's vaguely helpful,
$0.02

[Yasuhisa_Ishika]

Once MySQL AB and VERITAS have a plan to release MySQL agent.
But I've never heard they ship it so far.

http://forums.mysql.com/read.php?28,19392,19392

[Isidro_Rodrig1]

This is similar to what David is saying...

Use the bpstart and bpend scripts to control the schedule of Mysql dumps. Confiure a dedicated policy for the database dump directory. This way you can send errors to standard output and control database backup failures using regular Netbackup error codes.