cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel Beims Bräscher <gabrasc...@gmail.com>
Subject Re: MySQL HA
Date Tue, 12 Dec 2017 10:56:35 GMT
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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message