Please note: I am asking because, as the owner of the site, I just want to understand how this works. There is no need for any action at this time; just a response to my questions would be appreciated.
I am currently using DigitalOcean droplet server and MongoDB Atlas cloud for database. My server backups are taken daily at 4:50 PM by DigitalOcean, while MongoDB Atlas provides database backups at 1:47 PM daily.
In the event of an issue with my site, I am concerned about potential data inconsistencies due to the different backup times. If I need to restore the server from the DigitalOcean backup at 4:50 PM and use the MongoDB backup from 1:47 PM, there might be a discrepancy in the data between these times. This could result in the loss of any data changes made between 1:47 PM and 4:50 PM.
Could you please provide guidance on how to handle this situation? Is there a way to synchronize these backup times or any best practices to ensure data consistency during a restoration? Additionally, does MongoDB Atlas offer transaction logs or incremental backups that could help bridge the gap between these times?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Sign up for Infrastructure as a Newsletter.
Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Heya,
When using different backup schedules for your server and database, it’s understandable to be concerned about potential data inconsistencies that may arise during a restoration.
What you can do is to use Incremental backups. They can significantly mitigate the risk of data loss. MongoDB Atlas supports continuous backups with incremental data capture. This means changes are tracked continuously, allowing for more precise restorations.
Also you can test your backup and restoration procedures to ensure they work correctly and understand how much time is needed to restore the site fully. This practice will help identify any gaps in your backup strategy. This of course is recommended in a a staging environment to ensure your live application wont be affected by the restoration proccess.
Regards
Hi there,
With DigitalOcean the backup window is a 4-hour window of time during which the Droplet automatically initiates a new backup. In the Backup Window section, use the dropdown menus to customize your Droplet’s backup window by choosing a time of day and, for weekly backups, a day of the week.
However, you still would have that 4-hour window.
As DigitalOcean and MongoDB Atlas Cloud are separate companies, you can’t directly correlate their backup times.
Does your website change so frequently that there could be a discrepancy between the database schema and the website code?
If this is the case, you could consider a backup provider SnapShooter:
That way you will have a centralized provider that manages your backups.
- Bobby