What's the best practice to use dbmate in k8s?

[simsicon]

How do you use dbmate in k8s environment?

[amacneil]

I haven't personally tried this, but know folks who have. You can probably run it as a Job pod?

How to trigger is up to you.

[simsicon]

Thanks, I think that's it, a job pod will do that.

[pawndev]

Personnaly, I'm using it in an initContainer.
You can take your application docker image and run the migration from it. Or, you can put all your migrations in a PersistentVolume/ConfigMap, and mount it in you containers/initContainers.

That is the way I'm using it.

[gregwebs]

initContainer is good for auto-migrating. Another approach is to send a notification when there are unapplied migrations.

Dockerfile that adds the migrations into the image.

FROM amacneil/dbmate:2.2
RUN apk add curl

ADD . /sql/dbmate
WORKDIR /sql/dbmate
ENTRYPOINT ["/bin/sh", "./pending-check.sh"]

notification script

#!/usr/bin/env bash
set -euo pipefail
export DATABASE_URL=postgres://${PGUSER}:${PGPASSWORD}@${PGHOST}/${PGDATABASE}
dbmate status
if dbmate status | grep Pending >/dev/null ; then
    unapplied=$(dbmate status | grep '\[ \]')
    # notify about unapplied migrations here
fi