Thursday, February 11, 2010

MySQL Backups to AWS Cloud

A client asked me to write a script to perform nightly MySQL database backups to the AWS cloud. They also viewed this as an opportunity to test the Amazon Web Services (AWS) waters.

They had the following requirements:

Full backup every night. No need to worry about differentials or incrementals.

Backups must be encrypted prior to transmission.

Transmission must take place over secure channel.

Following a backup run, an email notification must be sent to the DBA's.

Documentation.

Rather than re-invent the wheel, and write the tool from scratch, I decided to do some research. I came across two Open Source resources, which combined together with some modifications, addressed my clients needs.