can cpanel do mysql master master repliction?

cPanelDavidG

Technical Product Specialist
Nov 29, 2006
11,216
13
313
Houston, TX
cPanel Access Level
Root Administrator
I have a couple of very important database, thus i want to archive HA.

I'm just wonder how can i do it with cPanel.

How to setup master master mysql replication, refer this:

http://www.howtoforge.com/mysql_master_master_replication
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
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
208
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.
 

Serra

Well-Known Member
Oct 27, 2005
267
18
168
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.