Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Remote sql server backups

Discussion in 'Data Protection' started by uk01, May 13, 2018.

  1. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    112
    Likes Received:
    10
    Trophy Points:
    68
    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?
     
  2. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    1,855
    Likes Received:
    135
    Trophy Points:
    118
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    112
    Likes Received:
    10
    Trophy Points:
    68
    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!
     
    cPanelLauren likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice