On Monday 19 June 2017 at 18:12:35, Sebastian Gutierrez wrote:> use replication1. 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.
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 replication1. 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
Marcelo Terres
2017-Jun-20 12:58 UTC
[asterisk-users] Writing CDR's to two database servers
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