This have been really frustrating for me as of late since I just found out today that it seems to me that the Minetest Multiplayer List is based up if the server been online for at least 8 hours for the last 8 hours.
Rendering daily backups of the server (since it does have to be shut down for it be done safely.) pulling me to the bottom for up to a third of the day because of this up time “uptime” system.
So I am wondering what if there’s anything I am able to do? Like are there other options aside from playing a “creative like” game which is Minecraft and people birching to me, about paying for it?
Have you tried using the sqlite online backup feature?
I’ve never tried it, but the forum says this works:
#!/bin/sh for db in map players sauth; do sqlite3 $db.sqlite ".timeout 1000" ".backup $db-backup.sqlite" done
Ya that what I am not certain about the “time out” function. Like I am assuming it would block everything from being written preventing anything from happening. So my thoughts is it’s probably not any better than “just” freezing the process though docker. And if all else fails freezing the VPS from the provider end (I seen “Pause” at a number of hosts so that shouldn’t be hard to come by) to do the same but at the VPS level and snapshotting it. I might not be able to get the snapshot off the network BUT at least it’s a backup regardless. Just not the best backup in the world…
You should try it out, because I think the timeout is just acquiring the initial lock, but IDK how that will interact with minetest, but it should be better than “pausing” because of less/no downtime.
At least that’s more understanding to me, thanks for explaining that to me and I shall see how it’s does. Should be easier to implement to boot.
What I can do is fire her up on a cron (after manually testing first) and play the game activity to see if I notices anything and what if any.