[OpenSIPS-Users] ACC failover solution

[Jarrod Baumann]

Daniel,

You want to look at db_virtual (http://www.opensips.org/html/docs/modules/2.2.x/db_virtual.html <http://www.opensips.org/html/docs/modules/2.2.x/db_virtual.html>)

You can define failover database as such:
modparam("db_virtual", "db_urls", "define accounting FAILOVER")
modparam("db_virtual", "db_urls", "mysql://opensips:opensipsrw@host1/testa")
modparam("db_virtual", "db_urls", "mysql://opensips:opensipsrw@host2/testa")

Your acc db url would look something like this:
modparam("acc", "db_url", "virtual://accounting”)

jarrod

> On Jul 2, 2016, at 4:57 PM, Daniel Zanutti <d
> aniel.zanutti at gmail.com> wrote:
> 
> Hi
> 
> I need some help to provide a failover solution to do accounting on our calls.
> 
> 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?
> 
> 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.
> 
> Thanks in advance!
> _______________________________________________
> 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/20160702/0b3132d2/attachment.htm>