cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adrian Lewis <adr...@alsiconsulting.co.uk>
Subject RE: Examples of configuring DB HA?
Date Mon, 09 Jun 2014 23:04:44 GMT
Fresh 4.3 from the RPMs in the repo. Done yesterday. Had to yum install
mysql on the management server as the client binaries weren't present but
mysql-connector-java was installed as a dependency of the cloudstack rpm.
Could something else be missing on the Centos side or does this look like a
CS issue?

-----Original Message-----
From: Rafael Weingartner [mailto:rafaelweingartner@gmail.com]
Sent: 10 June 2014 00:01
To: users@cloudstack.apache.org
Subject: Re: Examples of configuring DB HA?

the last question is the proper one.. ;) Probably because someone forgot it.
I also hate when this kind of thing happens...
How did you set up the CS version ? I mean fresh install 4.3 or upgrade from
an older version?


On Mon, Jun 9, 2014 at 7:49 PM, Adrian Lewis <adrian@alsiconsulting.co.uk>
wrote:

> I guess my question should perhaps be, does anyone know why the jar
> that contains the class isn’t already in the classpath and what's the
> best way to fix it?
>
> -----Original Message-----
> From: Adrian Lewis [mailto:adrian@alsiconsulting.co.uk]
> Sent: 09 June 2014 23:37
> To: users@cloudstack.apache.org
> Subject: RE: Examples of configuring DB HA?
>
> I'm going to sound stupid here but how do I find the jar that contains
> the classes and what is the classpath?
>
> Is this a bug of some sort?
>
> -----Original Message-----
> From: Rafael Weingartner [mailto:rafaelweingartner@gmail.com]
> Sent: 09 June 2014 23:28
> To: users@cloudstack.apache.org
> Subject: Re: Examples of configuring DB HA?
>
> Well, tomcat is returning 404, because the app is not running. As a
> consequence of a class not found exception. Find the jar that contains
> the classes that are missing and add them into the classpath.
>
>
> On Mon, Jun 9, 2014 at 7:18 PM, Adrian Lewis
> <adrian@alsiconsulting.co.uk>
> wrote:
>
> > I was very close to getting this up and running in the lab (Centos
> > 6.5 – 2 x sql servers and 1 mgmt server – all running in VMware
> > Workstation, installed from 4.3 repo) but when setting the
> > db.ha.enabled to true and restarting the mgmt. server, I now get 404
> > from tomcat and the management server log has lines in it saying
> > things
> > like:
> >
> >
> >
> > 2014-06-09 22:48:00,632 ERROR [c.c.u.d.Merovingian2] (main:null)
> > Unable to get a new db connection
> >
> > java.sql.SQLException: Invalid load balancing strategy
> > 'com.cloud.utils.db.StaticStrategy'.
> >
> > […]
> >
> > Caused by: java.lang.ClassNotFoundException:
> > com.cloud.utils.db.StaticStrategy
> >
> >
> >
> > Anyone got any idea? Tried Googling and searching the mailing list
> > but nothing that I can see as an answer. I’m just a lowly network
> > engineer so wouldn’t know what these errors mean but I’m guessing I
> > won’t be the first.
> >
> >
> >
> > Any ideas?
> >
> >
> >
> > *From:* Adrian Lewis [mailto:adrian@alsiconsulting.co.uk]
> > *Sent:* 06 June 2014 10:51
> > *To:* users@cloudstack.apache.org
> > *Subject:* Re: Examples of configuring DB HA?
> >
> >
> >
> > Hi all,
> >
> > Firstly thanks for the great responses already.
> >
> > Secondly, regarding HA vs failover, I had been assuming these as
> > much the same. Based on what I had read about the new changes in
> > 4.3, I had assumed that the new feature allows you to configure
> > standard MySQL (clustering not required - Galera or otherwise) in a
> > multimaster replication setup and that while management servers only
> > speak with a single server at a time, failover to a backup server is
> > automatic and does not need any work on the MySQL side to promote a
> > slave to a master as with a basic master/slave setup.
> >
> > I'm personally not interested in load balancing just yet, simply
> > having a hot standby DB that takes over automatically. This is what
> > I take the term HA to mean.
> >
> > From the wiki, I'm also taking it that the use of the auto increment
> > and offset values ensure that the two DBs can safely run as
> > master-master in the event that each gets written to concurrently
> > (split brain or just two mgmt servers failing over at slightly
> > different times).
> >
> > It seems that this thread is already highlighting some of the
> > confusion I and others have faced. Hopefully it will help someone else.
> >
> > Thanks again,
> >
> > Adrian
> >
> > On 6 Jun 2014 07:18, "Shanker Balan" <shanker.balan@shapeblue.com>
> wrote:
> >
> > Hi Damodar,
> >
> > Comments inline.
> >
> > On 06-Jun-2014, at 10:53 am, Damoder Reddy
> > <Damoder.Reddy@citrix.com>
> > wrote:
> >
> > > Hi Adrian,
> > >
> > > For your question, . Is the CS side purely for failover or does it
> > actually set up part of the replication for you? The answer is, the
> > Cloud Stack does only failover configuration and the actual
> > replication process on the mysql side has to be done by own.
> >
> >
> > https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=348
> > 38
> > 207
> >
> > > For the second question, Can you easily enable an existing DB for
> > > HA or
> > is this best done before there’s any data? The answer is, we can
> > setup replication even with existing data and then start the
> > management
> servers.
> > The mysql documentation contains the clear steps how to setup
> > replication with existing documentation. Probably that is the reason
> > why we might not have included these steps in the doc.
> > >
> >
> >
> > The OP is looking for HA, not failover. HA is possible in ACS 4.3.0
> > using MySQL Clustering.
> >
> > Once you have MySQL Clustering, its multi-master and not one master
> > to many slaves.
> > ACS should not fence itself like it currently does when the master
> > is not available.
> >
> >
> > > The configuraiton we need to do on each management server is as below.
> > >
> > > You can follow the design doc steps if you think there is a
> > > minimal
> > documentation in the 4.3 doc. The design doc also contains the links
> > to mysql site for setting up the replication for fresh as well as
> > existing setups.
> > >
> > > From the cloud stack side it is purely failover and falling back
> > > between
> > the IPs configured for the master/salve databases.
> > >
> >
> > https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=348
> > 38
> > 207
> >
> >
> >
> > > -----Original Message-----
> > > From: Adrian Lewis [mailto:adrian@alsiconsulting.co.uk]
> > > Sent: Friday, June 6, 2014 6:46 AM
> > > To: users@cloudstack.apache.org
> > > Subject: Examples of configuring DB HA?
> > >
> > > Hi all,
> > >
> > >
> > >
> > > Does anyone have any example configs or blog posts explaining the
> > > DB HA
> > features introduced in 4.3? Between the section in the design docs
> > on the wiki and the official docs, I’m a little confused as to how
> > it’s supposed to be set up – they appear to differ although there’s
> > a lot more detail in the design docs. Some of it is clearly MySQL
> > stuff that’s outside of Cloudstack but some of it is Cloudstack
> > config as well. I’m just trying to get a feel for what is the best
> > way to use what’s made it into 4.3 final (if different to the design
> > docs). I’m not too strong on MySQL so I can’t easily work out what’s
> > a requirement, what’s just recommended (and
> > > implications) and what the Cloudstack side actually does. Is the
> > > CS side
> > purely for failover or does it actually set up part of the
> > replication for you? Can you easily enable an existing DB for HA or
> > is this best done before there’s any data? Before you run
> > cloudstack-setup-databases?
> > >
> > >
> > >
> > > Shanker – I don’t suppose this subject could add to your already
> > excellent blog post collection?
> > >
> > >
> > >
> > > Thanks in advance,
> > >
> > >
> > >
> > > Adrian
> >
> > --
> > @shankerbalan
> >
> > M: +91 98860 60539 | O: +91 (80) 67935867
> > shanker.balan@shapeblue.com
> > | www.shapeblue.com | Twitter:@shapeblue ShapeBlue Services India
> > | LLP,
> > 22nd floor, Unit 2201A, World Trade Centre, Bangalore - 560 055
> >
> > Find out more about ShapeBlue and our range of CloudStack related
> > services
> >
> > IaaS Cloud Design & Build<
> > http://shapeblue.com/iaas-cloud-design-and-build//
> > <http://shapeblue.com/iaas-cloud-design-and-build/>>
> > CSForge – rapid IaaS deployment
> > framework<http://shapeblue.com/csforge/>
> > CloudStack Consulting<http://shapeblue.com/cloudstack-consultancy/>
> > CloudStack Infrastructure Support<
> > http://shapeblue.com/cloudstack-infrastructure-support/>
> > CloudStack Bootcamp Training Courses<
> > http://shapeblue.com/cloudstack-training/>
> >
> > This email and any attachments to it may be confidential and are
> > intended solely for the use of the individual to whom it is addressed.
> > Any views or opinions expressed are solely those of the author and
> > do not necessarily represent those of Shape Blue Ltd or related
> > companies. If you are not the intended recipient of this email, you
> > must neither take any action based upon its contents, nor copy or
> > show it to anyone. Please contact the sender if you believe you have
> > received this email in error. Shape Blue Ltd is a company
> > incorporated in England & Wales. ShapeBlue Services India LLP is a
> > company incorporated in India and is operated under license from
> > Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company
> > incorporated in Brasil and is operated under license from Shape Blue
> > Ltd. ShapeBlue is a registered trademark.
> >
>
>
>
> --
> Rafael Weingärtner
>



--
Rafael Weingärtner

Mime
View raw message