Hi, I am running several Asterisk boxes with realtime around the world. Does anyone have a recommendation for a "light" db that would work with Asterisk that would also allow replication between all sites (so if I add an entry to one box it will work with the rest)? TIA. Dovid -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20190730/53ca4d8d/attachment.html>
Hi Dovid, Totally possible... We're currently doing what you suggest with standard mySQL configured in Master-Master replication mode, across many nodes geo-distributed, with no (or few, like environment related) errors... for a few years now. This allows for fast updates at any node, and synchronizes via replication across other nodes as necessary. There are other replication solutions out there, but nothing as free, and "light" as this, that we've found so far. Hope this helps. *Glenn Geller* *VDOTel* On Tue, Jul 30, 2019 at 6:56 PM Dovid Bender <dovid at telecurve.com> wrote:> Hi, > > I am running several Asterisk boxes with realtime around the world. Does > anyone have a recommendation for a "light" db that would work with Asterisk > that would also allow replication between all sites (so if I add an entry > to one box it will work with the rest)? > > TIA. > > Dovid > > -- > _____________________________________________________________________ > -- 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-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20190730/b092f6fc/attachment.html>
Have you looked at PBXSync (or HAAst) from Telium? (https://telium.io) These products will sync MySQL, SQLite, plus files, directories, etc. intelligently. (Differentials only) between PBX’s, reload configurations on the fly, etc. No need roll logs or recover from a base in case they get too far out of sync. HAAst will also prevent synchronizing if a node is in poor health (to avoiding sync’ing in corrupted data). I’m not sure what you are building but this might help. Aside from this, avoid block based synchronization of databases (eg: DRBD) for the obvious reasons. There are Master-Master sync tools out there, but if you are trying to wrap some intelligence around that then you are basically building your own sync product. -Raj- From: asterisk-users [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Dovid Bender Sent: Tuesday, July 30, 2019 9:55 PM To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users at lists.digium.com> Subject: [asterisk-users] Lightweight ODBC DB Hi, I am running several Asterisk boxes with realtime around the world. Does anyone have a recommendation for a "light" db that would work with Asterisk that would also allow replication between all sites (so if I add an entry to one box it will work with the rest)? TIA. Dovid -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20190731/52cf7434/attachment.html>
Glenn, I can't use MySQL as each node currently has MySQL however there is a lot of data that is stored locally on each box. I may have to take this route if I can't find something else but that would mean syncing all sorts of data that does not need to be synced. On Tue, Jul 30, 2019 at 10:03 PM Glenn Geller (VDOPh) <ggeller at vdo-ph.com> wrote:> Hi Dovid, > > Totally possible... We're currently doing what you suggest with standard > mySQL configured in Master-Master replication mode, across many nodes > geo-distributed, with no (or few, like environment related) errors... for a > few years now. > > This allows for fast updates at any node, and synchronizes via replication > across other nodes as necessary. > > There are other replication solutions out there, but nothing as free, and > "light" as this, that we've found so far. > > Hope this helps. > > > > *Glenn Geller* > > *VDOTel* > > On Tue, Jul 30, 2019 at 6:56 PM Dovid Bender <dovid at telecurve.com> wrote: > >> Hi, >> >> I am running several Asterisk boxes with realtime around the world. Does >> anyone have a recommendation for a "light" db that would work with Asterisk >> that would also allow replication between all sites (so if I add an entry >> to one box it will work with the rest)? >> >> TIA. >> >> Dovid >> >> -- >> _____________________________________________________________________ >> -- 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-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20190801/689f5605/attachment.html>