[SR-Users] Moving from haproxy to db_cluster

[Daniel Tryba]

On Wednesday 08 July 2015 11:02:44 Jan Hazenberg wrote:
> The question is if a database node fails and the TCP connection breaks 
> the sql query will probably fail when using haproxy since it is not 
> aware of the query. Will the db_cluster module send the query to the 
> next available mysql node in the cluster without a failing query? If 
> thats the case i should not notice the failing dbnode in my kamailio 
> script.

Yes, if a node failes to reply, the next node will be used.

Take note of the penalty box used in db_cluster, if a node fails to reply in a 
timely fashion (max_query_length) it will be disable for some time 
(inactive_interval, by default 300s).