More About AWS Relational Database Service
In the case of a Manual snapshot, point-in-time recovery is not possible.
Manual Snapshot is also stored in S3.
They are not deleted automatically if you delete the RDS instance.
Take a Final Snapshot before deleting your RDS DB instance.
You can share Manual Snapshot directly with other AWS accounts.
When you restore a DB instance, only the default DB parameters and security groups are associated with the restored instance.
You can not restore a DB snapshot into an existing DB instance, rather it has to create a new DB instance. It has a new endpoint.
Restoring from a backup or a DB snapshot changes the RDS instance endpoint.
At the time of restoring, you can change the storage type (general purpose or provisioned)
You can not encrypt an existing unencrypted DB instance.
To do that, you need to:-
- Create a new, encrypted instance and migrate your data to it (From unencrypted to encrypted
OR
- You can restore from a backup/snapshot into a new encrypted RDS instance.
RDS supports encryption-at-rest for all DB engines using KMS.
What actually encrypted when data is at rest?
All its snapshots
Backups of DB (S3 storage)
Data on EBS Volume
Read the replica created from the snapshot
Some points related to RDS Billing:-
- No upfront cost.
- You have to pay only for
DB instance hours (Partial hour charged as a full hour)
Storage GB/month
Internet Data Transfer
Backup Storage (i.e. S3)
This increases by increasing DB Backups Retention Period.
AWS also charges for
- Multi-AZ DB hours
- Provisioned Storage (Multi-AZ)
- Double Write I/O
- You are not charged for DB data transfer during replication from Primary to Stand-By