I don't know the low-level details how Asterisk and SQLite (astdb) writes occur ... are they synchronous or asynchronous ? is the data flushed to disk after a write ?
Also, it is possible using ODBC with a SQLite3 backend would have better performance than using Asterisk astdb ... Asterisk ODBC using SQLite3 https://doc.astlinux-project.org/userdoc:tt_asterisk-odbc I seem to recall there were recent changes to Asterisk 13 regarding ODBC performance. I forget the details. Lonnie On Jul 9, 2017, at 10:38 AM, David Kerr <da...@kerr.net> wrote: > I'm still curious as to why astdb needs to be on ramdisk. I also read from > astdb several times for every incoming call, but I don't write to it. And > Linux does a lot of filesystem cacheing... essentially the linux kernel uses > every available byte of ram to cache data and programs so that you are not > reading from physical disk (or ssd) every time you read from a file. So > until you perform a db write I am assuming that the vast majority of my astdb > reads are optimized by the linux filesystem and come from ram not ssd. > > Right? Wrong? > > David > > On Sat, Jul 8, 2017 at 12:13 PM, The Cadillac Kid via Astlinux-users > <astlinux-users@lists.sourceforge.net> wrote: > I run my asterisk DB in RAM on my regular asterisk servers.. I have an agent > that automatically backs that up every so often to set a of files.. if my > asterisk system crashes then it reloads my asterisk DB on boot.. persistence > is maintained via storing my asterisk DB as a datadump style file on regular > storage and not just copying the astdb file (you'll corrupt it if you do > that).. > > its fast.. I use a LOT of astdb lookups in my normal call processing.. > -Christopher > > > From: David Kerr <da...@kerr.net> > To: Mehdi Shirazi <mahdi_shir...@yahoo.com>; AstLinux Users Mailing List > <astlinux-users@lists.sourceforge.net> > Sent: Saturday, July 8, 2017 12:06 PM > Subject: Re: [Astlinux-users] RAMdisk and HA > > Astlinux already uses a tmpfs for most files. For those specific files that > need to be persistent astlinux uses a soft link to /mnt/kd which is > persistent store. You can see this e.g. in /var/spool/asterisk. Is there a > specific file you want to have on tmpfs that is not? > > Astlinux has HA for the external network interface. If the primary internet > link goes down it can failover to a second interface. If you are asking > about application layer asterisk HA then I am not aware of anything specific > in Astlinux for that -- you would need to research how to do that yourself > > Use rsync for file synchronization? That is what I use for daily backup to a > remote system. > > I can understand the interest in HA, but I'm curious what performance issues > you are running into with the filesystem, Astlinux is already very efficient > here. > > Regards, > David > > On Sat, Jul 8, 2017 at 1:33 AM, Mehdi Shirazi via Astlinux-users > <astlinux-users@lists.sourceforge.net> wrote: > Hi > Thanks for maintaining good project. > 1-Is it possible to put internal Asterisk database in RAMdisk (tmpfs) for > performance and save other persistence database in another database? > 2-Is there any HA solution ? (Active /Standby, keepalived) > 3-Is there any automatic two way file(database) synchronization utility ? > > Regards > M.Shirazi > > ------------------------------ ------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > ______________________________ _________________ > Astlinux-users mailing list > Astlinux-users@lists. sourceforge.net > https://lists.sourceforge.net/ lists/listinfo/astlinux-users > > Donations to support AstLinux are graciously accepted via PayPal to > pay...@krisk.org. > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Astlinux-users mailing list > Astlinux-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/astlinux-users > > Donations to support AstLinux are graciously accepted via PayPal to > pay...@krisk.org. > > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Astlinux-users mailing list > Astlinux-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/astlinux-users > > Donations to support AstLinux are graciously accepted via PayPal to > pay...@krisk.org. > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! > http://sdm.link/slashdot_______________________________________________ > Astlinux-users mailing list > Astlinux-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/astlinux-users > > Donations to support AstLinux are graciously accepted via PayPal to > pay...@krisk.org. ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Astlinux-users mailing list Astlinux-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/astlinux-users Donations to support AstLinux are graciously accepted via PayPal to pay...@krisk.org.
