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:rafaelweingart...@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 <adr...@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:adr...@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:rafaelweingart...@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 > <adr...@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:adr...@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.ba...@shapeblue.com> > wrote: > > > > Hi Damodar, > > > > Comments inline. > > > > On 06-Jun-2014, at 10:53 am, Damoder Reddy > > <damoder.re...@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:adr...@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.ba...@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
