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

[John Kiniston]

You can do this with cdr_adaptive_odbc.

On Tue, Jun 20, 2017 at 5:58 AM, Marcelo Terres <mhterres at gmail.com> wrote:

> 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
>
> --
> _____________________________________________________________________
> -- 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
>



-- 
A human being should be able to change a diaper, plan an invasion, butcher
a hog, conn a ship, design a building, write a sonnet, balance accounts,
build a wall, set a bone, comfort the dying, take orders, give orders,
cooperate, act alone, solve equations, analyze a new problem, pitch manure,
program a computer, cook a tasty meal, fight efficiently, die gallantly.
Specialization is for insects.
---Heinlein
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20170620/0196075d/attachment.html>