[asterisk-users] Writing CDR's to two database servers

[Marcelo Terres]

Well, you could create and AGI and run it after the normal CDR was inserted.
Marcelo H. Terres <mhterres at gmail.com>
IM: mhterres at jabber.mundoopensource.com.br
https://www.mundoopensource.com.br
https://twitter.com/mhterres
https://linkedin.com/in/marceloterres


On 20 June 2017 at 13:42, Tech Support <asterisk at voipbusiness.us> wrote:
>     I appreciate all the feedback, and replication seems to be a logical solution, but I was initially thinking about how to implement a solution within Asterisk to write the CDR's to two databases. Is that possible? Now I'm just curious.
> Thanks Much;
> John V.
>
> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Antony Stone
> Sent: Monday, June 19, 2017 01:08 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [asterisk-users] Writing CDR's to two database servers
>
> On Monday 19 June 2017 at 18:12:35, Sebastian Gutierrez wrote:
>
>> use replication
>
> 1. Agreed - use replication.
>
> 2. If you want an HA (High Availability, not dependent on a single Master DB server replicating to a slave) solution, consider setting up Master-Master replication, with an LVS (Linux Virtual Server) HA machine in front of the two, so that writes can go to either server using only a single IP address configured in Asterisk.
>
> Then, if one fails, you can still write to (and read from) the other, repair the failed one, and restore replication.
>
>
> Antony
>
>> > On Jun 19, 2017, at 17:47, Tech Support <asterisk at voipbusiness.us> wrote:
>> >
>> > All;
>> >
>> >     I know that there are probably several solutions to this problem, but
>> >     what I am trying to do is provide some redundancy for my customers
>> >     CDR data. I know that doing simple backups of MySQL is probably the
>> >     easiest way to go, but I’m thinking that there may be some benefit
>> >     to simultaneously writing the CDR data to multiple servers at once.
>> >     However, I’m drawing a blank on this one. Has anyone else done this
>> >     before? Any insight at all would be greatly appreciated.
>> >
>> > Thanks Much;
>> > John V.
>
> --
> Atheism is a non-prophet-making organisation.
>
>                                                    Please reply to the list;
>                                                          please *don't* CC me.
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Check out the new Asterisk community forum at: https://community.asterisk.org/
>
> New to Asterisk? Start here:
>       https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Check out the new Asterisk community forum at: https://community.asterisk.org/
>
> New to Asterisk? Start here:
>       https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users