[SR-Users] Moving from haproxy to db_cluster

[Jan Hazenberg]

Daniel Tryba schreef op 2015-07-08 12:19:
> 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).
> 
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Thanks for the quick reply, indeed looks like that the db_cluster module 
is the best solution.

Jan