can cpanel do mysql master master repliction?

[neorder]

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

 

[cPanelDavidG]

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]

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]

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.