<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.16.3">
</HEAD>
<BODY>
Hi,<BR>
<BR>
Use db_virtual and have it write to a second mysql box or flat file, works VERY well.<BR>
<BR>
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.<BR>
<BR>
<BR>
On Wed, 2010-04-28 at 14:21 +0100, Julien Chavanton wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
<FONT SIZE="2"><FONT COLOR="#000000">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.</FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000000">Is there any recommendation / best practice ?</FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000000">-------------------------------- config</FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000000">modparam("siptrace", "db_url", "mysql://login:password@x.x.x.x/opensips")</FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000000">modparam("acc", "db_url", "mysql://login:password@x.x.x.x/opensips")</FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000000">-------------------------------- log</FONT></FONT><BR>
<BR>
<FONT SIZE="2"><FONT COLOR="#000000">Apr 28 12:28:34 osip /usr/local/sbin/opensips[4819]: INFO:core:handle_sigs: child process 4835 exited by a signal 11</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#000000">Apr 28 12:28:34 osip /usr/local/sbin/opensips[4844]: CRITICAL:core:receive_fd: EOF on 24</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#000000">Apr 28 12:28:34 osip /usr/local/sbin/opensips[4819]: INFO:core:handle_sigs: core was generated</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#000000">Apr 28 12:28:34 osip /usr/local/sbin/opensips[4819]: INFO:core:handle_sigs: terminating due to SIGCHLD</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#000000">Apr 28 12:28:34 osip /usr/local/sbin/opensips[4840]: INFO:core:sig_usr: signal 15 received</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#000000">Apr 28 12:28:34 osip /usr/local/sbin/opensips[4834]: INFO:core:sig_usr: signal 15 received</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#000000">Apr 28 12:28:34 osip /usr/local/sbin/opensips[4843]: INFO:core:sig_usr: signal 15 received</FONT></FONT><BR>
<FONT SIZE="2"><FONT COLOR="#000000">Apr 28 12:28:34 osip /usr/local/sbin/opensips[4842]: INFO:core:sig_usr: signal 15 received</FONT></FONT><BR>
<BR>
<PRE>
<FONT COLOR="#000000">_______________________________________________</FONT>
<FONT COLOR="#000000">Users mailing list</FONT>
<FONT COLOR="#000000"><A HREF="mailto:Users@lists.opensips.org">Users@lists.opensips.org</A></FONT>
<FONT COLOR="#000000"><A HREF="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</A></FONT>
</PRE>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>