how to backup rds instances in AWS

1,204 views

Skip to first unread message

Olga

unread,

Mar 29, 2016, 8:07:12 AM3/29/16

to bareos-users

We are planing to move our infrastructure to AWS and there are some RDS instances running as a service, so I don't have ssh access to instance and cannot install bareos filedaemon on rds instance. Is there any way to backup mysql databases using mysqldump and bpipe?

Jeffrey Huckaby

unread,

Mar 30, 2016, 6:01:47 PM3/30/16

to bareos-users

On Tuesday, March 29, 2016 at 8:07:12 AM UTC-4, Olga wrote:
> We are planing to move our infrastructure to AWS and there are some RDS instances running as a service, so I don't have ssh access to instance and cannot install bareos filedaemon on rds instance. Is there any way to backup mysql databases using mysqldump and bpipe?

I suggest running a MySQL slave in EC2 and then exporting the data from the slave:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html

I recommend checking into Percona's XtraBackup.
https://www.percona.com/doc/percona-xtrabackup/2.1/how-tos.html

One workflow I can see is

RDS -> EC2 MySQL Slave -> Xtrabackup -> BareOS Normal File Backups

This give you many recovery options in case of RDS issues. We don't have this in production yet, but something we are considering.

Using xtrabackup allows us to store backups locally on an EBS Volume. We can then snapshot that volume as needed or even move it to another region.