Which solution will meet these requirements?
Amazon RDS for MariaDB with cross-Region read replicas
Amazon RDS with a Multi-AZ deployment
Amazon DynamoDB global tables
Amazon DynamoDB with a global secondary index (GSI)
Explanations:
Amazon RDS for MariaDB with cross-Region read replicas does not provide true active-active configuration. Cross-Region read replicas can be used for read scaling but do not support real-time write synchronization across regions, which is required for near real-time data replication.
Amazon RDS with Multi-AZ deployment provides high availability within a single region, but it does not support cross-Region replication or an active-active configuration across multiple regions. This option would not meet the requirement for global data synchronization.
Amazon DynamoDB global tables provide a fully managed, active-active configuration with near real-time synchronization of data across multiple AWS regions. It meets the requirement for low RTO and RPO (< 5 minutes) and supports automatic replication of data across regions.
Amazon DynamoDB with a global secondary index (GSI) does not provide active-active configuration across multiple regions. A GSI is used to allow querying on non-primary key attributes within a single region, but it does not meet the requirement for cross-Region data synchronization.