Hi Alireza, I have production environments with Master to Master replication and we have no problems. We may need more details of your configuration. Have you configured the slave database? Are you sure that you configured correctly the ha heuristic?
Considering that you already configured replication and "my.cnf", I will focus on the CloudSack db.properties file. When configuring Master-Master replication, you should have at /etc/cloudstack/management/db.properties something like: ----------------------------- db.cloud.autoReconnectForPools=true #High Availability And Cluster Properties db.ha.enabled=true db.cloud.queriesBeforeRetryMaster=5000 db.usage.failOverReadOnly=false db.cloud.slaves=acs-db-02 cluster.node.IP=<cluster node IP> db.usage.autoReconnect=true db.cloud.host=acs-db-01 db.usage.host=acs-db-01 #db.ha.loadBalanceStrategy=com.mysql.jdbc.SequentialBalanceStrategy db.ha.loadBalanceStrategy=com.cloud.utils.db.StaticStrategy db.cloud.failOverReadOnly=false db.usage.slaves=acs-db-02 ----------------------------- "db.ha.loadBalanceStrategy" is confiugured with the heuristic "com.cloud.utils.db.StaticStrategy" "db.ha.enabled" need to be “true” The primary database is configured with the variable “db.cloud.host”. The secondary database(s) is(are) configured with the variable “db.usage.slaves”. One variable that is different from both Apache CloudStack servers is “cluster.node.IP”, being the ACS mgt IP. Additionally, you will need to create a folder “/usr/share/cloudstack-mysql-ha/lib/” and move the jar file “cloud-plugin-database-mysqlha-4.9.3.0.jar” into the new folder. ----------------------------- mkdir -p /usr/share/cloudstack-mysql-ha/lib/ cp /usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-plugin-database-mysqlha-4.9.3.0.jar /usr/share/cloudstack-mysql-ha/lib/ ----------------------------- Cheers, Gabriel. 2017-12-12 6:30 GMT-02:00 Alireza Eskandari <astro.alir...@gmail.com>: > I have opened a new jira ticket about this problem: > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 >
