How I can do periodic database backups?

Node Operators FAQ
21

You can add your idea or vote for existing there: https://ideas.storj.io
Also, here is discussion regarding graceful exit:

22

A node is only disqualified if it fails too many audits or is offline for too long.
So if I notice that my node is offline because of a database corruption, I would still have time to revert to an old backup and bring it back online.
The satellite might need many hours to audit the pieces the db backup is missing, which would give time for a graceful exit.
Question: Is the node still being audited after a graceful exit is started? Basically can it get disqualified while doing a graceful exit?

23

Yes, the node is still audited and yes, it could be disqualified in the process of graceful exit.

24

Aded my idea here, please feel free to comment/vote?
https://ideas.storj.io/ideas/V3-I-82

25

So what happens if a node gets disqualified while performing a graceful exit? Will it not get any money back?

26

The graceful exit will be marked as failed and you will not receive a money back.
The link to the updated design: https://github.com/storj/storj/blob/fe8d556b4ef04299cc83c0e2faf7eebd31f5634b/docs/blueprints/storagenode-graceful-exit/overview.md

27

Thanks for the answer.
So as of now, backups are a complete waste of space and effort since you probably won’t even be able to gracefully exit without getting disqualified during the process (but will have wasted a lot of time and upload until you get disqualified, however you would have lowered the repair costs for STORJ :D)

28

I don’t mean to throw a wrench into this discussion, but the way I understood it the databases are not actually vital to the core function of your node.

Even if you start over with all empty databases, you lose stats, you may lose some bandwidth contracts that weren’t sent yet and you won’t be paid for, but your node is still able to respond correctly to audits and downloads by customers. Don’t get me wrong, your node will be a mess. It won’t be able to manage storage limits and bandwidth limits correctly, the dashboard would show wrong numbers, you can’t calculate earnings anymore. But from what I understand, it will still work and wouldn’t necessarily be disqualified.

29

Well that doesn’t sound too bad then :slight_smile:

30

then older database, where is lost 1 day may be is much better than no incom for month

31

You wouldn’t lose an entire months income. Only unsent orders. Since orders are sent every hour the impact of that is negligible. Wouldn’t worry about that too much.

32

At the moment you can use a Windows backup feature (don’t forget to exclude the blobs folder).
On the Linux you can use a cron with rsync.
Or scheduler/cron to run an uplink to backup databases to Storj network

33

Does “on the fly” (while client is still running and using DB) copy of DB files result in working DB bacup? Or it can de done properly only after shut down node for a time of bacup?

34

The only multiple rsync (robocopy in case of Windows) can make it possible. Also, Windows shadows copy is reliable enough.
But better to stop the storagenode before the database backup.