英文:
Can we share single table in DynamoDB to multiple application
问题
我是新手使用DynamoDB,我们最近正在寻找将我们现有的MySQL应用迁移到DynamoDB的选项。由于DynamoDB将每个AWS区域的表格数量限制为256。我们有多个微服务
例如:订单服务、报价、产品成本、服务支持等。因此,即使对于单个客户,我们也需要创建表格=微服务数量。因此,我们很快就会达到256的限制。由于我是新手,我正在学习数据建模。是否有一种方法可以对我们的数据库进行建模,使其能够支持多个应用程序。
英文:
I'm new to DynamoDB, we are recently looking for options to migrate our existing MySQL applications to DynamoDB. Since DynamoDB limits the table count to 256 per AWS region. We have multiple micro-services
Eg: service for orders, Quotes, Product costing, Service support etc. So now even for a single customer We need to create tables = # of micro service. Hence we will be reaching this limit of 256 soon. As I'm new I'm learning about the Data modeling. Is there any way to model our DB to make it robust in such a way it supports multiple application.
答案1
得分: 1
你应该尽量确保项目具有共同的关系,以便对项目进行分类(即它们都是订单记录,而不是包含订单、产品和CMS内容的单一表)而不是将它们用作多用途表格,处理实际上是多个表格记录合并在一起而没有关联的情况。
256表格限制实际上是一个软限制。
对于任何AWS帐户,每个AWS区域有256个表格的初始配额。
您可以联系AWS支持以请求增加此配额,这仅是为了防止可能不了解服务如何工作的新用户创建大量资源并产生大额费用。
我建议您继续联系AWS支持以增加此配额,然后继续为表格的预期用途进行架构设计。
还可以查看DynamoDB设计和架构的最佳实践。
英文:
You should try and make sure that items have a common relationship for items (i.e. they're all order records vs a single table containing orders, products and CMS content) vs using them as a multi purpose table to handle what is essentially multiple tables records compounded together with no relation.
The 256 table limit, is actually a soft limit.
> For any AWS account, there is an initial quota of 256 tables per AWS Region.
You can contact AWS support to request an increase, this is simply to prevent a new user who might not be aware of how the service works from creating a substantial number of resources and incurring large costs.
I suggest going through with contacting AWS support to increase this quota, and then continue with architecting your tables for the purpose they should be used for.
Also take a look at Best Practices for Designing and Architecting with DynamoDB.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论