Gitlab shared runners + liquibase

Question

I would like to setup a Gitlab pipeline that uses liquibase to execute a database migration. I am using Gitlab shared runners to execute the pipeline.

I would like to do this while keeping my database behind an SSH bastion so no direct connection is allowed.

I have seen most people follow these approaches to accomplish this:

• Use specific runners instead of shared ones
• Deploy an instance in ECS that contains the migration script

Is there any best practice or solution for this problem?

Thanks in advance!

Answer 1

Can you make a jdbc url that connects the database if so Liquibase can establish the connection.
Here are the common ways to form a jdbc url. Once you have that url, you can put it in the liquibase.properties file to connect to the database