Prev Next

Database / Liquibase interview questions

How do you use Liquibase with multiple databases or schemas in a single application?

When an application uses multiple databases or schemas — for example, a multi-tenant SaaS app with one schema per tenant, or an application split across a billing schema and a product schema — Liquibase can manage each independently. The key is that each schema/database gets its own DATABASECHANGELOG table and its own Liquibase execution context.

In Spring Boot with multiple data sources, you configure multiple Liquibase beans manually since Spring Boot's auto-configuration only handles one:

@Configuration
public class LiquibaseConfig {

    @Bean
    @Primary
    public SpringLiquibase primaryLiquibase(
            @Qualifier("primaryDataSource") DataSource primaryDataSource) {
        SpringLiquibase liquibase = new SpringLiquibase();
        liquibase.setDataSource(primaryDataSource);
        liquibase.setChangeLog("classpath:db/changelog/primary/db.changelog-master.xml");
        return liquibase;
    }

    @Bean
    public SpringLiquibase billingLiquibase(
            @Qualifier("billingDataSource") DataSource billingDataSource) {
        SpringLiquibase liquibase = new SpringLiquibase();
        liquibase.setDataSource(billingDataSource);
        liquibase.setChangeLog("classpath:db/changelog/billing/db.changelog-master.xml");
        return liquibase;
    }
}

For per-tenant schema provisioning in multi-tenant applications, a common pattern is running Liquibase programmatically when a new tenant is created, using the tenant's schema name:

public void provisionTenantSchema(String schemaName) {
    SpringLiquibase liquibase = new SpringLiquibase();
    liquibase.setDataSource(sharedDataSource);
    liquibase.setChangeLog("classpath:db/changelog/tenant/db.changelog-master.xml");
    liquibase.setDefaultSchema(schemaName);
    liquibase.afterPropertiesSet();  // triggers migration immediately
}

Each schema gets its own DATABASECHANGELOG in that schema, keeping migrations isolated even when sharing a single database server.

When configuring two separate Liquibase beans in Spring Boot for two different data sources, where does each database's migration history get stored?
Which SpringLiquibase method triggers migration execution programmatically outside the normal Spring lifecycle?

More Related questions...

What is Liquibase and what problem does it solve? What is a changeLog in Liquibase? What is a changeSet in Liquibase and how is it identified? What are the DATABASECHANGELOG and DATABASECHANGELOGLOCK tables? What is the difference between Liquibase and Flyway? What are contexts in Liquibase and how do you use them? What are labels in Liquibase and how do they differ from contexts? How does rollback work in Liquibase? What is a Liquibase precondition and why would you use one? How do you integrate Liquibase with Spring Boot? What are Liquibase change types and can you name common ones? What is the Liquibase diff command and when is it useful? What are Liquibase tags and how do you use rollback to a tag? What is runOnChange and runAlways in a Liquibase changeSet? What is the markNextChangeSetRan and markNextChangeSetRanSQL command used for? How do you manage Liquibase changeLog files in a multi-module Maven project? What is the Liquibase updateSQL command and when is it used? What is a Liquibase snapshot and what commands use it? What is the failOnError attribute in a changeSet and when should you set it to false? How does Liquibase handle transactions during migration? What is the Liquibase Hub and what does it provide? How do you use Liquibase with multiple databases or schemas in a single application? What is the Liquibase Pro checksum validity and how do clearCheckSums and validChecksums work? What are Liquibase custom change types and how do you create one? How do you handle large table migrations in Liquibase without causing downtime? What is the Liquibase Maven plugin and how do you run migrations with it? What is the Liquibase status command and how does it differ from validate? What are Liquibase property substitution and how does it work? How do you write Liquibase changeLogs in YAML format? What is the Liquibase formatted SQL changeLog format? What is the Liquibase updateTestingRollback command? How do you use Liquibase with Docker and Testcontainers in integration tests? What is the difference between addColumn with a default value and a nullable column in Liquibase for large tables? What is liquibase.properties and what configuration belongs in it?
Show more question and Answers...

Azure Cosmos DB interview questions

Comments & Discussions

Interviews Questions

About Javapedia.net

Javapedia.net is for Java and J2EE developers, technologist and college students who prepare of interview. Also this site includes many practical examples.

This site is developed using J2EE technologies by Steve Antony, a senior Developer/lead at one of the logistics based company.

Follow Javapedia updates

contact: javatutorials2016[at]gmail[dot]com

Kindly consider donating for maintaining this website. Thanks.

Copyright © 2026, javapedia.net, all rights reserved. · .

DMCA.com Protection Status