Hi Michael, there is not general rule, just because it depends a lot on how many requests per second will every db have, how many data it will contain, how complex your queries are and so on. As a rule of thumb, I would not go over a few tens of (small) databases per instance, just because CPU, RAM, IO and disk are limited resources and they have to be shared.
Thanks Luigi 2015-10-14 23:43 GMT+02:00 Michael MacFadden <[email protected]>: > Hello, > > For our architecture we are contemplating something like multi-tenancy. > In our approach each tenant would get their own database. When I say > database, I don't mean server. I mean a database within an OrientDB server. > > The question is... Is there a best practice way to do this. The three > options we see are: > > 1) Stand up an entire OrientDB server to host a single database. > This seems inefficient. Especially since we are going to look towards a > clustered / replicated architecture. > > 2) Put multiple databases into a single OrientDB Server > Here I am curious as to scalability. Is there a practical limit to how > many databases a single OrientDB cluster can hold? Each tenant may make > many connections to the database. If say each tenant makes 20 or so > database connections and we have 1,000 tenants, I now have 20,000 > connections going to the database. Obviously we would have many servers > supporting this load so that would be distributed. > > 3) Some middle ground where we have a certain number of tenants hosted in > each clustered instance of OrientDB > Not sure how to draw the line here. > > Just wondering if there are best practices around this? Thanks and keep > up the good work. > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
