Is there any way to store the Tekkit Server Data on a SQL Database?
Looking to store :
World
Player Info (Inventory, location, exp, save, etc)
Reason I ask is,
1) Would make managing and viewing data easier
2) You can back up SQL databases, live, without having to shut down, copy files and restart the server
3) I already have servers optimized for running and handling SQL databases exclusively
4) I am looking to host multiple servers, and it would be easier to manage if the data was managed through one instance (with multiple databases)
Also, I see that there are several hosting companies that run Minecraft/Tekkit hosting. Running multiple instances of the GUI or .jar executable would be extremely poor for resource/server management so there must be some sort of software out there that allows you to do as such (using different hostnames/subnets/ports etc.
Lastly,
Currently, I am backing up our servers twice a day, but it is a manual process (as I have to shut down the server, copy the files, then restart the server again. Is there a way to either
a) Have the server perform automated backups? Can it be configured?
Can a scheduled task (windows task scheduler) be used to stop, start etc the server?
c) I know VSS is an option, but it is a route I would like to avoid if possible.
d) Anyone have any other ideas for backing up data reliably?