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. We will then use bareos external to AWS for last-ditch recovery efforts. -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
