Hi Everyone,

I've written a simple perl script to facilitate automated backups from cluster - there was lots of stuff out there for standard mysql but nothing i saw in wild to handle clusters' distributed architecture. Essentially this script initiates a backup, collects files over scp from each data node, compresses these into a single archive and removes any archives over x days old.

Is there a utility i can use to verify the integrity of the backup data / control files retrieved from the data nodes? The idea being to log / send an alert if for some reason an incomplete or corrupted backup file were retrieved.

The script is pretty basic but all the same I'll upload it to the MYSQL forge once i've done a bit more testing as it may be useful to some folks.

Cheers,

Steve