I’m planning a setup with a separate web server and database server. I’d like to make use of the automatic backup feature, but with the variability in the timing of the backups the images will not be in sync.
I thought a simple way may be for the web server to trigger the db server to create a dump when the web server backup takes place.
Obviously that’s still not perfect timing, so is there a better way?
Secondly, for my idea to work the web server would have to know when a backup was being made from it, is that even detectable?
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.