How to create a DB Snapshot on AWS

 

AWS RDS creates a storage volume snapshot of your whole DB instance and not single tables. Creating the DB snapshot on single AZ results in a brief I/O suspension that can last between few seconds to few minutes. On multi-AZ DB instances there are not I/O suspension as it is done on the standby. To create a DB snapshot, please follow the steps bellow:

  1. Sign in to the AWS Management Console and open the Amazon RDS console at:

    https://console.aws.amazon.com/rds/.

  1. In the navigation pane, choose Instances and then from the list of DB instances, select the DBinstance for which you want to take a snapshot.
  1. Choose Instance actions, and then choose Take snapshot.
  2. On the Take DB Snapshot window, type the name of the snapshot in the Snapshot Name box.

 1.jpg

  1. Choose Take Snapshot.

You can also use the AWS CLI to create a DB snapshot. When you create a DB snapshot using it, you need to identify which DB instance you are going to back up, and then give your DB snapshot a name so you can restore from it later. You can do this by using the AWS CLI create-db-snapshot command with the following parameters:

  • --db-instance-identifier
  • --db-snapshot-identifier