Amazon RDS - DB Snapshots

Amazon RDS – DB Snapshots

Amazon RDS creates automated backups of your DB occasion throughout the backup window of your DB occasion and shops them as quantity snapshots.

Automated Backup

For Automated backup to work correctly, followings are the factors.

 

  • Your DB occasion have to be within the ACTIVE state for automated backups to happen. Automated backups do not happen whereas your DB occasion is in a state apart from ACTIVE, for instance STORAGE_FULL.
  • Automated backups and automatic snapshots do not happen whereas a replica is executing in the identical area for a similar DB occasion.

The primary snapshot of a DB occasion accommodates the info for the total DB occasion. Subsequent snapshots of the identical DB occasion are incremental, which signifies that solely the info that has modified after your most up-to-date snapshot is saved.

The next diagram reveals how we are able to configure the automated backup window for a DB occasion utilizing the AWS console. To disable the automated backup, set the variety of days to zero.

 snapshot_1.JPG

Handbook Backup

We will additionally take backups manually by utilizing snapshots. To take a snapshot manually we use the occasion motion choice after deciding on the occasion as proven under.

 snapshot_2.JPG

We will aslo take handbook backup utilizing the CLI with the under command.

 

aws rds create-db-snapshot /
    --db-instance-identifier sourcedbinstance /
    --db-snapshot-identifier dbsnapshotinstance