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)
<[email protected] <mailto:[email protected]>> 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 <[email protected]
<mailto:[email protected]>> 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/
--
_____________________________________________________________________
-- 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
