Is it possible to back up the database at shorter intervals (e.g., every hour) in the ModX Cloud? The backup should be stored on an external server.
Hi @mediengaarage,
We may look at this to help reduce data loss in the case of a catestrophic data center failure as occured in the recent 30 hours. However, our current backup scheme is designed to extract the site and mysqldump the db then zip the entire thing and transfer it to cloud object storage (distributed, reduntant, offsite storage). Any change to that would require we move to some sort of change-based system. Backups and mysql exports are CPU intensive. This isn’t to say we might not be able to have a more change-based store of the db.
I should also note, if this is in light of the server fire at AMS3, under any other failure state, our public platforms in MODX Cloud are self-redundant and if the platform itself failed we could have done any number of things such as replace a drive in the array or deploy a new, identical machine and migrate the data (something we’ve done a couple of times) and the sites would have the last available state of the db.
This outage at AMS3 is very unusual where the first two lines of redundancy were not available to us and we have to consider the third which is restore form last available backup.
We’re absolutely open to your thoughts and suggestions on improving our service.
Thanks for asking!