[SR-Users] Moving from haproxy to db_cluster

[Jan Hazenberg]

Jan Hazenberg schreef op 2015-07-08 12:35:
> 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
> 
> _______________________________________________
> 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


One other question, is there a way to see the status of the connections 
to the dbnodes with db_cluster?

Thanks,

Jan