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:
- Sign in to the AWS Management Console and open the Amazon RDS console at:
https://console.aws.amazon.com/rds/.
- 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.
- Choose Instance actions, and then choose Take snapshot.
- On the Take DB Snapshot window, type the name of the snapshot in the Snapshot Name box.
- 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