<div dir="ltr">Great! I'll take a look</div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Jul 2, 2016 at 7:07 PM, Jarrod Baumann <span dir="ltr"><<a href="mailto:jarrod@unixc.org" target="_blank">jarrod@unixc.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Daniel,<div><br></div><div>You want to look at db_virtual (<a href="http://www.opensips.org/html/docs/modules/2.2.x/db_virtual.html" target="_blank">http://www.opensips.org/html/docs/modules/2.2.x/db_virtual.html</a>)</div><div><br></div><div>You can define failover database as such:</div><div><div>modparam("db_virtual", "db_urls", "define accounting FAILOVER")</div><div>modparam("db_virtual", "db_urls", "<a>mysql://opensips:opensipsrw@host1/testa</a>")</div><div>modparam("db_virtual", "db_urls", "<a>mysql://opensips:opensipsrw@host2/testa</a>")</div></div><div><br></div><div>Your acc db url would look something like this:</div><div>modparam("acc", "db_url", "<span style="background-color:rgb(254,254,238)"><a>virtual://accounting</a></span>”)</div><div><br></div><div>jarrod</div><div><br><div><blockquote type="cite"><div>On Jul 2, 2016, at 4:57 PM, Daniel Zanutti <d</div></blockquote><blockquote type="cite"><div><a href="mailto:aniel.zanutti@gmail.com" target="_blank">aniel.zanutti@gmail.com</a>> wrote:</div><br><div><div><div class="h5"><div dir="ltr"><div>Hi</div><div><br></div><div>I need some help to provide a failover solution to do accounting on our calls.</div><div><br></div><div>If ACC fails to write on MySQL accounting system (Like MySQL), the record is lost. Is there any failover solution on the ACC module, to record on another kind of DB, only if MySQL failed?</div><div><br></div><div>I know I could write on both but it's a waste of resources, I wanted to record on another kind of DB only if the first (or primary) failed.</div><div><br></div><div>Thanks in advance!</div></div></div></div>
_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></div></blockquote></div><br></div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>