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

[Julien Chavanton]

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

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