The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    6
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    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,426
    Likes Received:
    2
    Trophy Points:
    38
    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:
    213
    Likes Received:
    4
    Trophy Points:
    18
    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