Which solution will meet these requirements?
Amazon Aurora MySQL Multi-AZ DB cluster
Amazon Keyspaces (for Apache Cassandra)
Amazon DynamoDB table with DynamoDB auto scaling
Amazon DocumentDB (with MongoDB compatibility) cluster with a replica instance in a second Availability Zone
Explanations:
Amazon Aurora MySQL Multi-AZ DB cluster provides high availability and durability but may not be as cost-effective and scalable for sudden spikes in write traffic. It also does not natively support near real-time data streams for changes.
Amazon Keyspaces (for Apache Cassandra) is designed for handling large volumes of writes and offers scalability, but it is better suited for workloads requiring wide-column data structures and does not natively support near real-time data streams for changes.
Amazon DynamoDB is highly scalable and designed to handle sudden increases in write transactions. With DynamoDB auto scaling, it can automatically adjust throughput to meet demand. Additionally, DynamoDB Streams can provide a near real-time data stream of changes.
Amazon DocumentDB is compatible with MongoDB, providing scalable and highly available storage. However, it is not as cost-effective for handling high write traffic compared to DynamoDB, and it does not have the same near real-time streaming capabilities as DynamoDB Streams.