A company's application team needs to select an AWS managed database service to store application and user data. The application team is familiar with MySQL but is open to new solutions. The…

Deploying Amazon RDS for MySQL in each Region with DMS replication would typically result in an active-passive write model or significant data consistency challenges for active-active writes, and may not consistently meet the low-latency and high-transactional requirements at global scale.

An Amazon Aurora MySQL global database with write forwarding allows secondary regions to forward writes to a single primary region, meaning it operates in an active-passive *write* configuration rather than truly active-active writes across multiple regions simultaneously.

Amazon DynamoDB with global tables provides a fully managed, multi-Region, active-active database that enables applications to perform both reads and writes to the same data in multiple AWS Regions simultaneously. It offers massive scalability, consistent low-latency (single-digit milliseconds) response times, and is ideal for de-normalized data accessed via unique IDs, directly fulfilling all critical requirements.

Amazon DocumentDB global clusters typically support an active-passive write model, where writes are directed to a single primary region, and replicas in other regions are read-only or rely on eventual consistency mechanisms that do not constitute active-active writes to the same data.