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>
On 8/1/19 5:08 PM, Dovid Bender wrote:> 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.If I recall correctly, you can exclude databases. Doug -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20190801/fe4d8410/attachment.html>
It is not tough to run multiple instances of MySQL using different data directories and different ports/sockets. Google for mysqld_multi. I have an MySQL instance which holds call routing information and is replicated to the Asterisk servers. I have a second MySQL instance on the same server which holds CDRs and other data which doesn't need to be replicated to the Asterisk servers. On 8/1/19 5:08 PM, Dovid Bender wrote:> 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 <mailto: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 > <mailto: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 > >-- http://help.nyigc.net/
IF you use the HAAst or PBXSync solution, you can include/exclude at the table and database levels. You can also use SQLite if the data is suitable (and these products can sync SQLite too). If you want a non-commercial solution, MySQL’s log rolling may be most suitable. From: asterisk-users [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Doug Lytle Sent: Thursday, August 1, 2019 6:06 PM To: asterisk-users at lists.digium.com Subject: Re: [asterisk-users] Lightweight ODBC DB On 8/1/19 5:08 PM, Dovid Bender wrote: 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. If I recall correctly, you can exclude databases. Doug -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20190802/c64963f3/attachment.html>
On Thu, 1 Aug 2019 at 17:07, Doug Lytle <support at drdos.info> wrote:> On 8/1/19 5:08 PM, Dovid Bender wrote: > > 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. > > > If I recall correctly, you can exclude databases. > > Doug >https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20190801/95f52134/attachment.html>