Re: MySQL HA

2018-07-05 Thread Alireza Eskandari
eases. > > > - Rohit > > <https://cloudstack.apache.org> > > > > > From: Alireza Eskandari > Sent: Wednesday, July 4, 2018 8:13:16 PM > To: dev@cloudstack.apache.org > Cc: rafaelweingart...@gmail.com > Subject: Re:

Re: MySQL HA

2018-07-05 Thread Rohit Yadav
o: dev@cloudstack.apache.org Cc: rafaelweingart...@gmail.com 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

Re: MySQL HA

2018-07-04 Thread Alireza Eskandari
>> >> db.cloud.slaves=acs-db-02 > > >> >> > > >> >> cluster.node.IP= > > >> >> > > >> >> db.usage.autoReconnect=true > > >> >> > > >> >> db.cloud.host=acs-db-01 > > >> &

Re: MySQL HA

2017-12-18 Thread Alireza Eskandari
r 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 < > > >> >> > gabrasc...@gmail.com> wrote: > > >> >&g

Re: MySQL HA

2017-12-18 Thread Rafael Weingärtner
gt;> > >> >> >> Considering that you already configured replication and "my.cnf", > I > >> will > >> >> >> focus on the CloudSack db.properties file. > >> >> >> > >> >> >> When configuring Master-M

Re: MySQL HA

2017-12-18 Thread Alireza Eskandari
t;> >> >> db.cloud.slaves=acs-db-02 >> >> >> >> >> >> cluster.node.IP= >> >> >> >> >> >> db.usage.autoReconnect=true >> >> >> >> >> >> db.cloud.host=acs-db-01 >> >> >&

Re: MySQL HA

2017-12-18 Thread L Radhakrishna Rao
ct=true > > >> >> > > >> >> db.cloud.host=acs-db-01 > > >> >> db.usage.host=acs-db-01 > > >> >> > > >> >> #db.ha.loadBalanceStrategy=com.mysql.jdbc. > SequentialBalanceStrategy > > >> &g

Re: MySQL HA

2017-12-18 Thread Rafael Weingärtner
a.loadBalanceStrategy=com.mysql.jdbc.SequentialBalanceStrategy > >> >> db.ha.loadBalanceStrategy=com.cloud.utils.db.StaticStrategy > >> >> > >> >> db.cloud.failOverReadOnly=false > >> >> db.usage.slaves=acs-db-02 > >> >> ---

Re: MySQL HA

2017-12-16 Thread Alireza Eskandari
sage.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.slave

Re: MySQL HA

2017-12-16 Thread Rafael Weingärtner
> >> > >> "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

Re: MySQL HA

2017-12-15 Thread Alireza Eskandari
gt; >> "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 >> C

Re: MySQL HA

2017-12-12 Thread Rafael Weingärtner
nfigured 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-plu

Re: MySQL HA

2017-12-12 Thread Gabriel Beims Bräscher
o 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

Re: MySQL HA

2017-12-12 Thread Alireza Eskandari
I have opened a new jira ticket about this problem: https://issues.apache.org/jira/browse/CLOUDSTACK-10186

MySQL HA

2017-12-11 Thread Alireza Eskandari
Hi I want to use MySQL HA for CloudStack. I have installed cloudstack-mysql-ha package and configure db.properties with appropriate options, but when I stop the first mysql node, I this error frequently: 2017-12-11 15:13:17,146 WARN [c.c.c.d.ManagementServerHostDaoImpl] (Cluster-Heartbeat-1:ctx

Re: cloud spec for mysql-ha connector (was: off list)

2014-07-02 Thread sebgoa
>> I had an offline discussion about a classloader problem [1] and an >> analog discussion with Hugo. It seems we want to create an extra rpm >> that must be installed when mysql ha is required. This will be >> specified in the cloud.spec file and will result in an extra packag

Re: cloud spec for mysql-ha connector (was: off list)

2014-06-18 Thread Daan Hoogland
ugo. It seems we want to create an extra rpm > that must be installed when mysql ha is required. This will be > specified in the cloud.spec file and will result in an extra package > when -Dnoredist is used. On installation this would have to > specifically be installed along with the rest

cloud spec for mysql-ha connector (was: off list)

2014-06-18 Thread Daan Hoogland
H devs, I had an offline discussion about a classloader problem [1] and an analog discussion with Hugo. It seems we want to create an extra rpm that must be installed when mysql ha is required. This will be specified in the cloud.spec file and will result in an extra package when -Dnoredist is

Re: [4.4] mysql-ha POM error

2014-03-28 Thread Hugo Trippaers
Fixed. Cheers, Hugo On 28 mrt. 2014, at 05:48, Damoder Reddy wrote: > Paul, > > We have seen this issue while doing maven build on Red Hat Linux 6.2 and > Fedora .. this was due to the wrong relative path in > plugins/database/mysql-ha/pom.xml as mentioned by you. > &

RE: [4.4] mysql-ha POM error

2014-03-27 Thread Damoder Reddy
Paul, We have seen this issue while doing maven build on Red Hat Linux 6.2 and Fedora .. this was due to the wrong relative path in plugins/database/mysql-ha/pom.xml as mentioned by you. This got fixed in the commit mentioned by Ilya (https://git-wip-us.apache.org/repos/asf?p=cloudstack.git

Re: [4.4] mysql-ha POM error

2014-03-27 Thread ilya musayev
Paul, If no response comes thru, i'd say work your way backwards and see what changed. Here is an example, perhaps Hugo would know, since he attempted to fix it 13 days ago. https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;a=history;f=plugins/database/mysql-ha/pom.

[4.4] mysql-ha POM error

2014-03-27 Thread Paul Angus
I'm trying to build 4.4 noredist, but it's failing to build with the following error: [ERROR] The project org.apache.cloudstack:cloud-plugin-database-mysqlha:4.4.0-SNAPSHOT (/usr/local/4.4/cloudstack/dist/rpmbuild/BUILD/cloudstack-4.4.0-SNAPSHOT/plugins/database/mysql-ha/pom.x