[asterisk-users] Lightweight ODBC DB

[Eric Wieling]

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/