On March 28th, 2018 at approximately 1:30 pm CST the server housing the cPanel Feature Request site’s hypervisor unexpectedly failed.
This failure resulted in the loss of data back to September of 2017. Read more in our announcement.
 

MySQL Master-Master Replication between databases on the cPanel server and another server elsewhere.

Lupo Catttivo shared this idea 2 years ago
Open Discussion

It would be great to be able to do that between two cPanel server or even two server, where one is cPanel and the other is not, provided they both have mySQL installed. This is a very common practice in many newtwork envrionments, but I can't find the least reference to it anywhere on cPanel's knowledgebase.

thanks

Comments (2)

photo
1

Master-master replication is still quite complicated. In most cases you still have master slave with the slave that takes over as master if the master becomes unavailable. Not sure why you would have one of them on the cpanel server as to share the load you would need an ip load balancer between both mysql masters.

photo
1

Well there are many uses of such setups beyond load balancing. One of the common usages is when data from one database is used by other types of software in an intranet in another location. Sometimes business intelligence solutions also require database mirroring but it may happen that the main site and server are in Centos 7 while the business intelligence system is on a windows server (Tableau). Same applies to accountancy software that runs on olders OSes like Centos6 or even Ubuntu with older versions of MySQL than the one that cPanel ships with (for example a very popular accounting software in Italy called Passepartout runs only on Ubuntu and MySQL 5.1 and needs access to realtime database of the ecommerce site for which it does accounts). There are really many scenarios. Load balancing is just one but not the one I had in mind.