I am trying to determine if it is possible to configure the RDS service in AWS to do the following, but have not had much luck with my Google searches.
When it does its instance backup, have it automatically delete an RDS instance and spin up a new one using the backup. The use case here is to have the nightly backups of a production database generate a fresh "staging" database to be used in testing without affecting production data. This cannot be a replication type function because changing data on the staging db will effectively break replication.
When it does its instance backup, have it automatically copy the file to an FTP server. This is so a nightly copy could be pulled at anytime to update local database for development.
I am looking at improving some devops processes, and am tired of having to manually dump the production database to get my local copy up to date and also to get the staging server caught up. If the above is not possible via AWS, does anyone know if I there would be any issues with me making a bash script to execute a series of AWS console commands to try to do this or what issues I may have?