How to use multiple mongodb databases in spring boot application?

Question

In my application, I need to use two MongoDB databases. I don't know how to add 2 MongoDB databases in the application.properties file in the spring application.

Here is the application.properties file of my project,

spring.data.mongodb.database=DB1
spring.data.mongodb.authentication-database=DB1
spring.data.mongodb.host=dev-ng-mongo1.domain.com
spring.data.mongodb.password=9876512
spring.data.mongodb.port=27017 
spring.data.mongodb.username=pavan

but I want to use another MongoDB database for the same project. How can I add the new database in the application.properties file.

user_1610005 · Answer

Please follow below steps to setup multiple mongodb data sources.

Define your primary and secondary mongodb properties like below in application.properties, please replace with them your db details:

######Primary Mongo DB########################
spring.data.mongodb.host=localhost
spring.data.mongodb.database=primary
spring.data.mongodb.port=27017
spring.data.mongodb.password=*******
spring.data.mongodb.username=*******

###########Secondary MongoDB#####################
mongodb.host=localhost
mongodb.port=27017
mongodb.database=secondary
mongodb.username=******
mongodb.password=******

Now add Multiple Mongo Db Configuration..

@Configuration
public class MultipleMongoConfig {

@Primary
@Bean(name = "primary")
@ConfigurationProperties(prefix = "spring.data.mongodb")
public MongoProperties getPrimary() {
    return new MongoProperties();
}

@Bean(name = "secondary")
@ConfigurationProperties(prefix = "mongodb")
public MongoProperties getSecondary() {
    return new MongoProperties();
}

@Primary
@Bean(name = "primaryMongoTemplate")
public MongoTemplate primaryMongoTemplate() throws Exception {
    return new MongoTemplate(primaryFactory(getPrimary()));
}

@Bean(name = "secondaryMongoTemplate")
public MongoTemplate secondaryMongoTemplate() throws Exception {
    return new MongoTemplate(secondaryFactory(getSecondary()));
}

@Bean
@Primary
public MongoDbFactory primaryFactory(final MongoProperties mongo) throws Exception {
    return new SimpleMongoDbFactory(new MongoClient(mongo.getHost(), mongo.getPort()),
            mongo.getDatabase());
}

@Bean
public MongoDbFactory secondaryFactory(final MongoProperties mongo) throws Exception {
    return new SimpleMongoDbFactory(new MongoClient(mongo.getHost(), mongo.getPort()),
            mongo.getDatabase());
}

}

Now enable EnableMongoRepositories for your primary an secondary.please make sure you change basePackages = "com.example.springbootmultipledatasource.primary.repository" your repository package here

@Configuration
@EnableMongoRepositories(basePackages = 
"com.example.springbootmultipledatasource.primary.repository",
    mongoTemplateRef = "primaryMongoTemplate")
 public class PrimaryMongoConfig {

 }

Secondary Mongo Template:Please make sure you change your secondary repository package here basePackages = "com.example.springbootmultipledatasource.secondary.repository

    @Configuration
    @EnableMongoRepositories(basePackages = "com.example.springbootmultipledatasource.secondary.repository",
        mongoTemplateRef = "secondaryMongoTemplate")
   public class SecondaryMongoConfig {
   }

Now you can create your document, repository, service, controller and you are good to go.below is my project structure you can create or have different.

How to use multiple mongodb databases in spring boot application?

1 Answers