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!

Mysql Database sync between 2 servers

Discussion in 'Database Discussion' started by HostSane, Dec 10, 2018.

  1. HostSane

    HostSane Member

    Joined:
    Nov 26, 2018
    Messages:
    17
    Likes Received:
    4
    Trophy Points:
    3
    Location:
    Mumbai
    cPanel Access Level:
    Root Administrator
    Hello Experts,

    One of my clients has some odd requirement. He is trying to configure a high availability database structure with Cpanel. His aim to configure a fail over hosting for database.

    He has got 2 servers and trying to configure the fail over cluster with Haproxy , so far he has done good with HAproxy however the big issue here is Database sync.

    The client want to sync 1 database on 2 servers ( that are part of the fail over set up ) and if any changes made on server 1 which will be a master server must be synced immediately with the server 2

    Can you please suggest any configs, Tools or Tricks here please.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,124
    Likes Received:
    474
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
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