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

[Antony Stone]

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.