Which solution meets these requirements?
Use Amazon DynamoDB to invoke an AWS Lambda function.
Use an Amazon Aurora global database.
Use Amazon RDS for MySQL with a cross-Region read replica.
Use Amazon RDS for PostgreSQL with a cross-Region read replica.
Explanations:
Amazon DynamoDB with an AWS Lambda function does not inherently provide the required global visibility and consistency across multiple regions within 1 second, nor does it specifically cater to the failover and RTO requirements outlined in the scenario.
Amazon Aurora global database allows for low-latency global reads and supports cross-region replication with a replication lag of typically less than 1 second. It also meets the RTO of less than 5 minutes for failover, making it suitable for the application’s requirements.
Amazon RDS for MySQL with a cross-Region read replica does not provide immediate consistency for writes across regions and has a replication lag that could exceed 1 second. Furthermore, while it can support failover, the RTO might not meet the stringent requirement of less than 5 minutes consistently.
Similar to option C, Amazon RDS for PostgreSQL with a cross-Region read replica does not guarantee the required 1-second visibility for orders across regions. It also may not meet the strict failover and RTO requirements needed for uninterrupted manufacturing processes.