<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Daniel,<div class=""><br class=""></div><div class="">You want to look at db_virtual (<a href="http://www.opensips.org/html/docs/modules/2.2.x/db_virtual.html" class="">http://www.opensips.org/html/docs/modules/2.2.x/db_virtual.html</a>)</div><div class=""><br class=""></div><div class="">You can define failover database as such:</div><div class=""><div class="">modparam("db_virtual", "db_urls", "define accounting FAILOVER")</div><div class="">modparam("db_virtual", "db_urls", "<a href="mysql://opensips:opensipsrw@host1/testa" class="">mysql://opensips:opensipsrw@host1/testa</a>")</div><div class="">modparam("db_virtual", "db_urls", "<a href="mysql://opensips:opensipsrw@host2/testa" class="">mysql://opensips:opensipsrw@host2/testa</a>")</div></div><div class=""><br class=""></div><div class="">Your acc db url would look something like this:</div><div class="">modparam("acc", "db_url", "<span style="widows: 1; background-color: rgb(254, 254, 238);" class=""><a href="virtual://accounting" class="">virtual://accounting</a></span>”)</div><div class=""><br class=""></div><div class="">jarrod</div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Jul 2, 2016, at 4:57 PM, Daniel Zanutti <d</div></blockquote><blockquote type="cite" class=""><div class=""><a href="mailto:aniel.zanutti@gmail.com" class="">aniel.zanutti@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="">Hi</div><div class=""><br class=""></div><div class="">I need some help to provide a failover solution to do accounting on our calls.</div><div class=""><br class=""></div><div class="">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 class=""><br class=""></div><div class="">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 class=""><br class=""></div><div class="">Thanks in advance!</div></div>
_______________________________________________<br class="">Users mailing list<br class=""><a href="mailto:Users@lists.opensips.org" class="">Users@lists.opensips.org</a><br class="">http://lists.opensips.org/cgi-bin/mailman/listinfo/users<br class=""></div></blockquote></div><br class=""></div></body></html>