git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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 <rafaelweingartner@xxxxxxxxx>
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.alireza@xxxxxxxxx>
> wrote:
>
> > I'm using CS 4.9.3.0-shapeblue0
> >
> > On Sat, Dec 16, 2017 at 12:49 PM, Rafael Weingärtner
> > <rafaelweingartner@xxxxxxxxx> 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.alireza@xxxxxxxxx>
> > > 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
> > >> <rafaelweingartner@xxxxxxxxx> 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 <
> > >> > gabrascher@xxxxxxxxx> 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.alireza@xxxxxxxxx
> > >:
> > >> >>
> > >> >> > 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
>