MongoDB multitenancy (Java): How to switch MongoDB databases, with different DB credentials, at run-time, using MongoClient?

Question

I am facing an issue regarding MongoDB multi-tenancy. I have two different mongoDB databases (db1 and db2). These both have different credentials.

db1 credentials:
userName: admin
password: passwd

db2 credentials:
userName: admin1
password: passwd1

I need to switch from one database to other at run-time. I have autowired mongoTemplate with db1 credentials, but now I am unable to update the template with db2 credentials. Is this possible? If yes, how? If not, please tell me any other way to switch the databases at run-time with different credentials.

Note that, I am aware of "SimpleMongoDbFactory". One can extend "SimpleMongoDbFactory" and can override "getDb" method and pass the required dbName in super.getDb("dbName") for multitenancy. But, this does not work with two databases with different credentials.

Why not create two separate mongo templates each referencing it's own simplemongodbfactory ? — s7vr
– s7vr, Commented Jan 3, 2017 at 14:55
This would work for 2 or fixed number of databases. But what if, the number of databases is not fixed? — Sumit A
– Sumit A, Commented Jan 4, 2017 at 7:25
Hi Sumit, I have same requirement if you have solved please guide me. — Lakshman Miani
– Lakshman Miani, Commented Oct 20, 2017 at 5:49
Hi Lakshaman, this is not possible by using Java MongoClient. You have to know the number of databases, before initializing mongoTemplate, as you can see in stackoverflow.com/a/41446383/2163876. One of the solutions is "taking the checkout of Java MongoClient and update the code according to our requirement". — Sumit A
– Sumit A, Commented Nov 1, 2017 at 6:46

perbellinio · Accepted Answer · 2017-01-03 15:02:33Z

4

What if you create a MongoCredential for each DB and pass them to a MongoClient that you pass to your SimpleMongoDbFactory

    MongoCredential credential1 = MongoCredential.createCredential("admin", db1, "password");
MongoCredential credential2 = MongoCredential.createCredential("admin1", db2, "password1");
    MongoClient mongoClient = new MongoClient(new ServerAddress(), Arrays.asList(credential1, credential2));

answered Jan 3, 2017 at 15:02

perbellinio

6826 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Sumit A Over a year ago

How does this approach works with MongoDB Connection Pools? How many connections would be present at a time?

perbellinio Over a year ago

If I am not wrong the connection pooling is manage by the MongoClient internally. You can anyway pass to the MongoClient construction a MongoClientOptions (you can for example configure the number of connection per host).

perbellinio Over a year ago

Anyway what is really important for the connection pooling is that you have only one instance of your MongoClient for your application

Sumit A Over a year ago

Ok, Thanks! That was really helpful.

elhefe Over a year ago

Note that multiple credentials per client is now deprecated and will be removed in a future version: jira.mongodb.org/browse/JAVA-2656

|

cjungel · Accepted Answer · 2017-01-03 16:59:28Z

0

Create independent MongoTemplate instances each one with it's own credentials and select the appropriate in runtime.

Every connection is established using the credentials so if you change them on an existing connection you are essentially destroying the connection and creating a new one and would not be taking advantage of pooling.

edited Jan 3, 2017 at 16:59

answered Jan 3, 2017 at 16:51

cjungel

3,7911 gold badge27 silver badges20 bronze badges

2 Comments

Sumit A Over a year ago

Yeah! For two databases, it would work but for 'n' number of databases, is there a proper way for multi-tenancy along with connection pooling?

cjungel Over a year ago

You would need to keep a some sort of map of MongoTemplate instances and select the appropriate on runtime. If n is large and only a few of the instances are expected to be active on any given time then i would make sure to set the minimum connection to 0 to avoid establishing unused connections to the server and potentially exhausting its resources.

Collectives™ on Stack Overflow

MongoDB multitenancy (Java): How to switch MongoDB databases, with different DB credentials, at run-time, using MongoClient?

2 Answers 2

8 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related