You can do this with cdr_adaptive_odbc. On Tue, Jun 20, 2017 at 5:58 AM, Marcelo Terres <mhter...@gmail.com> wrote:
> Well, you could create and AGI and run it after the normal CDR was > inserted. > Marcelo H. Terres <mhter...@gmail.com> > IM: mhter...@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 <aster...@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-boun...@lists.digium.com [mailto:asterisk-users- > boun...@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 <aster...@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
-- _____________________________________________________________________ -- 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