Most databases I use keep a write-ahead log, which guards against power failure without requiring an external service. Multiple writes are handled without an issue. If power is lost, the database recovers automatically using whatever is on disk, no matter when it was interrupted.

So a file system snapshot behaves the same and the database can start up from the snapshot even if it was taken at an arbitrary point mid-write.