Is there anyway to restore an Amazon RDS instance from a snapshot but skipping the backup step that happens right after it concludes?
In this hands-on lab, we'll use the point-in-time restore capability of RDS automated snapshots to restore a database and bring a site back up. **NOTE**: This lab may take up to 15 minutes to fully start due to the number of resources that need to be provisioned.
To restore a DB instance from a DB snapshotSign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/ . In the navigation pane, choose Snapshots. Choose the DB snapshot that you want to restore from. For Actions, choose Restore snapshot.
Usually, RDS backups don't cause downtime. Similar to EBS backup, the I/O needs to freeze the DB for a split fo the second to get a consistent LVM snapshot. After that, it is irrelevant how long the backup takes. Alternatively, you may consider taking the snapshot on the Read Replica to avoid the impact on Master.
PITR restore works by accessing your full backup and replaying the transaction log to the time that you tell AWS Backup to recover. Alternatively, snapshot backups can be taken as frequently as every hour. Snapshot backups can be stored for up to a maximum of 100 years.
At the time of this answer, unfortunately, there are nothing to avoid this first 'useless' backup.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With