MongoDB.live, free & fully virtual. June 9th - 10th. Register Now

One big DB or several small DBs?

The company I work for is successful. We reach the limit of a single MongoDB.

Up to now we have several hundred customers and all data gets stored in one MongoDB.

I see two solutions:

  • Sharding
  • Give every customer a single DB

What are the pros/cons of both solutions? What do you suggest?

Hello Thomas.

You mean that reach the limit of O/S or hardware size. There is no limit in WiredTiger.

For sharding or lot of single customer DBs it will depends of the characteristics of your workload and purposes of your main queries.

Regards,
Alexandre Araujo

Hi Alexandre,

thank you for your answer. Good to know that there is no limit it WiredTiger.

Yes, we reach the limit of the virtual machine we use.

You say it depends on the characteristics of your workload and purposes of your main queries.

Could you please elaborate?

When is sharding useful, and when is N mongoDBs useful?

Regards,
Thomas Güttler