Remote sql server backups

[uk01]

Hi

If we have a remote mysql server and also have vps snapshot backs on amazon aws, google cloud or another similar cloud/virtualised set up...

There could be a time difference between the cpanel vm backup and MySQL server backup. Eg if there is hourly snapshots, the system may back MySQL up at 10am but each cpanel server follows during the hour.

So if we have to restore a snapshot of either, does this time difference affect how the cpanel server loaded with the MySQL?

 

[cPanelLauren]

Hi @uk01

I believe this should work but the only thing you might be concerned about is the potential for missing data during gaps between when the site backup is taken and when the DB backup is taken. Ultimately though this is something a system administrator familiar with your configuration should be able to answer. If you don't have one you might find one here: Resources | cPanel Forums

 

[uk01]

Thanks, I am the admin, but there are differences in opinion, so I thought I'd start some research and discussion especially as more and more are talking about remote SQL and cpanel supports it.
Your thoughts on missing data are exactly what I was concerned about, so that raises topic for discussion here or elsewhere on how others avoid that as most CDP or replication runs at different intervals.

I guess if the sql server used a different backup strategy such as the master - slave, with syncing that would always ensure the remote sql was completely up to date.

However, if the cpanel server was replicated every 30mins that would reverse the issue as the cpanel server could be up to 29 minutes older than the mysql data it's connecting to, which may/may not be an issue.

More research needed!