Re: Connect to a MySQL Galera Cluster

2014-01-26 Thread Shanker Balan
Comments inline. On 26-Jan-2014, at 11:14 am, Shanker Balan shanker.ba...@shapeblue.com wrote: Comments inline. On 26-Jan-2014, at 10:10 am, Francois Gaudreault fgaudrea...@cloudops.com wrote: Yes, we tried with a NetScaler, but as soon as one MySQL dies, both management servers fence

Re: Connect to a MySQL Galera Cluster

2014-01-26 Thread Nux!
On 26.01.2014 04:40, Francois Gaudreault wrote: Yes, we tried with a NetScaler, but as soon as one MySQL dies, both management servers fence themselves on DB exceptions :S I think part of your problem is you run only 2 galera nodes. Thus it is strongly advised that the minimum Galera cluster

Re: Connect to a MySQL Galera Cluster

2014-01-26 Thread Francois Gaudreault
I just noticed some DB HA parameters in the db.properties.in file. Anyone ever tried them? It looks like CloudStack is able to handle slaves and autoReconnectForPool? Francois I was not able to get much information but Looks like it does not manage sessions across the cluster. So if a node

Re: Connect to a MySQL Galera Cluster

2014-01-26 Thread Francois Gaudreault
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

Connect to a MySQL Galera Cluster

2014-01-25 Thread Francois Gaudreault
We are trying to make CloudStack to work with a Galera two node master/master cluster. We have a NetScaler doing DataStream LB in front of the cluster, and we have two CloudStack management servers in active/active. Anyone had success with this kind of scenario? As soon as I shut a MySQL

Re: Connect to a MySQL Galera Cluster

2014-01-25 Thread Nux!
On 26.01.2014 02:33, Francois Gaudreault wrote: We are trying to make CloudStack to work with a Galera two node master/master cluster. We have a NetScaler doing DataStream LB in front of the cluster, and we have two CloudStack management servers in active/active. Anyone had success with this

Re: Connect to a MySQL Galera Cluster

2014-01-25 Thread Francois Gaudreault
Yes, we tried with a NetScaler, but as soon as one MySQL dies, both management servers fence themselves on DB exceptions :S Francois On 1/25/2014, 10:08 PM, Nux! wrote: On 26.01.2014 02:33, Francois Gaudreault wrote: We are trying to make CloudStack to work with a Galera two node

Re: Connect to a MySQL Galera Cluster

2014-01-25 Thread Shanker Balan
Comments inline. On 26-Jan-2014, at 10:10 am, Francois Gaudreault fgaudrea...@cloudops.com wrote: Yes, we tried with a NetScaler, but as soon as one MySQL dies, both management servers fence themselves on DB exceptions :S Does Galera maintain client connection state across the failover?