cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francois Gaudreault <fgaudrea...@cloudops.com>
Subject Re: Connect to a MySQL Galera Cluster
Date Sun, 26 Jan 2014 17:10:58 GMT
On 1/26/2014, 5:34 AM, Shanker Balan wrote:
> The other way would be to make the whole fault tolerance an app problem. If
> the app could automagically reconfigure itself to do round robin writes
> across the galera cluster based on health checks, we will get “HA” automatically.
> A failed node would end up being blacklisted by the app.
JDBC is supposed to be able to do that out of the box. But that means a 
code recompile. Something like:

jdbc:mysql:loadbalance://node1,node2,nodeN/database?loadBalanceBlacklistTimeout=5000

-- 
Francois Gaudreault
Architecte de Solution Cloud | Cloud Solutions Architect
fgaudreault@cloudops.com
514-629-6775
- - -
CloudOps
420 rue Guy
Montréal QC  H3J 1S6
www.cloudops.com
@CloudOps_


Mime
View raw message