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).