cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alireza Eskandari <astro.alir...@gmail.com>
Subject Re: MySQL HA
Date Sat, 16 Dec 2017 10:03:48 GMT
I'm using CS 4.9.3.0-shapeblue0

On Sat, Dec 16, 2017 at 12:49 PM, Rafael Weingärtner
<rafaelweingartner@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.alireza@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
>> <rafaelweingartner@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 <
>> > gabrascher@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=<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.alireza@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

Mime
View raw message