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

[Tech Support]

    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