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!

can cpanel do mysql master master repliction?

Discussion in 'General Discussion' started by neorder, Jan 20, 2009.

  1. neorder

    neorder Well-Known Member

    Joined:
    Jun 16, 2003
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    156
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,216
    Likes Received:
    10
    Trophy Points:
    313
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    This is not natively supported by cPanel/WHM. However, you can refer to the following presentation to learn more about how our Remote MySQL system works so you can explore the possibility of doing this yourself:

    http://www.cpanel.net/conference/08/files/RemoteMYSQLServer.pdf
     
  3. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,483
    Likes Received:
    31
    Trophy Points:
    158
    cPanel Access Level:
    DataCenter Provider
    This should work as long as you have good settings for

    auto_increment_increment

    and

    auto_increment_offset


    Server 1:
    auto_increment_increment=4
    auto_increment_offset=1

    Server 2:
    auto_increment_increment=4
    auto_increment_offset=2

    Leaves room for adding Server 3 & 4 in the future.
     
  4. Serra

    Serra Well-Known Member

    Joined:
    Oct 27, 2005
    Messages:
    258
    Likes Received:
    17
    Trophy Points:
    168
    Location:
    Florida
    I've done this using the guide you reference and it worked fine. When I updated the various files correctly, it worked right off the bat. If it doesn't work, check all of the entries.

    Restarting mysql is key. In master master, it doesn't matter which you restart first, but both need to be restarted.
     
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