A company is deploying a new two-tier web application in AWS. The company has limited
staff and requires high availability, and the application requires complex queries and table
joins. Which configuration provides the solution for the company’s requirements?
MySQL Installed on two Amazon EC2 Instances in a single Availability Zone
Amazon RDS for MySQL with Multi-AZ
When is it appropriate to use DynamoDB instead of a relational database?
From our own experience designing and operating a highly available, highly scalable
ecommerce platform, we have come to realize that relational databases should only be used
when an application really needs the complex query, table join and transaction capabilities of
a full-blown relational database. In all other cases, when such relational features are not
needed, a NoSQL database service like DynamoDB offers a simpler, more available, more
scalable and ultimately a lower cost solution.