- a script that, on a schedule, connects to the replica MySQL service(s), locks it, flushes all tables to disk, snapshots the underlying storage, and finally unlocks the replica to resume logical replication.
That final idea is the only one I've come up with so far that I believe solves the speed, availability, data integrity, and backup problems all at once (you could lock and flush to disk your primary db node, and then snapshot its storage, sure, but that'd eventually have an impact on availability), but is heavy on complexity. Moreover, it doesn't work for services that don't have readily available replication solutions, e.g. Uptime Kuma's SQLite-based data store, so I still need to figure out a backup strategy for those