Hi Gurus, I have looked at AWS documentation. But could not find solutions to below:
1. How to copy RDS backup to my own S3 bucket. Is there a way? I even looked up stackoverflow.
2. AWS documentation says that I can store the RDS db snapshot to my own s3 bucket, But Actions context menu has no such action to move the snapshot to a chosen s3 bucket.
3. In a multi-AZ setup where I have a primary RDS and a standby RDS in AZ1 and AZ2, how does AWS keep the RDS DBs in sync? I know of GoldenGate but wanted to know if AWS has its own way of doing it.
If this has already been discussed in some other thread, appreciate if you can direct me there.
In answer to your first question, RDS automated backups are stored out on S3, but not accessible to customers. They just use a seperate space for those backups tied to your account…same with EBS snapshots.
For how multi-AZ RDS works, check out this blog from AWS…. It’s a bit old, but still covers the concepts: https://aws.amazon.com/blogs/database/amazon-rds-under-the-hood-multi-az/