How to lock tables of a database server running in a docker container before taking a snapshot?

[swc-phil]

This topic is similar to Script to stop and start an app with cron task.

In my personal opinion, you can just (zfs) snapshot db without stopping it. Especially if this db is having non-production workloads. And I’m citing myself:

@swc-phil

Durability (from ACID) “guarantees that the effects of transactions that have been committed will survive permanently, even in cases of failures”. Sooo, even a hypervisor’s snapshot should be fine. And in our case – zfs snapshot.

<some other considerations>