Re: MySQL HA
Ok, I'm going to deploy a lab for cs 4.11 in next few days and test the scenario on it. Thanks On Thu, Jul 5, 2018, 12:12 Rohit Yadav wrote: > Alireza, > > > Can you test against 4.11.1.0? Likely, Rafael suggestion may be around the > recent release than older 4.9/4.10 releases. > > > - 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: 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 Rafael Weingärtner < > rafaelweingart...@gmail.com> > wrote: > > > Here is a fix: > > > > > https://www.dropbox.com/s/kgakhs3v05uz88x/cloud-framework-cluster-4.9.3.0.jar?dl=1 > > You need to replace this jar file in CloudStack installation. You should > > also backup the original jar and restore it as soon as you finish > testing. > > To replace the JARs, you need to stop ACS, and just then start it. > > > > If everything works fine, I will open a PR against master, and with a bit > > of luck we can push it into 4.11 > > > > On Sat, Dec 16, 2017 at 8:03 AM, Alireza Eskandari < > > astro.alir...@gmail.com> > > wrote: > > > > > I'm using CS 4.9.3.0-shapeblue0 > > > > > > On Sat, Dec 16, 2017 at 12:49 PM, Rafael Weingärtner > > > wrote: > > > > Awesome! > > > > I found one method that might seem the cause of the problem. > > > > What is the version of ACS that you are using? > > > > > > > > On Sat, Dec 16, 2017 at 4:10 AM, Alireza Eskandari < > > > astro.alir...@gmail.com> > > > > wrote: > > > > > > > >> Hi > > > >> > > > >> Gabriel, > > > >> My configuration is same as your suggestion, but I get the errors. > > > >> > > > >> Rafael, > > > >> You are right. I confirm that CS works normally but I get those > > > warnings. > > > >> I would make me happy to help you for this fix :) > > > >> > > > >> > > > >> On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner > > > >> wrote: > > > >> > Alireza, > > > >> > This is a warning and should not cause you much trouble. I have > been > > > >> trying > > > >> > to pin point this problem for 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: > > > >> > > > > >> >> Hi Alireza, > > > >> >> > > > >> >> I have production environments with Master to Master replication > > and > > > >> >> we have no problems. We may need more details of your > > configuration. > > > >> >> Have you configured the slave database? Are you sure that you > > > configured > > > >> >> correctly the ha heuristic? > > > >> >> > > > >> >> Considering that you already configured replication and > "my.cnf", I > > > will > > > >> >> focus on the CloudSack db.properties file. > > > >> >> > > > >> >> When configuring Master-Master replication, you should have at > > > >> >> /etc/cloudstack/management/db.properties something like: > > > >> >> - > > > >> >> db.cloud.autoReconnectForPools=true > > > >> >> > > > >> >> #High Availability And Cluster Properties > > > >> >> db.ha.enabled=true > > > >> >> > > > >> >> db.cloud.queriesBeforeRetryMaster=5000 > > > >> >> db.usage.failOverReadOnly=false > > > >> >> db.cloud.slaves=acs-db-02 > > > >> >> > > > >> >> cluster.node.IP= > > > >> >> > > > >> >> db.usage.autoReconnect=true > > > >> >> > > > >> >> db.cloud.host=acs-db-01 > > >
Re: MySQL HA
Alireza, Can you test against 4.11.1.0? Likely, Rafael suggestion may be around the recent release than older 4.9/4.10 releases. - 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: 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 Rafael Weingärtner wrote: > Here is a fix: > > https://www.dropbox.com/s/kgakhs3v05uz88x/cloud-framework-cluster-4.9.3.0.jar?dl=1 > You need to replace this jar file in CloudStack installation. You should > also backup the original jar and restore it as soon as you finish testing. > To replace the JARs, you need to stop ACS, and just then start it. > > If everything works fine, I will open a PR against master, and with a bit > of luck we can push it into 4.11 > > On Sat, Dec 16, 2017 at 8:03 AM, Alireza Eskandari < > astro.alir...@gmail.com> > wrote: > > > I'm using CS 4.9.3.0-shapeblue0 > > > > On Sat, Dec 16, 2017 at 12:49 PM, Rafael Weingärtner > > wrote: > > > Awesome! > > > I found one method that might seem the cause of the problem. > > > What is the version of ACS that you are using? > > > > > > On Sat, Dec 16, 2017 at 4:10 AM, Alireza Eskandari < > > astro.alir...@gmail.com> > > > wrote: > > > > > >> Hi > > >> > > >> Gabriel, > > >> My configuration is same as your suggestion, but I get the errors. > > >> > > >> Rafael, > > >> You are right. I confirm that CS works normally but I get those > > warnings. > > >> I would make me happy to help you for this fix :) > > >> > > >> > > >> On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner > > >> wrote: > > >> > Alireza, > > >> > This is a warning and should not cause you much trouble. I have been > > >> trying > > >> > to pin point this problem for 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: > > >> > > > >> >> Hi Alireza, > > >> >> > > >> >> I have production environments with Master to Master replication > and > > >> >> we have no problems. We may need more details of your > configuration. > > >> >> Have you configured the slave database? Are you sure that you > > configured > > >> >> correctly the ha heuristic? > > >> >> > > >> >> Considering that you already configured replication and "my.cnf", I > > will > > >> >> focus on the CloudSack db.properties file. > > >> >> > > >> >> When configuring Master-Master replication, you should have at > > >> >> /etc/cloudstack/management/db.properties something like: > > >> >> - > > >> >> db.cloud.autoReconnectForPools=true > > >> >> > > >> >> #High Availability And Cluster Properties > > >> >> db.ha.enabled=true > > >> >> > > >> >> db.cloud.queriesBeforeRetryMaster=5000 > > >> >> db.usage.failOverReadOnly=false > > >> >> db.cloud.slaves=acs-db-02 > > >> >> > > >> >> cluster.node.IP= > > >> >> > > >> >> db.usage.autoReconnect=true > > >> >> > > >> >> db.cloud.host=acs-db-01 > > >> >> db.usage.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.slaves=acs-db-02 > > >> >> - > > >> >> > > >> >> "db.ha.loadBalanceStrategy" is confiugured with the heuristic > > >> >> "com.cloud.utils.db.StaticStrategy" > > >>
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 Rafael Weingärtner wrote: > Here is a fix: > > https://www.dropbox.com/s/kgakhs3v05uz88x/cloud-framework-cluster-4.9.3.0.jar?dl=1 > You need to replace this jar file in CloudStack installation. You should > also backup the original jar and restore it as soon as you finish testing. > To replace the JARs, you need to stop ACS, and just then start it. > > If everything works fine, I will open a PR against master, and with a bit > of luck we can push it into 4.11 > > On Sat, Dec 16, 2017 at 8:03 AM, Alireza Eskandari < > astro.alir...@gmail.com> > wrote: > > > I'm using CS 4.9.3.0-shapeblue0 > > > > On Sat, Dec 16, 2017 at 12:49 PM, Rafael Weingärtner > > wrote: > > > Awesome! > > > I found one method that might seem the cause of the problem. > > > What is the version of ACS that you are using? > > > > > > On Sat, Dec 16, 2017 at 4:10 AM, Alireza Eskandari < > > astro.alir...@gmail.com> > > > wrote: > > > > > >> Hi > > >> > > >> Gabriel, > > >> My configuration is same as your suggestion, but I get the errors. > > >> > > >> Rafael, > > >> You are right. I confirm that CS works normally but I get those > > warnings. > > >> I would make me happy to help you for this fix :) > > >> > > >> > > >> On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner > > >> wrote: > > >> > Alireza, > > >> > This is a warning and should not cause you much trouble. I have been > > >> trying > > >> > to pin point this problem for 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: > > >> > > > >> >> Hi Alireza, > > >> >> > > >> >> I have production environments with Master to Master replication > and > > >> >> we have no problems. We may need more details of your > configuration. > > >> >> Have you configured the slave database? Are you sure that you > > configured > > >> >> correctly the ha heuristic? > > >> >> > > >> >> Considering that you already configured replication and "my.cnf", I > > will > > >> >> focus on the CloudSack db.properties file. > > >> >> > > >> >> When configuring Master-Master replication, you should have at > > >> >> /etc/cloudstack/management/db.properties something like: > > >> >> - > > >> >> db.cloud.autoReconnectForPools=true > > >> >> > > >> >> #High Availability And Cluster Properties > > >> >> db.ha.enabled=true > > >> >> > > >> >> db.cloud.queriesBeforeRetryMaster=5000 > > >> >> db.usage.failOverReadOnly=false > > >> >> db.cloud.slaves=acs-db-02 > > >> >> > > >> >> cluster.node.IP= > > >> >> > > >> >> db.usage.autoReconnect=true > > >> >> > > >> >> db.cloud.host=acs-db-01 > > >> >> db.usage.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.slaves=acs-db-02 > > >> >> - > > >> >> > > >> >> "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 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 > > >> >> 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-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-database-mysqlha-4.9.3.0.jar > > >> >> /usr/share/cloudstack-mysql-ha/lib/ > > >> >> - > > >> >> > > >> >> Cheers, > > >> >> Gabriel. > > >> >> > > >> >> 2017-12-12 6:30 GMT-02:00 Alireza Eskandari < > astro.alir...@gmail.com > > >: > > >> >> > > >> >> > I have opened a new jira ticket about this problem: > > >> >> > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 > > >> >> > > > >> >> > > >> > > > >> > > > >> > > > >> > -- > > >> > Rafael Weingärtner > > >> > > > > > > > > > > > > -- > > > Rafael Weingärtner > > > > > > -- > Rafael Weingärtner >
Re: MySQL HA
> https://www.dropbox.com/s/kgakhs3v05uz88x/cloud- > > framework-cluster-4.9.3.0.jar?dl=1 > > > You need to replace this jar file in CloudStack installation. You > should > > > also backup the original jar and restore it as soon as you finish > > testing. > > > To replace the JARs, you need to stop ACS, and just then start it. > > > > > > If everything works fine, I will open a PR against master, and with a > bit > > > of luck we can push it into 4.11 > > > > > > On Sat, Dec 16, 2017 at 8:03 AM, Alireza Eskandari < > > astro.alir...@gmail.com> > > > wrote: > > > > > >> I'm using CS 4.9.3.0-shapeblue0 > > >> > > >> On Sat, Dec 16, 2017 at 12:49 PM, Rafael Weingärtner > > >> <rafaelweingart...@gmail.com> wrote: > > >> > Awesome! > > >> > I found one method that might seem the cause of the problem. > > >> > What is the version of ACS that you are using? > > >> > > > >> > On Sat, Dec 16, 2017 at 4:10 AM, Alireza Eskandari < > > >> astro.alir...@gmail.com> > > >> > wrote: > > >> > > > >> >> Hi > > >> >> > > >> >> Gabriel, > > >> >> My configuration is same as your suggestion, but I get the errors. > > >> >> > > >> >> Rafael, > > >> >> You are right. I confirm that CS works normally but I get those > > >> warnings. > > >> >> I would make me happy to help you for this fix :) > > >> >> > > >> >> > > >> >> On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner > > >> >> <rafaelweingart...@gmail.com> wrote: > > >> >> > Alireza, > > >> >> > This is a warning and should not cause you much trouble. I have > > been > > >> >> trying > > >> >> > to pin point this problem for 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: > > >> >> > > > >> >> >> Hi Alireza, > > >> >> >> > > >> >> >> I have production environments with Master to Master replication > > and > > >> >> >> we have no problems. We may need more details of your > > configuration. > > >> >> >> Have you configured the slave database? Are you sure that you > > >> configured > > >> >> >> correctly the ha heuristic? > > >> >> >> > > >> >> >> Considering that you already configured replication and > "my.cnf", > > I > > >> will > > >> >> >> focus on the CloudSack db.properties file. > > >> >> >> > > >> >> >> When configuring Master-Master replication, you should have at > > >> >> >> /etc/cloudstack/management/db.properties something like: > > >> >> >> - > > >> >> >> db.cloud.autoReconnectForPools=true > > >> >> >> > > >> >> >> #High Availability And Cluster Properties > > >> >> >> db.ha.enabled=true > > >> >> >> > > >> >> >> db.cloud.queriesBeforeRetryMaster=5000 > > >> >> >> db.usage.failOverReadOnly=false > > >> >> >> db.cloud.slaves=acs-db-02 > > >> >> >> > > >> >> >> cluster.node.IP= > > >> >> >> > > >> >> >> db.usage.autoReconnect=true > > >> >> >> > > >> >> >> db.cloud.host=acs-db-01 > > >> >> >> db.usage.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.slaves=acs-db-02 > > >> >> >> - > > >> >> >> > > >> >> >> "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 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 > > >> >> >> 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-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-database-mysqlha-4.9.3.0.jar > > >> >> >> /usr/share/cloudstack-mysql-ha/lib/ > > >> >> >> - > > >> >> >> > > >> >> >> Cheers, > > >> >> >> Gabriel. > > >> >> >> > > >> >> >> 2017-12-12 6:30 GMT-02:00 Alireza Eskandari < > > astro.alir...@gmail.com > > >> >: > > >> >> >> > > >> >> >> > I have opened a new jira ticket about this problem: > > >> >> >> > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 > > >> >> >> > > > >> >> >> > > >> >> > > > >> >> > > > >> >> > > > >> >> > -- > > >> >> > Rafael Weingärtner > > >> >> > > >> > > > >> > > > >> > > > >> > -- > > >> > Rafael Weingärtner > > >> > > > > > > > > > > > > -- > > > Rafael Weingärtner > > > > > > -- > Rafael Weingärtner >
Re: MySQL HA
ut I get those > >> warnings. > >> >> I would make me happy to help you for this fix :) > >> >> > >> >> > >> >> On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner > >> >> <rafaelweingart...@gmail.com> wrote: > >> >> > Alireza, > >> >> > This is a warning and should not cause you much trouble. I have > been > >> >> trying > >> >> > to pin point this problem for 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: > >> >> > > >> >> >> Hi Alireza, > >> >> >> > >> >> >> I have production environments with Master to Master replication > and > >> >> >> we have no problems. We may need more details of your > configuration. > >> >> >> Have you configured the slave database? Are you sure that you > >> configured > >> >> >> correctly the ha heuristic? > >> >> >> > >> >> >> Considering that you already configured replication and "my.cnf", > I > >> will > >> >> >> focus on the CloudSack db.properties file. > >> >> >> > >> >> >> When configuring Master-Master replication, you should have at > >> >> >> /etc/cloudstack/management/db.properties something like: > >> >> >> - > >> >> >> db.cloud.autoReconnectForPools=true > >> >> >> > >> >> >> #High Availability And Cluster Properties > >> >> >> db.ha.enabled=true > >> >> >> > >> >> >> db.cloud.queriesBeforeRetryMaster=5000 > >> >> >> db.usage.failOverReadOnly=false > >> >> >> db.cloud.slaves=acs-db-02 > >> >> >> > >> >> >> cluster.node.IP= > >> >> >> > >> >> >> db.usage.autoReconnect=true > >> >> >> > >> >> >> db.cloud.host=acs-db-01 > >> >> >> db.usage.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.slaves=acs-db-02 > >> >> >> - > >> >> >> > >> >> >> "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 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 > >> >> >> 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-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-database-mysqlha-4.9.3.0.jar > >> >> >> /usr/share/cloudstack-mysql-ha/lib/ > >> >> >> - > >> >> >> > >> >> >> Cheers, > >> >> >> Gabriel. > >> >> >> > >> >> >> 2017-12-12 6:30 GMT-02:00 Alireza Eskandari < > astro.alir...@gmail.com > >> >: > >> >> >> > >> >> >> > I have opened a new jira ticket about this problem: > >> >> >> > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 > >> >> >> > > >> >> >> > >> >> > > >> >> > > >> >> > > >> >> > -- > >> >> > Rafael Weingärtner > >> >> > >> > > >> > > >> > > >> > -- > >> > Rafael Weingärtner > >> > > > > > > > > -- > > Rafael Weingärtner > -- Rafael Weingärtner
Re: MySQL HA
ies something like: >> >> >> - >> >> >> db.cloud.autoReconnectForPools=true >> >> >> >> >> >> #High Availability And Cluster Properties >> >> >> db.ha.enabled=true >> >> >> >> >> >> db.cloud.queriesBeforeRetryMaster=5000 >> >> >> db.usage.failOverReadOnly=false >> >> >> db.cloud.slaves=acs-db-02 >> >> >> >> >> >> cluster.node.IP= >> >> >> >> >> >> db.usage.autoReconnect=true >> >> >> >> >> >> db.cloud.host=acs-db-01 >> >> >> db.usage.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.slaves=acs-db-02 >> >> >> - >> >> >> >> >> >> "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 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 >> >> >> 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-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-database-mysqlha-4.9.3.0.jar >> >> >> /usr/share/cloudstack-mysql-ha/lib/ >> >> >> - >> >> >> >> >> >> Cheers, >> >> >> Gabriel. >> >> >> >> >> >> 2017-12-12 6:30 GMT-02:00 Alireza Eskandari <astro.alir...@gmail.com >> >: >> >> >> >> >> >> > I have opened a new jira ticket about this problem: >> >> >> > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 >> >> >> > >> >> >> >> >> > >> >> > >> >> > >> >> > -- >> >> > Rafael Weingärtner >> >> >> > >> > >> > >> > -- >> > Rafael Weingärtner >> > > > > -- > Rafael Weingärtner
Re: MySQL HA
On 18-Dec-2017 4:03 PM, "Rafael Weingärtner" <rafaelweingart...@gmail.com> wrote: > Here is a fix: > https://www.dropbox.com/s/kgakhs3v05uz88x/cloud- > framework-cluster-4.9.3.0.jar?dl=1 > You need to replace this jar file in CloudStack installation. You should > also backup the original jar and restore it as soon as you finish testing. > To replace the JARs, you need to stop ACS, and just then start it. > > If everything works fine, I will open a PR against master, and with a bit > of luck we can push it into 4.11 > > On Sat, Dec 16, 2017 at 8:03 AM, Alireza Eskandari < > astro.alir...@gmail.com> > wrote: > > > I'm using CS 4.9.3.0-shapeblue0 > > > > On Sat, Dec 16, 2017 at 12:49 PM, Rafael Weingärtner > > <rafaelweingart...@gmail.com> wrote: > > > Awesome! > > > I found one method that might seem the cause of the problem. > > > What is the version of ACS that you are using? > > > > > > On Sat, Dec 16, 2017 at 4:10 AM, Alireza Eskandari < > > astro.alir...@gmail.com> > > > wrote: > > > > > >> Hi > > >> > > >> Gabriel, > > >> My configuration is same as your suggestion, but I get the errors. > > >> > > >> Rafael, > > >> You are right. I confirm that CS works normally but I get those > > warnings. > > >> I would make me happy to help you for this fix :) > > >> > > >> > > >> On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner > > >> <rafaelweingart...@gmail.com> wrote: > > >> > Alireza, > > >> > This is a warning and should not cause you much trouble. I have been > > >> trying > > >> > to pin point this problem for 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: > > >> > > > >> >> Hi Alireza, > > >> >> > > >> >> I have production environments with Master to Master replication > and > > >> >> we have no problems. We may need more details of your > configuration. > > >> >> Have you configured the slave database? Are you sure that you > > configured > > >> >> correctly the ha heuristic? > > >> >> > > >> >> Considering that you already configured replication and "my.cnf", I > > will > > >> >> focus on the CloudSack db.properties file. > > >> >> > > >> >> When configuring Master-Master replication, you should have at > > >> >> /etc/cloudstack/management/db.properties something like: > > >> >> - > > >> >> db.cloud.autoReconnectForPools=true > > >> >> > > >> >> #High Availability And Cluster Properties > > >> >> db.ha.enabled=true > > >> >> > > >> >> db.cloud.queriesBeforeRetryMaster=5000 > > >> >> db.usage.failOverReadOnly=false > > >> >> db.cloud.slaves=acs-db-02 > > >> >> > > >> >> cluster.node.IP= > > >> >> > > >> >> db.usage.autoReconnect=true > > >> >> > > >> >> db.cloud.host=acs-db-01 > > >> >> db.usage.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.slaves=acs-db-02 > > >> >> - > > >> >> > > >> >> "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 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 > > >> >> 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-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-database-mysqlha-4.9.3.0.jar > > >> >> /usr/share/cloudstack-mysql-ha/lib/ > > >> >> - > > >> >> > > >> >> Cheers, > > >> >> Gabriel. > > >> >> > > >> >> 2017-12-12 6:30 GMT-02:00 Alireza Eskandari < > astro.alir...@gmail.com > > >: > > >> >> > > >> >> > I have opened a new jira ticket about this problem: > > >> >> > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 > > >> >> > > > >> >> > > >> > > > >> > > > >> > > > >> > -- > > >> > Rafael Weingärtner > > >> > > > > > > > > > > > > -- > > > Rafael Weingärtner > > > > > > -- > Rafael Weingärtner >
Re: MySQL HA
Here is a fix: https://www.dropbox.com/s/kgakhs3v05uz88x/cloud-framework-cluster-4.9.3.0.jar?dl=1 You need to replace this jar file in CloudStack installation. You should also backup the original jar and restore it as soon as you finish testing. To replace the JARs, you need to stop ACS, and just then start it. If everything works fine, I will open a PR against master, and with a bit of luck we can push it into 4.11 On Sat, Dec 16, 2017 at 8:03 AM, Alireza Eskandari <astro.alir...@gmail.com> wrote: > I'm using CS 4.9.3.0-shapeblue0 > > On Sat, Dec 16, 2017 at 12:49 PM, Rafael Weingärtner > <rafaelweingart...@gmail.com> wrote: > > Awesome! > > I found one method that might seem the cause of the problem. > > What is the version of ACS that you are using? > > > > On Sat, Dec 16, 2017 at 4:10 AM, Alireza Eskandari < > astro.alir...@gmail.com> > > wrote: > > > >> Hi > >> > >> Gabriel, > >> My configuration is same as your suggestion, but I get the errors. > >> > >> Rafael, > >> You are right. I confirm that CS works normally but I get those > warnings. > >> I would make me happy to help you for this fix :) > >> > >> > >> On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner > >> <rafaelweingart...@gmail.com> wrote: > >> > Alireza, > >> > This is a warning and should not cause you much trouble. I have been > >> trying > >> > to pin point this problem for 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: > >> > > >> >> Hi Alireza, > >> >> > >> >> I have production environments with Master to Master replication and > >> >> we have no problems. We may need more details of your configuration. > >> >> Have you configured the slave database? Are you sure that you > configured > >> >> correctly the ha heuristic? > >> >> > >> >> Considering that you already configured replication and "my.cnf", I > will > >> >> focus on the CloudSack db.properties file. > >> >> > >> >> When configuring Master-Master replication, you should have at > >> >> /etc/cloudstack/management/db.properties something like: > >> >> - > >> >> db.cloud.autoReconnectForPools=true > >> >> > >> >> #High Availability And Cluster Properties > >> >> db.ha.enabled=true > >> >> > >> >> db.cloud.queriesBeforeRetryMaster=5000 > >> >> db.usage.failOverReadOnly=false > >> >> db.cloud.slaves=acs-db-02 > >> >> > >> >> cluster.node.IP= > >> >> > >> >> db.usage.autoReconnect=true > >> >> > >> >> db.cloud.host=acs-db-01 > >> >> db.usage.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.slaves=acs-db-02 > >> >> - > >> >> > >> >> "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 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 > >> >> 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-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-database-mysqlha-4.9.3.0.jar > >> >> /usr/share/cloudstack-mysql-ha/lib/ > >> >> - > >> >> > >> >> Cheers, > >> >> Gabriel. > >> >> > >> >> 2017-12-12 6:30 GMT-02:00 Alireza Eskandari <astro.alir...@gmail.com > >: > >> >> > >> >> > I have opened a new jira ticket about this problem: > >> >> > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 > >> >> > > >> >> > >> > > >> > > >> > > >> > -- > >> > Rafael Weingärtner > >> > > > > > > > > -- > > Rafael Weingärtner > -- Rafael Weingärtner
Re: MySQL HA
I'm using CS 4.9.3.0-shapeblue0 On Sat, Dec 16, 2017 at 12:49 PM, Rafael Weingärtner <rafaelweingart...@gmail.com> wrote: > Awesome! > I found one method that might seem the cause of the problem. > What is the version of ACS that you are using? > > On Sat, Dec 16, 2017 at 4:10 AM, Alireza Eskandari <astro.alir...@gmail.com> > wrote: > >> Hi >> >> Gabriel, >> My configuration is same as your suggestion, but I get the errors. >> >> Rafael, >> You are right. I confirm that CS works normally but I get those warnings. >> I would make me happy to help you for this fix :) >> >> >> On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner >> <rafaelweingart...@gmail.com> wrote: >> > Alireza, >> > This is a warning and should not cause you much trouble. I have been >> trying >> > to pin point this problem for 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: >> > >> >> Hi Alireza, >> >> >> >> I have production environments with Master to Master replication and >> >> we have no problems. We may need more details of your configuration. >> >> Have you configured the slave database? Are you sure that you configured >> >> correctly the ha heuristic? >> >> >> >> Considering that you already configured replication and "my.cnf", I will >> >> focus on the CloudSack db.properties file. >> >> >> >> When configuring Master-Master replication, you should have at >> >> /etc/cloudstack/management/db.properties something like: >> >> - >> >> db.cloud.autoReconnectForPools=true >> >> >> >> #High Availability And Cluster Properties >> >> db.ha.enabled=true >> >> >> >> db.cloud.queriesBeforeRetryMaster=5000 >> >> db.usage.failOverReadOnly=false >> >> db.cloud.slaves=acs-db-02 >> >> >> >> cluster.node.IP= >> >> >> >> db.usage.autoReconnect=true >> >> >> >> db.cloud.host=acs-db-01 >> >> db.usage.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.slaves=acs-db-02 >> >> - >> >> >> >> "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 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 >> >> 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-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-database-mysqlha-4.9.3.0.jar >> >> /usr/share/cloudstack-mysql-ha/lib/ >> >> - >> >> >> >> Cheers, >> >> Gabriel. >> >> >> >> 2017-12-12 6:30 GMT-02:00 Alireza Eskandari <astro.alir...@gmail.com>: >> >> >> >> > I have opened a new jira ticket about this problem: >> >> > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 >> >> > >> >> >> > >> > >> > >> > -- >> > Rafael Weingärtner >> > > > > -- > Rafael Weingärtner
Re: MySQL HA
Awesome! I found one method that might seem the cause of the problem. What is the version of ACS that you are using? On Sat, Dec 16, 2017 at 4:10 AM, Alireza Eskandari <astro.alir...@gmail.com> wrote: > Hi > > Gabriel, > My configuration is same as your suggestion, but I get the errors. > > Rafael, > You are right. I confirm that CS works normally but I get those warnings. > I would make me happy to help you for this fix :) > > > On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner > <rafaelweingart...@gmail.com> wrote: > > Alireza, > > This is a warning and should not cause you much trouble. I have been > trying > > to pin point this problem for 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: > > > >> Hi Alireza, > >> > >> I have production environments with Master to Master replication and > >> we have no problems. We may need more details of your configuration. > >> Have you configured the slave database? Are you sure that you configured > >> correctly the ha heuristic? > >> > >> Considering that you already configured replication and "my.cnf", I will > >> focus on the CloudSack db.properties file. > >> > >> When configuring Master-Master replication, you should have at > >> /etc/cloudstack/management/db.properties something like: > >> - > >> db.cloud.autoReconnectForPools=true > >> > >> #High Availability And Cluster Properties > >> db.ha.enabled=true > >> > >> db.cloud.queriesBeforeRetryMaster=5000 > >> db.usage.failOverReadOnly=false > >> db.cloud.slaves=acs-db-02 > >> > >> cluster.node.IP= > >> > >> db.usage.autoReconnect=true > >> > >> db.cloud.host=acs-db-01 > >> db.usage.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.slaves=acs-db-02 > >> - > >> > >> "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 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 > >> 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-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-database-mysqlha-4.9.3.0.jar > >> /usr/share/cloudstack-mysql-ha/lib/ > >> - > >> > >> Cheers, > >> Gabriel. > >> > >> 2017-12-12 6:30 GMT-02:00 Alireza Eskandari <astro.alir...@gmail.com>: > >> > >> > I have opened a new jira ticket about this problem: > >> > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 > >> > > >> > > > > > > > > -- > > Rafael Weingärtner > -- Rafael Weingärtner
Re: MySQL HA
Hi Gabriel, My configuration is same as your suggestion, but I get the errors. Rafael, You are right. I confirm that CS works normally but I get those warnings. I would make me happy to help you for this fix :) On Tue, Dec 12, 2017 at 3:30 PM, Rafael Weingärtner <rafaelweingart...@gmail.com> wrote: > Alireza, > This is a warning and should not cause you much trouble. I have been trying > to pin point this problem for 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: > >> Hi Alireza, >> >> I have production environments with Master to Master replication and >> we have no problems. We may need more details of your configuration. >> Have you configured the slave database? Are you sure that you configured >> correctly the ha heuristic? >> >> Considering that you already configured replication and "my.cnf", I will >> focus on the CloudSack db.properties file. >> >> When configuring Master-Master replication, you should have at >> /etc/cloudstack/management/db.properties something like: >> - >> db.cloud.autoReconnectForPools=true >> >> #High Availability And Cluster Properties >> db.ha.enabled=true >> >> db.cloud.queriesBeforeRetryMaster=5000 >> db.usage.failOverReadOnly=false >> db.cloud.slaves=acs-db-02 >> >> cluster.node.IP= >> >> db.usage.autoReconnect=true >> >> db.cloud.host=acs-db-01 >> db.usage.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.slaves=acs-db-02 >> - >> >> "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 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 >> 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-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-database-mysqlha-4.9.3.0.jar >> /usr/share/cloudstack-mysql-ha/lib/ >> - >> >> Cheers, >> Gabriel. >> >> 2017-12-12 6:30 GMT-02:00 Alireza Eskandari <astro.alir...@gmail.com>: >> >> > I have opened a new jira ticket about this problem: >> > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 >> > >> > > > > -- > Rafael Weingärtner
Re: MySQL HA
Alireza, This is a warning and should not cause you much trouble. I have been trying to pin point this problem for 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: > Hi Alireza, > > I have production environments with Master to Master replication and > we have no problems. We may need more details of your configuration. > Have you configured the slave database? Are you sure that you configured > correctly the ha heuristic? > > Considering that you already configured replication and "my.cnf", I will > focus on the CloudSack db.properties file. > > When configuring Master-Master replication, you should have at > /etc/cloudstack/management/db.properties something like: > - > db.cloud.autoReconnectForPools=true > > #High Availability And Cluster Properties > db.ha.enabled=true > > db.cloud.queriesBeforeRetryMaster=5000 > db.usage.failOverReadOnly=false > db.cloud.slaves=acs-db-02 > > cluster.node.IP= > > db.usage.autoReconnect=true > > db.cloud.host=acs-db-01 > db.usage.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.slaves=acs-db-02 > - > > "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 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 > 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-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-database-mysqlha-4.9.3.0.jar > /usr/share/cloudstack-mysql-ha/lib/ > - > > Cheers, > Gabriel. > > 2017-12-12 6:30 GMT-02:00 Alireza Eskandari <astro.alir...@gmail.com>: > > > I have opened a new jira ticket about this problem: > > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 > > > -- Rafael Weingärtner
Re: MySQL HA
Hi Alireza, I have production environments with Master to Master replication and we have no problems. We may need more details of your configuration. Have you configured the slave database? Are you sure that you configured correctly the ha heuristic? Considering that you already configured replication and "my.cnf", I will focus on the CloudSack db.properties file. When configuring Master-Master replication, you should have at /etc/cloudstack/management/db.properties something like: - db.cloud.autoReconnectForPools=true #High Availability And Cluster Properties db.ha.enabled=true db.cloud.queriesBeforeRetryMaster=5000 db.usage.failOverReadOnly=false db.cloud.slaves=acs-db-02 cluster.node.IP= db.usage.autoReconnect=true db.cloud.host=acs-db-01 db.usage.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.slaves=acs-db-02 - "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 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 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-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-database-mysqlha-4.9.3.0.jar /usr/share/cloudstack-mysql-ha/lib/ - Cheers, Gabriel. 2017-12-12 6:30 GMT-02:00 Alireza Eskandari <astro.alir...@gmail.com>: > I have opened a new jira ticket about this problem: > https://issues.apache.org/jira/browse/CLOUDSTACK-10186 >
Re: MySQL HA
I have opened a new jira ticket about this problem: https://issues.apache.org/jira/browse/CLOUDSTACK-10186
MySQL HA
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-aa0c96da) (logid:ee470520) Unexpected exception, com.cloud.utils.exception.CloudRuntimeException: No database selected for the transaction at com.cloud.utils.db.TransactionLegacy.getConnection(TransactionLegacy.java:580) at com.cloud.utils.db.TransactionLegacy.prepareStatement(TransactionLegacy.java:467) at com.cloud.utils.db.TransactionLegacy.prepareAutoCloseStatement(TransactionLegacy.java:460) at com.cloud.cluster.dao.ManagementServerHostDaoImpl.update(ManagementServerHostDaoImpl.java:134) at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy203.update(Unknown Source) at com.cloud.cluster.ClusterManagerImpl$4.runInContext(ClusterManagerImpl.java:554) at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) at org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748)
Re: cloud spec for mysql-ha connector (was: off list)
On Jun 18, 2014, at 1:51 PM, Daan Hoogland daan.hoogl...@gmail.com wrote: My link to the issue is wrong*^%%(*(*@#$ it should be [1] https://issues.apache.org/jira/browse/CLOUDSTACK-6892 On Wed, Jun 18, 2014 at 1:49 PM, Daan Hoogland daan.hoogl...@gmail.com wrote: 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 used. On installation this would have to specifically be installed along with the rest if so desired. A similar construct has to be devised for debian and windows installations. Can the respective gurus in those fields look at that? thanks, Kicking this again, to see if there is something that can be done for 4.3.1 and 4.4 ? [1] https://issues.apache.org/jira/browse/CLOUDSTACK-6928 On Wed, Jun 18, 2014 at 11:50 AM, Damoder Reddy damoder.re...@citrix.com wrote: Ok I forgot the DEB builds. To satisfy both, this should be included in catalina.properties.in. But only question I have is how do we change it for each version and taking care of upgrades as well. Thanks Regards Damodar/ -Original Message- From: Daan Hoogland [mailto:daan.hoogl...@gmail.com] Sent: Wednesday, June 18, 2014 3:10 PM To: Damoder Reddy Cc: sebgoa; Adrian Lewis Subject: Re: off list But only for the noredist version? and how about the deb version? On Wed, Jun 18, 2014 at 11:34 AM, Damoder Reddy damoder.re...@citrix.com wrote: We can put this step as part of rpm creation in cloud.spec file. Thanks Regards Damodar/ -Original Message- From: Daan Hoogland [mailto:daan.hoogl...@gmail.com] Sent: Wednesday, June 18, 2014 2:59 PM To: Damoder Reddy Cc: sebgoa; Adrian Lewis Subject: Re: off list The 'just' in 'Just put a symbolic link' implies a install instruction, does it? Or can we automate this step? On Wed, Jun 18, 2014 at 11:16 AM, Damoder Reddy damoder.re...@citrix.com wrote: Hi, There are 2 solutions. one either change the catalina.properties to include strategy in the common.loader as suggested in another thread mail OR Just put a symbolic link to the jar file inside /usr/share/tomcat6/lib as this path is already loaded by common.loader (common.loader=${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*.jar,/usr/share/java/mysql-connector-java.jar). I think 2nd option is better instead of 1st one. Thanks Regards Damodar/ -Original Message- From: Daan Hoogland [mailto:daan.hoogl...@gmail.com] Sent: Wednesday, June 18, 2014 2:37 PM To: sebgoa Cc: Damoder Reddy; Adrian Lewis Subject: Re: off list had Adrians address wrong -- Forwarded message -- From: Daan Hoogland daan.hoogl...@gmail.com Date: Wed, Jun 18, 2014 at 10:42 AM Subject: Re: off list To: sebgoa run...@gmail.com Cc: Damoder Reddy damoder.re...@citrix.com, Adrian Lewis adr...@alsiconsulting.co.uk I had a quick look. it doesn't seem a coding issue but a configuration/packaging issue. the file catalina.properties.in must be adjusted for this. There are two in the project. One for the ui, which I think won't need to be touched and one for the server. Damoder Reddy helped Adrien on this. cc'ing him and Adrien in now. @Damoder: can you confirm that we need to adjust the common.loader property in catalina.properties.in for CLOUDSTACK-6892? This way we should be done according to Adrien. This should be done for 4.3, 4.4 and master! regards, On Wed, Jun 18, 2014 at 10:10 AM, sebgoa run...@gmail.com wrote: On Jun 18, 2014, at 10:06 AM, Daan Hoogland daan.hoogl...@gmail.com wrote: it is not implemented/solved. not in 4.4 or master. Is work on it done already? not clear from the ticket. I just don't know how to modify the catalina properties in the code. On Wed, Jun 18, 2014 at 10:04 AM, Daan Hoogland daan.hoogl...@gmail.com wrote: on it On Wed, Jun 18, 2014 at 9:05 AM, Sebastien Goasguen run...@gmail.com wrote: Hi Daan, Can you check this one: https://issues.apache.org/jira/browse/CLOUDSTACK-6892 it might apply to 4.4 and 4.3 and I no squat in java -- Daan -- Daan -- Daan -- Daan -- Daan -- Daan -- Daan -- Daan
cloud spec for mysql-ha connector (was: off list)
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 used. On installation this would have to specifically be installed along with the rest if so desired. A similar construct has to be devised for debian and windows installations. Can the respective gurus in those fields look at that? thanks, [1] https://issues.apache.org/jira/browse/CLOUDSTACK-6928 On Wed, Jun 18, 2014 at 11:50 AM, Damoder Reddy damoder.re...@citrix.com wrote: Ok I forgot the DEB builds. To satisfy both, this should be included in catalina.properties.in. But only question I have is how do we change it for each version and taking care of upgrades as well. Thanks Regards Damodar/ -Original Message- From: Daan Hoogland [mailto:daan.hoogl...@gmail.com] Sent: Wednesday, June 18, 2014 3:10 PM To: Damoder Reddy Cc: sebgoa; Adrian Lewis Subject: Re: off list But only for the noredist version? and how about the deb version? On Wed, Jun 18, 2014 at 11:34 AM, Damoder Reddy damoder.re...@citrix.com wrote: We can put this step as part of rpm creation in cloud.spec file. Thanks Regards Damodar/ -Original Message- From: Daan Hoogland [mailto:daan.hoogl...@gmail.com] Sent: Wednesday, June 18, 2014 2:59 PM To: Damoder Reddy Cc: sebgoa; Adrian Lewis Subject: Re: off list The 'just' in 'Just put a symbolic link' implies a install instruction, does it? Or can we automate this step? On Wed, Jun 18, 2014 at 11:16 AM, Damoder Reddy damoder.re...@citrix.com wrote: Hi, There are 2 solutions. one either change the catalina.properties to include strategy in the common.loader as suggested in another thread mail OR Just put a symbolic link to the jar file inside /usr/share/tomcat6/lib as this path is already loaded by common.loader (common.loader=${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*.jar,/usr/share/java/mysql-connector-java.jar). I think 2nd option is better instead of 1st one. Thanks Regards Damodar/ -Original Message- From: Daan Hoogland [mailto:daan.hoogl...@gmail.com] Sent: Wednesday, June 18, 2014 2:37 PM To: sebgoa Cc: Damoder Reddy; Adrian Lewis Subject: Re: off list had Adrians address wrong -- Forwarded message -- From: Daan Hoogland daan.hoogl...@gmail.com Date: Wed, Jun 18, 2014 at 10:42 AM Subject: Re: off list To: sebgoa run...@gmail.com Cc: Damoder Reddy damoder.re...@citrix.com, Adrian Lewis adr...@alsiconsulting.co.uk I had a quick look. it doesn't seem a coding issue but a configuration/packaging issue. the file catalina.properties.in must be adjusted for this. There are two in the project. One for the ui, which I think won't need to be touched and one for the server. Damoder Reddy helped Adrien on this. cc'ing him and Adrien in now. @Damoder: can you confirm that we need to adjust the common.loader property in catalina.properties.in for CLOUDSTACK-6892? This way we should be done according to Adrien. This should be done for 4.3, 4.4 and master! regards, On Wed, Jun 18, 2014 at 10:10 AM, sebgoa run...@gmail.com wrote: On Jun 18, 2014, at 10:06 AM, Daan Hoogland daan.hoogl...@gmail.com wrote: it is not implemented/solved. not in 4.4 or master. Is work on it done already? not clear from the ticket. I just don't know how to modify the catalina properties in the code. On Wed, Jun 18, 2014 at 10:04 AM, Daan Hoogland daan.hoogl...@gmail.com wrote: on it On Wed, Jun 18, 2014 at 9:05 AM, Sebastien Goasguen run...@gmail.com wrote: Hi Daan, Can you check this one: https://issues.apache.org/jira/browse/CLOUDSTACK-6892 it might apply to 4.4 and 4.3 and I no squat in java -- Daan -- Daan -- Daan -- Daan -- Daan -- Daan -- Daan
Re: cloud spec for mysql-ha connector (was: off list)
My link to the issue is wrong*^%%(*(*@#$ it should be [1] https://issues.apache.org/jira/browse/CLOUDSTACK-6892 On Wed, Jun 18, 2014 at 1:49 PM, Daan Hoogland daan.hoogl...@gmail.com wrote: 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 used. On installation this would have to specifically be installed along with the rest if so desired. A similar construct has to be devised for debian and windows installations. Can the respective gurus in those fields look at that? thanks, [1] https://issues.apache.org/jira/browse/CLOUDSTACK-6928 On Wed, Jun 18, 2014 at 11:50 AM, Damoder Reddy damoder.re...@citrix.com wrote: Ok I forgot the DEB builds. To satisfy both, this should be included in catalina.properties.in. But only question I have is how do we change it for each version and taking care of upgrades as well. Thanks Regards Damodar/ -Original Message- From: Daan Hoogland [mailto:daan.hoogl...@gmail.com] Sent: Wednesday, June 18, 2014 3:10 PM To: Damoder Reddy Cc: sebgoa; Adrian Lewis Subject: Re: off list But only for the noredist version? and how about the deb version? On Wed, Jun 18, 2014 at 11:34 AM, Damoder Reddy damoder.re...@citrix.com wrote: We can put this step as part of rpm creation in cloud.spec file. Thanks Regards Damodar/ -Original Message- From: Daan Hoogland [mailto:daan.hoogl...@gmail.com] Sent: Wednesday, June 18, 2014 2:59 PM To: Damoder Reddy Cc: sebgoa; Adrian Lewis Subject: Re: off list The 'just' in 'Just put a symbolic link' implies a install instruction, does it? Or can we automate this step? On Wed, Jun 18, 2014 at 11:16 AM, Damoder Reddy damoder.re...@citrix.com wrote: Hi, There are 2 solutions. one either change the catalina.properties to include strategy in the common.loader as suggested in another thread mail OR Just put a symbolic link to the jar file inside /usr/share/tomcat6/lib as this path is already loaded by common.loader (common.loader=${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*.jar,/usr/share/java/mysql-connector-java.jar). I think 2nd option is better instead of 1st one. Thanks Regards Damodar/ -Original Message- From: Daan Hoogland [mailto:daan.hoogl...@gmail.com] Sent: Wednesday, June 18, 2014 2:37 PM To: sebgoa Cc: Damoder Reddy; Adrian Lewis Subject: Re: off list had Adrians address wrong -- Forwarded message -- From: Daan Hoogland daan.hoogl...@gmail.com Date: Wed, Jun 18, 2014 at 10:42 AM Subject: Re: off list To: sebgoa run...@gmail.com Cc: Damoder Reddy damoder.re...@citrix.com, Adrian Lewis adr...@alsiconsulting.co.uk I had a quick look. it doesn't seem a coding issue but a configuration/packaging issue. the file catalina.properties.in must be adjusted for this. There are two in the project. One for the ui, which I think won't need to be touched and one for the server. Damoder Reddy helped Adrien on this. cc'ing him and Adrien in now. @Damoder: can you confirm that we need to adjust the common.loader property in catalina.properties.in for CLOUDSTACK-6892? This way we should be done according to Adrien. This should be done for 4.3, 4.4 and master! regards, On Wed, Jun 18, 2014 at 10:10 AM, sebgoa run...@gmail.com wrote: On Jun 18, 2014, at 10:06 AM, Daan Hoogland daan.hoogl...@gmail.com wrote: it is not implemented/solved. not in 4.4 or master. Is work on it done already? not clear from the ticket. I just don't know how to modify the catalina properties in the code. On Wed, Jun 18, 2014 at 10:04 AM, Daan Hoogland daan.hoogl...@gmail.com wrote: on it On Wed, Jun 18, 2014 at 9:05 AM, Sebastien Goasguen run...@gmail.com wrote: Hi Daan, Can you check this one: https://issues.apache.org/jira/browse/CLOUDSTACK-6892 it might apply to 4.4 and 4.3 and I no squat in java -- Daan -- Daan -- Daan -- Daan -- Daan -- Daan -- Daan -- Daan
Re: [4.4] mysql-ha POM error
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. This got fixed in the commit mentioned by Ilya (https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;a=commit;h=15b6860c68125ea73f113cc9b41c10a67d661088 ). But I think this is not cherry-picked to 4.4. Looks like 4.4 branch created before this commit. The 4.3 branch has the fix. Somebody who has commit writes need to cherry pick this to 4.4 branch. Thanks Regards Damodar/ -Original Message- From: ilya musayev [mailto:ilya.mailing.li...@gmail.com] Sent: Friday, March 28, 2014 8:39 AM To: dev@cloudstack.apache.org Subject: Re: [4.4] mysql-ha POM error 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=be7f976c1027071a30b0d813535f224fc4f7e9dc;hb=HEAD Regards ilya On 3/27/14, 7:32 AM, Paul Angus wrote: 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-SNAPSH OT/plugins/database/mysql-ha/pom.xml) has 1 error [ERROR] Non-resolvable parent POM: Could not find artifact org.apache.cloudstack:cloudstack-plugins:pom:4.4.0-SNAPSHOT and 'parent.relativePath' points at wrong local POM @ line 15, column 11 - [Help 2] The pom in 4.4 has relativePath../pom.xml/relativePath The pom in master has relativePath../../pom.xml/relativePath Can someone fix it quickly or shall I create a bug? Regards, Paul Angus *Senior Consultant / Cloud Architect* cid:image003.png@01CEF0F0.9C9104D0 S: +44 20 3603 0540 tel:+442036030540 | M: +4 tel:+44796816158147711418784 | T: @CloudyAngus paul.an...@shapeblue.com mailto:paul.an...@shapeblue.com | www.shapeblue.com htp://www.shapeblue.com/ | Twitter:@shapeblue https://twitter.com/ ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS Need Enterprise Grade Support for Apache CloudStack? Our CloudStack Infrastructure Support http://shapeblue.com/cloudstack-infrastructure-support/ offers the best 24/7 SLA for CloudStack Environments. Apache CloudStack Bootcamp training courses **NEW!** CloudStack 4.2.1 training http://shapeblue.com/cloudstack-training/ 18th-19th February 2014, Brazil. Classroom http://shapeblue.com/cloudstack-training/ 17th-23rd March 2014, Region A. Instructor led, On-line http://shapeblue.com/cloudstack-training/ 24th-28th March 2014, Region B. Instructor led, On-line http://shapeblue.com/cloudstack-training/ 16th-20th June 2014, Region A. Instructor led, On-line http://shapeblue.com/cloudstack-training/ 23rd-27th June 2014, Region B. Instructor led, On-line 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.
[4.4] mysql-ha POM error
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 error [ERROR] Non-resolvable parent POM: Could not find artifact org.apache.cloudstack:cloudstack-plugins:pom:4.4.0-SNAPSHOT and 'parent.relativePath' points at wrong local POM @ line 15, column 11 - [Help 2] The pom in 4.4 has relativePath../pom.xml/relativePath The pom in master has relativePath../../pom.xml/relativePath Can someone fix it quickly or shall I create a bug? Regards, Paul Angus Senior Consultant / Cloud Architect [cid:image003.png@01CEF0F0.9C9104D0] S: +44 20 3603 0540tel:+442036030540 | M: +4tel:+44796816158147711418784 | T: @CloudyAngus paul.an...@shapeblue.commailto:paul.an...@shapeblue.com | www.shapeblue.comhtp://www.shapeblue.com/ | Twitter:@shapebluehttps://twitter.com/ ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS Need Enterprise Grade Support for Apache CloudStack? Our CloudStack Infrastructure Supporthttp://shapeblue.com/cloudstack-infrastructure-support/ offers the best 24/7 SLA for CloudStack Environments. Apache CloudStack Bootcamp training courses **NEW!** CloudStack 4.2.1 traininghttp://shapeblue.com/cloudstack-training/ 18th-19th February 2014, Brazil. Classroomhttp://shapeblue.com/cloudstack-training/ 17th-23rd March 2014, Region A. Instructor led, On-linehttp://shapeblue.com/cloudstack-training/ 24th-28th March 2014, Region B. Instructor led, On-linehttp://shapeblue.com/cloudstack-training/ 16th-20th June 2014, Region A. Instructor led, On-linehttp://shapeblue.com/cloudstack-training/ 23rd-27th June 2014, Region B. Instructor led, On-linehttp://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.
Re: [4.4] mysql-ha POM error
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=be7f976c1027071a30b0d813535f224fc4f7e9dc;hb=HEAD Regards ilya On 3/27/14, 7:32 AM, Paul Angus wrote: 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 error [ERROR] Non-resolvable parent POM: Could not find artifact org.apache.cloudstack:cloudstack-plugins:pom:4.4.0-SNAPSHOT and 'parent.relativePath' points at wrong local POM @ line 15, column 11 - [Help 2] The pom in 4.4 has relativePath../pom.xml/relativePath The pom in master has relativePath../../pom.xml/relativePath Can someone fix it quickly or shall I create a bug? Regards, Paul Angus *Senior Consultant / Cloud Architect* cid:image003.png@01CEF0F0.9C9104D0 S: +44 20 3603 0540 tel:+442036030540 | M: +4 tel:+44796816158147711418784 | T: @CloudyAngus paul.an...@shapeblue.com mailto:paul.an...@shapeblue.com | www.shapeblue.com htp://www.shapeblue.com/ | Twitter:@shapeblue https://twitter.com/ ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS Need Enterprise Grade Support for Apache CloudStack? Our CloudStack Infrastructure Support http://shapeblue.com/cloudstack-infrastructure-support/ offers the best 24/7 SLA for CloudStack Environments. Apache CloudStack Bootcamp training courses **NEW!** CloudStack 4.2.1 training http://shapeblue.com/cloudstack-training/ 18th-19th February 2014, Brazil. Classroom http://shapeblue.com/cloudstack-training/ 17th-23rd March 2014, Region A. Instructor led, On-line http://shapeblue.com/cloudstack-training/ 24th-28th March 2014, Region B. Instructor led, On-line http://shapeblue.com/cloudstack-training/ 16th-20th June 2014, Region A. Instructor led, On-line http://shapeblue.com/cloudstack-training/ 23rd-27th June 2014, Region B. Instructor led, On-line 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.
RE: [4.4] mysql-ha POM error
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;a=commit;h=15b6860c68125ea73f113cc9b41c10a67d661088 ). But I think this is not cherry-picked to 4.4. Looks like 4.4 branch created before this commit. The 4.3 branch has the fix. Somebody who has commit writes need to cherry pick this to 4.4 branch. Thanks Regards Damodar/ -Original Message- From: ilya musayev [mailto:ilya.mailing.li...@gmail.com] Sent: Friday, March 28, 2014 8:39 AM To: dev@cloudstack.apache.org Subject: Re: [4.4] mysql-ha POM error 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=be7f976c1027071a30b0d813535f224fc4f7e9dc;hb=HEAD Regards ilya On 3/27/14, 7:32 AM, Paul Angus wrote: 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-SNAPSH OT/plugins/database/mysql-ha/pom.xml) has 1 error [ERROR] Non-resolvable parent POM: Could not find artifact org.apache.cloudstack:cloudstack-plugins:pom:4.4.0-SNAPSHOT and 'parent.relativePath' points at wrong local POM @ line 15, column 11 - [Help 2] The pom in 4.4 has relativePath../pom.xml/relativePath The pom in master has relativePath../../pom.xml/relativePath Can someone fix it quickly or shall I create a bug? Regards, Paul Angus *Senior Consultant / Cloud Architect* cid:image003.png@01CEF0F0.9C9104D0 S: +44 20 3603 0540 tel:+442036030540 | M: +4 tel:+44796816158147711418784 | T: @CloudyAngus paul.an...@shapeblue.com mailto:paul.an...@shapeblue.com | www.shapeblue.com htp://www.shapeblue.com/ | Twitter:@shapeblue https://twitter.com/ ShapeBlue Ltd, 53 Chandos Place, Covent Garden, London, WC2N 4HS Need Enterprise Grade Support for Apache CloudStack? Our CloudStack Infrastructure Support http://shapeblue.com/cloudstack-infrastructure-support/ offers the best 24/7 SLA for CloudStack Environments. Apache CloudStack Bootcamp training courses **NEW!** CloudStack 4.2.1 training http://shapeblue.com/cloudstack-training/ 18th-19th February 2014, Brazil. Classroom http://shapeblue.com/cloudstack-training/ 17th-23rd March 2014, Region A. Instructor led, On-line http://shapeblue.com/cloudstack-training/ 24th-28th March 2014, Region B. Instructor led, On-line http://shapeblue.com/cloudstack-training/ 16th-20th June 2014, Region A. Instructor led, On-line http://shapeblue.com/cloudstack-training/ 23rd-27th June 2014, Region B. Instructor led, On-line 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.