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
