git.net

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

Re: MySQL HA


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.yadav@xxxxxxxxxxxxx> 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.alireza@xxxxxxxxx>
> Sent: Wednesday, July 4, 2018 8:13:16 PM
> To: dev@xxxxxxxxxxxxxxxxxxxxx
> Cc: rafaelweingartner@xxxxxxxxx
> 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 <
> 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
> >
>
> rohit.yadav@xxxxxxxxxxxxx
> www.shapeblue.com
> 53 Chandos Place, Covent Garden, London  WC2N 4HSUK
> @shapeblue
>
>
>
>