Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

best practise to handle multiple databases with couchDB

I have opted for having a database per user in couchdb. (all the database are totally independent and no aggregation is needed between them) Now my app is growing and i have thousands of databases.

couchDb does not keep more than 100 open db at the same time. to improve performance, is it better to

  1. keep one instance of couchdb and increase the number of open DB
  2. launch another couch DB server instance and split users between.

so to sum up, the question is :

if you have independent data DBs, is it better to scale horizontally or vertically ?

like image 324
Med Tumy Avatar asked Oct 29 '22 21:10

Med Tumy


2 Answers

I would personally vote for horizontal scaling. It comes with less lookup time and some failure diversification. But, as @Alexis Côté stated, nothing beats the cluster.

like image 200
Boris Schegolev Avatar answered Nov 11 '22 18:11

Boris Schegolev


Clustering ist one of the new inbuild features of CouchDB 2.0

  • https://blog.couchdb.org/2016/08/08/release-candidates/
  • https://blog.couchdb.org/2016/08/17/migrating-to-couchdb-2-0/
like image 32
Sceada Avatar answered Nov 11 '22 19:11

Sceada