Engineering in Time

Snapshots of Technology

© 2015. All rights reserved.

RDS - Manual Snapshot database backups

02 Dec 2013

I've already posted how to use the ruby gem fog to create an RDS instance, now I will post how to create a manual snapshot of an RDS instance, in case once per day is not good enough. Below you'll find the code to do just that.

require 'fog'
connection = Fog::AWS::RDS.new(:aws_access_key_id => access_key, :aws_secret_access_key => secret_key, :region => "us-east-1")
result = connection.create_db_snapshot("my_database_instance", "my_database_instance-manual-1")

if result.status != 200
  puts "RDS manual snapshot request failed"
end

#Now check the snapshot's progress
mydb = rds.servers.get("my_database_instance")

my_snapshot = mydb.snapshots.get("my_database_instance-manual-1")

while my_snapshot.reload.state != "available"
  print "."
  sleep 20
end

puts "Created snapshot successfully"

Just a couple notes, manual snapshots need to be cleaned up "manually" and you'll want to validate this backup (as always).

Related Posts