gistfile1.ru

rds.create_db_snapshot(
  :db_snapshot_identifier => 'test-snap',
  :db_instance_identifier => '[production-instance]'
)

rds.restore_db_instance_from_snapshot(
  :db_snapshot_identifier => 'test-snap',
  :db_instance_identifier => 'clone',
  :db_instance_class => 'db.m1.small'
)

gistfile2.ru

rds.create_db_parameter_group(
  :db_parameter_group_name => 'clone-group',
  :engine => 'MySQL5.1',
  :description => 'Test group for clone'
)

rds.modify_db_instance(
  :db_instance_identifier => 'clone',
  :db_parameter_group_name => 'clone-group'
)

rds.reboot_db_instance(
  :db_instance_identifier => 'clone'
)

rds.modify_db_parameter_group(
  :db_parameter_group_name => 'clone-group',
  :parameters => [
    {:name => 'slow_query_log',         :value => 'ON',  :apply_method => 'immediate'},
    {:name => 'long_query_time',        :value => '1',   :apply_method => 'immediate'},
    {:name => 'min_examined_row_limit', :value => '100', :apply_method => 'immediate'}
  ]
)

gistfile3.txt

> mon-get-stats CPUUtilization \
    --dimensions="DBInstanceIdentifier=[prod-instance]" \
    --statistics=Minimum,Maximum,Average \
    --namespace="AWS/RDS" \
    --period=3600 \
    --headers \
    --start-time="2010-04-05"