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.

Answer 1

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));

Answer 2

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.