When I build CloudStack RPMs on 4.5 branch I get mysql ha RPMs. Looking at
the specfile:
%if "%{_ossnoss}" == "noredist"
%package mysql-ha
Summary: Apache CloudStack Balancing Strategy for MySQL
Requires: mysql-connector-java
Requires: %{_tomcatversion}
Group: System Environmnet/Libraries
%description mysql-ha
Apache CloudStack Balancing Strategy for MySQL
%endif
Looks like you need to "./package.sh -p noredist" when packaging. Not sure
what the equivalent is for .deb packaging. That means you also have to be
set up with the non-oss dependencies. If you're not familiar with that let
us know.
On Thu, Jun 11, 2015 at 7:06 AM, Andrija Panic <andrija.pa...@gmail.com>
wrote:
> Actually, on another ACS installation, there is file:
>
>
> /usr/share/cloudstack-management/webapps/client/WEB-INF/lib/cloud-plugin-database-mysqlha-4.3.2.jar
> (acs 4.3.2 :) )
>
> But on this 4.5.1 there is no such file.
>
> Is it possible that we didnt compile 4.5.1 in appropriate way ?
>
> Thanks,
> Andrija
>
> On 11 June 2015 at 15:14, Andrija Panic <andrija.pa...@gmail.com> wrote:
>
> > Hi,
> >
> > I'm trying the DB HA setup, by chaning 3 lines in db.properties file
> > (enable HA, define slaves for cloud, define slaves for usage DB)
> >
> > After restart, mgmt server doesn start with folowing error, as it seems
> > invalid load balancing strategy variable...
> >
> > Any clues on this ?
> >
> > mysql setup is galera 3 node cluster, 1st node being used as master in
> > db.properties, and only second node being used as slave (galera2 node)
> > I confirmed I can telnet, login etc... also mysql login from mgmt to
> these
> > master/slaves works of course...
> >
> >
> >
> > 2015-06-11 14:25:03,149 INFO [c.c.u.d.T.Transaction] (main:null) Is Data
> > Base High Availiability enabled? Ans : true
> > 2015-06-11 14:25:03,191 INFO [c.c.u.d.T.Transaction] (main:null) The
> > slaves configured for Cloud Data base is/are : 10.20.10.6
> > 2015-06-11 14:25:03,269 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'.
> > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
> > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
> > at com.mysql.jdbc.Util.loadExtensions(Util.java:602)
> > at
> >
> com.mysql.jdbc.LoadBalancingConnectionProxy.<init>(LoadBalancingConnectionProxy.java:285)
> > at
> >
> com.mysql.jdbc.FailoverConnectionProxy.<init>(FailoverConnectionProxy.java:67)
> > at
> >
> com.mysql.jdbc.NonRegisteringDriver.connectFailover(NonRegisteringDriver.java:430)
> > at
> >
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:343)
> > at java.sql.DriverManager.getConnection(DriverManager.java:571)
> > at java.sql.DriverManager.getConnection(DriverManager.java:215)
> > at
> >
> org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
> > at
> >
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
> > at
> >
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
> > at
> >
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
> > at
> >
> com.cloud.utils.db.TransactionLegacy.getStandaloneConnectionWithException(TransactionLegacy.java:203)
> > at com.cloud.utils.db.Merovingian2.<init>(Merovingian2.java:68)
> > at
> > com.cloud.utils.db.Merovingian2.createLockMaster(Merovingian2.java:80)
> > at
> > com.cloud.server.LockMasterListener.<init>(LockMasterListener.java:33)
> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> > Method)
> > at
> >
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> > at
> >
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > at
> java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> > at
> > org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)
> > at
> >
> org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:121)
> > at
> >
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
> > at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1045)
> > at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:949)
> > at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487)
> > at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
> > at
> >
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
> > at
> >
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
> > at
> >
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
> > at
> >
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
> > at
> >
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:628)
> > at
> >
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
> > at
> >
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
> > at
> >
> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145)
> > at
> >
> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122)
> > at
> >
> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245)
> > at
> >
> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250)
> > at
> >
> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233)
> > at
> >
> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117)
> > at
> >
> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
> > at
> >
> org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
> > at
> >
> org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:70)
> > at
> >
> org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:57)
> > at
> >
> org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:61)
> > at
> >
> org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
> > at
> >
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210)
> > at
> > org.apache.catalina.core.StandardContext.start(StandardContext.java:4709)
> > at
> >
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802)
> > at
> > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
> > at
> > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583)
> > at
> >
> org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
> > at
> >
> org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
> > at
> > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
> > at
> > org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
> > at
> >
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
> > at
> >
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
> > at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068)
> > at
> > org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
> > at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060)
> > at
> > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
> > at
> > org.apache.catalina.core.StandardService.start(StandardService.java:525)
> > at
> > org.apache.catalina.core.StandardServer.start(StandardServer.java:759)
> > at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:606)
> > at
> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:606)
> > at
> >
> org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:243)
> > Caused by: java.lang.ClassNotFoundException:
> > com.cloud.utils.db.StaticStrategy
> > at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
> > at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
> > at java.security.AccessController.doPrivileged(Native Method)
> > at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
> > at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
> > at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
> > at java.lang.Class.forName0(Native Method)
> > ... 74 more
> >
> > --
> >
> > Andrija Panić
> >
>
>
>
> --
>
> Andrija Panić
>
