All geek questions in one place

Number of cloud database restrictions

I plan that my database is stored in Cloudant .

Our application is multi-touch. We currently separate tenants based on the values ​​in some of our tables, which naturally translate into value in the document. Another way is to have a database for each tenant. Currently, we have about 100 tenants, and we hope that in our best forecasts it will grow to 500-2000.

What are the pros and cons between all tenants in one db versus db per tenant?

Is there a limit on the amount of database that we can create and work at the same time?

+4
source share
1 answer

This is a good and difficult question. For both models there are pros and cons. The main advantage of one large database is that you can easily analyze (search, display, etc.) for all users. The main advantage of one-db-per-user is that each user has their own sandboxes, which can be pleasant for your SLA. In addition, this means that the amount of data in each user database can be relatively small.

If you can provide more detailed information about the stored data, relational modeling and the queries that you hope to do, I can probably give you a more satisfactory answer.

+5
source

Source: https://habr.com/ru/post/1495930/

More articles:


All Articles