I'm using CS 4.9.3.0-shapeblue0
On Sat, Dec 16, 2017 at 12:49 PM, Rafael Weingärtner <rafaelweingart...@gmail.com> wrote: > Awesome! > I found one method that might seem the cause of the problem. > What is the version of ACS that you are using? > > On Sat, Dec 16, 2017 at 4:10 AM, Alireza Eskandari <astro.alir...@gmail.com> > wrote: > >> Hi >> >> Gabriel, >> My configuration is same as your suggestion, but I get the errors. >> >> Rafael, >> You are right. I confirm that CS works normally but I get those warnings. >> I would make me happy to help you for this fix :) >> >> >> On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner >> <rafaelweingart...@gmail.com> wrote: >> > 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 >> > > > > -- > Rafael Weingärtner