Mailing-List: contact users-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cloudstack.apache.org
From: Stavros Konstantaras <s.konstantaras@uva.nl>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Subject: Failed to configure HA in active/active setup
Message-Id: <19A3385B-EB7F-40FE-AF54-DDD7B347D1F0@uva.nl>
Date: Mon, 23 Nov 2015 22:54:37 +0100
To: users@cloudstack.apache.org
Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2081\))

Hi there,

I am trying to setup High Availability on Cloudstack 4.5.2 in a =
Master-Master implementation with MySQL DB but I get the following =
error:
=E2=80=94=E2=80=94
2015-11-24 00:29:01,988 INFO  [c.c.u.d.T.Transaction] (main:null) Is =
Data Base High Availiability enabled? Ans : true
2015-11-24 00:29:02,043 INFO  [c.c.u.d.T.Transaction] (main:null) The =
slaves configured for Cloud Data base is/are : 10.0.60.2
2015-11-24 00:29:02,087 ERROR [c.c.u.d.Merovingian2] (main:null) Unable =
to get a new db connection
java.sql.SQLException: Invalid load balancing strategy =
'com.cloud.utils.db.StaticStrategy'.
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
	at com.mysql.jdbc.Util.loadExtensions(Util.java:588)
	=E2=80=A6
	=E2=80=A6
=E2=80=94=E2=80=94

The target is fault tolerance so in case of failure of the first server =
then we can continue working as normal with the second server. I tried =
to debug this but unfortunately it still goes on.=20
I checked open ports with netstat and mysql listens to all interfaces =
=E2=80=9C0.0.0.0:3306=E2=80=9D

I enabled HA in db.properties and I inserted  the IP of the second =
server in db.cloud.slaves and db.usage.slaves (it is also viewable in =
the error above).

=E2=80=94=E2=80=94
Of course I configured my.cnf file which is quite simple:
[mysqld]
datadir=3D/var/lib/mysql
socket=3D/var/lib/mysql/mysql.sock
user=3Dmysql

symbolic-links=3D0
innodb_rollback_on_timeout=3D1
innodb_lock_wait_timeout=3D600
default-storage-engine=3DInnoDB
character-set-server=3Dutf8
transaction-isolation=3DREAD-COMMITTED
innodb_flush_log_at_trx_commit=3D1
max_connections=3D350

# ~ HA ~
server-id=3D1 (THIS VALUE IS 2 IN THE SAME FILE OF THE SECOND SERVER)
log-bin=3Dmysql-bin
binlog-format=3D'ROW'
sync_binlog=3D1

# Bin logs cleanup configuration
expire_logs_days=3D10
max_binlog_size=3D100M

[mysqld_safe]
log-error=3D/var/log/mysqld.log
pid-file=3D/var/run/mysqld/mysqld.pid
=E2=80=94=E2=80=94

I place the HA java plug-in under =
"/usr/share/cloudstack-mysql-ha/lib/cloud-plugin-database-mysqlha-4.5.2.ja=
r=E2=80=9D
=E2=80=94=E2=80=94

In catalina.properties my common.loader looks normal: =
"common.loader=3D${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalin=
a.home}/lib,${catalina.home}/lib/*.jar,/usr/share/java/mysql-connector-jav=
a.jar,/usr/share/cloudstack-mysql-ha/lib/*jar=E2=80=9D

After unlimited restarts of both cloudstack-management and mysqld the =
problem still remains. Both IPs are pingable between the two servers. =
Any other idea or suggestion on solving that? Thank you in advance.=20

Best regards
Stavros

----------------------------
Stavros Konstantaras
Science faculty Research IT support (FEIOG)=20
University of Amsterdam, Science Park 904, 1098 XH

Fingerprint: E5E5 9B19 D1CD 88CD 4763  3465 A8DC 7C92 330F D59A