Don't know if this will help but I found this...
http://www.open-voip.org/index.php?title=Asterisk_High_availablity
One of the suggestions they have is to use a remote db server, shared by
both asterisk systems.
Another thought I had... would an asterisk "reload" cause the db file to be
closed/reopened?
David
On Fri, Dec 5, 2014 at 9:21 AM, Shamus Rask <[email protected]> wrote:
> Lonnie, Michael:
>
> Thank you for your replies. I had taken a look at the Perl script on
> void-info, however, as it states, it is not reliable. I am currently doing
> something similar from the CLI. The issue is that I have no guarantee of
> proper sync without writing a whole write-ack layer.
>
> Lonnie–you are correct that the values are written directly to disc. The
> issue is that if you were to copy the modified db to another instance,
> Asterisk only “opens” the db on startup. Until it opens the modified db, it
> has no knowledge of any changes.
>
> This seems to be a failing of Asterisk… was hoping someone else had banged
> their head against this one and had some ideas.
>
> many thanks,
> Shamus
>
> > Message: 2
> > Date: Mon, 1 Dec 2014 21:12:19 -0600
> > From: Lonnie Abelbeck <[email protected]>
> > Subject: Re: [Astlinux-users] AstDB replication
> > To: AstLinux Users Mailing List <[email protected]>
> > Message-ID: <[email protected]>
> > Content-Type: text/plain; charset=windows-1252
> >
> > Hi Shamus,
> >
> > At least with Asterisk 11 which uses sqlite3, the writes seem to go
> directly to disk, for example...
> >
> > shell pbx # echo '.dump' | sqlite3 --batch /mnt/kd/astdb.sqlite3 | grep
> '/foo/bar'
> > (nothing)
> >
> > asterisk pbx*CLI> database put foo bar 0
> >
> > shell pbx # echo '.dump' | sqlite3 --batch /mnt/kd/astdb.sqlite3 | grep
> '/foo/bar'
> > INSERT INTO "astdb" VALUES('/foo/bar','0');
> >
> > asterisk pbx*CLI> database del foo bar
> >
> > shell pbx # echo '.dump' | sqlite3 --batch /mnt/kd/astdb.sqlite3 | grep
> '/foo/bar'
> > (nothing)
> >
> > So, from this simple test the /mnt/kd/astdb.sqlite3 file seems to be
> kept current in real time. I suspect occasional rsync's should work though
> you may want to make a temp copy of /mnt/kd/astdb.sqlite3 and rsync that
> just in case the /mnt/kd/astdb.sqlite3 got written to while the rsync was
> still active.
> >
> > Lonnie
> >
> >
> >
> > ------------------------------
> >
> > Message: 3
> > Date: Tue, 2 Dec 2014 04:30:04 +0000
> > From: Michael Knill <[email protected]>
> > Subject: Re: [Astlinux-users] AstDB replication
> > To: AstLinux Users Mailing List <[email protected]>
> > Message-ID: <[email protected]>
> > Content-Type: text/plain; charset="utf-8"
> >
> > There is a Perl script here that you can modify to achieve this:
> >
> > http://www.voip-info.org/wiki/view/Asterisk+database
> >
> > Regards
> > Michael Knill
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Astlinux-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/astlinux-users
>
> Donations to support AstLinux are graciously accepted via PayPal to
> [email protected].
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Astlinux-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/astlinux-users
Donations to support AstLinux are graciously accepted via PayPal to
[email protected].
