A media production company is designing a collaborative video editing platform. The platform has two main requirements:
1. A relational metadata database for video clips (OLTP) that requires complex SQL queries, a recovery point objective (RPO) of under minute, and a recovery time objective (RTO) of under minutes in a secondary disaster recovery region.
2. An object store for raw video assets in a central AWS account that must be securely accessed by an external vendor's IAM roles in a separate AWS account, requiring cross-account access and server-side encryption.
Which of the following database and storage strategies meets these requirements with the least operational overhead?
- Deploy an Amazon Aurora Global Database with the primary cluster in the primary region and a secondary cluster in the disaster recovery region. Store the raw video assets in an Amazon S3 bucket encrypted with an AWS KMS customer managed key, and configure the S3 bucket policy and KMS key policy to grant read access to the external vendor's IAM roles.Cevap
- BDeploy an Amazon Aurora Global Database with the primary cluster in the primary region and a secondary cluster in the disaster recovery region. Store the raw video assets in an Amazon S3 bucket encrypted with the default AWS-managed S3 key (aws/s3), and configure the S3 bucket policy to grant read access to the external vendor's IAM roles.
- CDeploy Amazon RDS for PostgreSQL in a Multi-AZ configuration in the primary region, routing read traffic to the standby instance to optimize performance during peak hours, and set up cross-region read replicas in the secondary region. Store the raw video assets in an Amazon S3 bucket encrypted with an AWS KMS customer managed key, and configure the S3 bucket policy and KMS key policy to grant read access to the external vendor's IAM roles.
- DDeploy Amazon RDS for PostgreSQL in a Multi-AZ configuration in the primary region, using AWS Backup to replicate database backups to the secondary region to support a pilot light disaster recovery strategy. Store the raw video assets in an Amazon S3 bucket encrypted with an AWS KMS customer managed key, and configure the S3 bucket policy and KMS key policy to grant read access to the external vendor's IAM roles.
Cevap
Deploy an Amazon Aurora Global Database with the primary cluster in the primary region and a secondary cluster in the disaster recovery region. Store the raw video assets in an Amazon S3 bucket encrypted with an AWS KMS customer managed key, and configure the S3 bucket policy and KMS key policy to grant read access to the external vendor's IAM roles.
The correct strategy uses Amazon Aurora Global Database to achieve near-zero RPO and low RTO because of its storage-level replication. For S3 cross-account access, a customer managed key is required because its key policy can be modified to trust the external account's IAM principal, which is not possible with AWS-managed keys like aws/s3.
Adım Adım Çözüm
Anahtar Kavram
To meet strict RTO/RPO objectives in multi-region deployments, Amazon Aurora Global Database provides active-passive cross-region physical replication with fast failover. Furthermore, S3 buckets shared across accounts must use Customer Managed Keys (CMKs) to enable decryption by external account principals, as AWS managed keys cannot be shared cross-account.