Ok, I'm going to deploy a lab for cs 4.11 in next few days and test the scenario on it. Thanks
On Thu, Jul 5, 2018, 12:12 Rohit Yadav <rohit.ya...@shapeblue.com> wrote: > Alireza, > > > Can you test against 4.11.1.0? Likely, Rafael suggestion may be around the > recent release than older 4.9/4.10 releases. > > > - Rohit > > <https://cloudstack.apache.org> > > > > ________________________________ > From: Alireza Eskandari <astro.alir...@gmail.com> > Sent: Wednesday, July 4, 2018 8:13:16 PM > To: dev@cloudstack.apache.org > Cc: rafaelweingart...@gmail.com > Subject: Re: MySQL HA > > Hi > Your fix works as expected, thanks. > But today I update CS to 4.9.3.1 and it seems that the fix was not ported > to this version. > Could you please send me an updated version of that jar file? > Regards > > On Mon, Dec 18, 2017, 14:03 Rafael Weingärtner < > rafaelweingart...@gmail.com> > wrote: > > > Here is a fix: > > > > > https://www.dropbox.com/s/kgakhs3v05uz88x/cloud-framework-cluster-4.9.3.0.jar?dl=1 > > You need to replace this jar file in CloudStack installation. You should > > also backup the original jar and restore it as soon as you finish > testing. > > To replace the JARs, you need to stop ACS, and just then start it. > > > > If everything works fine, I will open a PR against master, and with a bit > > of luck we can push it into 4.11 > > > > On Sat, Dec 16, 2017 at 8:03 AM, Alireza Eskandari < > > astro.alir...@gmail.com> > > wrote: > > > > > 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 > > > > > > > > > > > -- > > Rafael Weingärtner > > > > rohit.ya...@shapeblue.com > www.shapeblue.com > 53 Chandos Place, Covent Garden, London WC2N 4HSUK > @shapeblue > > > >
