Alireza, This is a warning and should not cause you much trouble. I have been trying to pin point this problem for quite some time now. If I generate a fix, would you be willing to test it?
On Tue, Dec 12, 2017 at 8:56 AM, Gabriel Beims Bräscher < gabrasc...@gmail.com> wrote: > 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 > > > -- Rafael Weingärtner
