How many databases can mongodb support?

[Stennie_X (Stennie)]

Welcome to the MongoDB Community @relb !

The general answer to capacity planning questions like this is that you will have to model your use case to understand resource usage and performance:

@Stennie_X

The maximum number of databases and collections is a practical limit determined by a combination of factors including your system resources, schema design, workload, and performance expectations. If your working set is significantly larger than available RAM, performance will suffer and eventually become I/O bound shuffling data to and from disk. You can scale a single server vertically (adding more RAM and disk), but it will eventually be more economical to scale horizontally (across multiple servers) using sharding.

@relb

what i undestood from the mongodb Concurrency, mongodb locks collections not documents

WiredTiger, MongoDB’s default storage engine since MongoDB 3.2 (early 2015), has document-level concurrency for most operations. See FAQ: Concurrency for more details.

@relb

vps setup:

4 vCPU Cores
8 GB RAM
200 GB SSD

You’ll have to evaluate whether 8GB RAM is sufficient for your working set and performance expectations, but keep in mind that this will be divided amongst:

• Your base O/S memory usage.
• WiredTiger cache for your working set of documents and indexes. With 8GB of RAM the WiredTiger cache will be 3.5GB by default
• Memory used by the mongod process outside of WiredTiger cache for connections and in-memory data processing (aggregations, in-memory sorts, JavaScript evaluation, …).
• Any other applications running in the same host environment (ideally only backup, monitoring, and other management agents related to your database deployment).
• Filesystem cache.

If you are building a self-hosted deployment for production usage, I highly recommend starting with a replica set deployment for data redundancy, high availability, and admin convenience. However, that would require a minimum of three instances rather than one.

Once your multi-tenant SaaS platform has significant adoption you will likely have to consider how to scale and distribute workload. One option would to grow to a sharded cluster deployment for geographic distribution and workload balancing (for example, Segmenting Data by Application or Customer using zone sharding).

As an alternative to managing and scaling a self-hosted deployment, you could also look into MongoDB Atlas which has Auto-Scaling for M10+ dedicated clusters and an Atlas Serverless offering currently in preview with pricing based on resource usage.

Regards,
Stennie