Re: MySQL HA

2018-07-05 Thread Alireza Eskandari
. > > > - 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: MySQ

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
gt; >> db.cloud.slaves=acs-db-02 > > >> >> > > >> >> cluster.node.IP= > > >> >> > > >> >> db.usage.autoReconnect=true > > >> >> > > >> >> db.cloud.host=acs-db-01 > > >> >&g

Re: MySQL HA

2017-12-18 Thread Alireza Eskandari
7 at 8:56 AM, Gabriel Beims Bräscher < > > >> >> > gabrasc...@gmail.com> wrote: > > >> >> > > > >> >> >> Hi Alireza, > > >> >> >> > > >> >> >> I have production environment

Re: MySQL HA

2017-12-18 Thread Rafael Weingärtner
; focus on the CloudSack db.properties file. > >> >> >> > >> >> >> When configuring Master-Master replication, you should have at > >> >> >> /etc/cloudstack/management/db.properties something like: > >> >> >

Re: MySQL HA

2017-12-18 Thread Alireza Eskandari
db.usage.autoReconnect=true >> >> >> >> >> >> db.cloud.host=acs-db-01 >> >> >> db.usage.host=acs-db-01 >> >> >> >> >> >> #db.ha.loadBalanceStrategy=com.mysql.jdbc.SequentialBalanceStrategy >> >>

Re: MySQL HA

2017-12-18 Thread L Radhakrishna Rao
> >> cluster.node.IP= > > >> >> > > >> >> db.usage.autoReconnect=true > > >> >> > > >> >> db.cloud.host=acs-db-01 > > >> >> db.usage.host=acs-db-0

Re: MySQL HA

2017-12-18 Thread Rafael Weingärtner
t=acs-db-01 > >> >> db.usage.host=acs-db-01 > >> >> > >> >> #db.ha.loadBalanceStrategy=com.mysql.jdbc.SequentialBalanceStrategy > >> >> db.ha.loadBalanceStrategy=com.cloud.utils.db.StaticStrategy > >&

Re: MySQL HA

2017-12-16 Thread Alireza Eskandari
Strategy >> >> >> >> db.cloud.failOverReadOnly=false >> >> db.usage.slaves=acs-db-02 >> >> - >> >> >> >> "db.ha.loadBalanceStrategy" is confiugured with the heuristic >> >> "com.cloud

Re: MySQL HA

2017-12-16 Thread Rafael Weingärtner
b.usage.slaves=acs-db-02 > >> - > >> > >> "db.ha.loadBalanceStrategy" is confiugured with the heuristic > >> "com.cloud.utils.db.StaticStrategy" > >> > >> "db.ha.en

Re: MySQL HA

2017-12-15 Thread Alireza Eskandari
tils.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 dif

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
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 used

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

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

2014-06-18 Thread Daan Hoogland
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 used. On installation this would have to specifically be installed along with the rest if so desired

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 damoder.re...@citrix.com 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

[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.xml) has 1

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.xml;h

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