How to create master-master MySQL database sync on aaPanel?

aaP_earnbyshare2016

I have 3 machines and may have more later on. 1 machine act as load balancer while the other 2 contain same website files and database. Most of the CPU usage is on mysql so I have to separate database in 2 machines in order relieve the load.

The structure would be like:

Each time when I update the website. I will trigger an update.php which write something into the database. But because of the load balancer. Some data was written into aaPanel 2 while some was written into aaPanel 3. Thats why I would like to create a "Master-Master sync" between aaPanel 2 and 3.

As the traffic of my websites grow suddenly recently. And I am new to this area. If this structure is not good for future development. It is my pleasure to hear your advise. Thank you in advance.

aaP_manophiabtranfer

want to know too.

Admin, please add this to the plugin.
i will buy it.

aaP_hareeshnarayan1982

Hardly any panel have this kind of database focussed features. I was looking for clustering and replications but none of them have this feature. Hope AAPanel team will look into this.

aaP_ocalle905

Can be an excellent plugins we will buy it.

TrK

If you are going to do DB clustering i recommend to have two master with load balancing and one slave acting as a backup server, but it will impossible to achieve with aapanel, cause clustering is something you gotta do manually there are many aspects where a "panel" is just not sufficient for DB clusters.