<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd"><html><head><meta name="qrichtext" content="1" /><style type="text/css">p, li { white-space: pre-wrap; }</style></head><body style=" font-family:'Lucida Console'; font-size:9pt; font-weight:400; font-style:normal;">On Dienstag, 30. Juni 2009, logivoip@gmail.com wrote:<br>
> I have configured two redundant DB sources in my kamailio confiuration. <br>
> The DB's are accessed from Kamailio for redundancy pruposes.<br>
> Kamailio and the primary DB are on the same hardware node. The secondary<br>
> DB is on a remote host.<br>
> If Kamailio is up and both MySQL DB's are up, the config works like a<br>
> charm. If the primary or the secondary DB becomes unreachable while<br>
> Kamailio is up, the config handles the exception and all works well.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Hi JR,<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>ok, fine so far.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>> However, if any of the DB servers becomes unreachable and Kamailio is<br>
> restarted, Kamailio can no longer start.<br>
> [..]<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>It seems that the module want to check if its can reach all configured databases during startup. This is probably required just to make sure that the user did not make a mistake in the configuration, the DBs are reachable and so on. <br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>> What is the proper way of using multiple database servers with Kamailio?<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>May i ask what kind of functionality you miss? I'd think that you need at least one DB during startup for the server, to be used from sqlops. One possibility would be to add later a new connection to the module, for example with a FIFO command when it gets available, but this is not implemented at the moment.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Instead of handling the outage of DBs in the kamailio server another option would be to implement a failover setup (heartbeat+drdb for example) on the DB level, or use a clustering solution (e.g. mysql cluster).<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Henning</p></body></html>