[OpenSIPS-Users] avoid down time caused by mysql server connection lost

[Brad Bendy]

Hi,

Use db_virtual and have it write to a second mysql box or flat file,
works VERY well.

Then import the entries from flat file into mysql once it's back up and
your back in business, the switch will not crash if it loses connection
to mysql then.


On Wed, 2010-04-28 at 14:21 +0100, Julien Chavanton wrote:

> Hi, I have single point of failure for Opensips with siptrace and CDR,
> if the Mysql server is disconnected from the network opensip will stop
> working, I would rather continue to accept calls without storing
> CDR/trace or use a secondary mysql connection.
> 
> Is there any recommendation / best practice ?
> 
> -------------------------------- config
> 
> modparam("siptrace", "db_url",
> "mysql://login:password@x.x.x.x/opensips")
> 
> modparam("acc", "db_url", "mysql://login:password@x.x.x.x/opensips")
> 
> -------------------------------- log
> 
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4819]:
> INFO:core:handle_sigs: child process 4835 exited by a signal 11
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4844]:
> CRITICAL:core:receive_fd: EOF on 24
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4819]:
> INFO:core:handle_sigs: core was generated
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4819]:
> INFO:core:handle_sigs: terminating due to SIGCHLD
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4840]:
> INFO:core:sig_usr: signal 15 received
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4834]:
> INFO:core:sig_usr: signal 15 received
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4843]:
> INFO:core:sig_usr: signal 15 received
> Apr 28 12:28:34 osip /usr/local/sbin/opensips[4842]:
> INFO:core:sig_usr: signal 15 received
> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100428/b7f27c1f/attachment.htm