AWS Non-RDS

Non-Relational Dynamo DB:

-supports both document and key-value based data models.

-Stored on SSD storage.

-Spread across 3 geographical distinct data centers.

Eventual Consistent reads (by default). // couple of seconds.

Strongly consistent Reads: Read data within or less than 1 secs. As soon as the update is made, will reflect within 1 sec

- Suitable for application needs consistent single digit millisecond latency at any scale.

Flexible data model and reliable performance makes it fit for mobile, web, gaming, ad -tech, IoT and many other apps.
- Not ACID compliant.

- Amazon DynamoDB global tables provide a fully managed solution for deploying a multi-region, multi-master database. This is the only solution presented that provides an active-active configuration where reads and writes can take place in multiple regions with full bi-directional synchronization.

Redshift.:

Data warehousing solution

 DynamoDB Auto Scaling
- Will be monitoring your tables and indexes to automatically adjust throughput in response to changes in application traffic.
 -  DynamoDB auto scaling uses these initial settings as a starting point, and then adjusts them dynamically in response to your application's requirements.

-DynamoDB is the only solution presented that provides an active-active configuration where reads and writes can take place in multiple regions with full bi-directional synchronization.

-Memcached does not offer persistence.Elastic Cache Redis does.

-Memcache offers multithreading, Redis does nor.

-With MySQL, authentication is handled by AWSAuthenticationPlugin—an AWS-provided plugin that works seamlessly with IAM to authenticate your IAM users.