DynamoDB….contd…
Amazon DynamoDB is a fully managed NoSQL database service that lets you offload the administrative burdens of operating and scaling a distributed database. In this three part series, I am going to walk you through the basics of the service and lead you to best practices that could save you some operational expense while using this service.
This is the third and the last part of this series. To start from the beginning, visit this article..
Part C — Recommendations to keep your DynamoDB operational cost to a minimum
Best Practices to Save DynamoDB Cost
- Prune your tables systemically
Deleting unnecessary items from the operational data store and moving them into your organization’s data warehouse for archival or analytics is a best way to reduce storage cost. Note that DynamoDB does not have DELETE ON CASCADE like most RDBMS do. Therefore, you are responsible to delete the orphaned items on a multi relational data model in your datastore model.
2. Think Twice before using Strong Consistent Reads or Transactions API
Figure 3 — Cost of Reads and Writes in DynamoDB
DynamoDB charges almost twice as much for read units when using Strong consistent reads and twice more than the cost of consistent reads while using Transactional APIs. So, have a…
