Somewhere in Asterisk space, there’s an old patch where I added ASTDB over realtime, meaning you can use any realtime storage. If I remember correctly there was a bit of chicken-and-egg problem with some astdb calls happening before realtime got launched, but otherwise it worked just fine in production for a long time.
/O > On 26 Oct 2017, at 15:13, Nir Simionovich <nir.simionov...@gmail.com> wrote: > > I'd like to +1 on that idea. > > While I'm somewhat reluctant to using mySQL as the base of such a change, as > mySQL is an overkill for AstDB, > having a proper AstDB configurable backend is an interesting thing. > Personally speaking, I would actually prefer > something like Memcache or preferably Redis. Both are similar in function and > usability to AstDB, both are fairly > scalable (Redis specifically) and both are fairly simplistic in nature. > > I do admit that this got me intrigued... > > > > On Tue, Sep 26, 2017 at 12:45 AM Matt Fredrickson <cres...@digium.com > <mailto:cres...@digium.com>> wrote: > On Fri, Sep 22, 2017 at 12:12 PM, Ryan Wagoner <rswago...@gmail.com > <mailto:rswago...@gmail.com>> wrote: > I've been scaling out FreePBX horizontally with Kamailio and custom FreePBX > modules mainly to handle call center outbound dialing (around 20k calls per > day). One of the issues I ran into was FreePBX uses the AstDB extensively and > will write changes to it from the dialplan or the FreePBX user control panel. > > To overcome this I either needed to scrap FreePBX and build a new GUI using > Asterisk realtime, heavily modify FreePBX (not an option), or rewrite AstDB > to use a database like mySQL. I choose the last option and have had the code > in production for just over a month. I'm backing it with a two node MariaDB > Galera cluster with HAProxy providing failover for the client DB connections. > > I realize that SQLite was chosen for AstDB for performance reasons. However > mySQL seems to perform just fine in the above scenario. Right now I have a > db.c file that just has the mySQL code. Does anybody else have any interest > in using mySQL for the AstDB backend? I'm debating if it would make sense to > have the option to select your AstDB backend. > > Hey Ryan, > > First off, thanks for letting us know about the fun project you embarked > upon. I think Josh already answered some of your questions, but with regards > to the work you did - I believe that in the past there have been others who > have wanted an ODBC AstDB driver as well. If your code can be made > configurable, it may be a good contribution. > > Anyways, hope you are doing well, and perhaps we'll see your code up on > gerrit at some time in the future. :-) > > -- > Matthew Fredrickson > Digium, Inc. | Engineering Manager > 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com > <http://www.api-digital.com/> -- > > asterisk-dev mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-dev > <http://lists.digium.com/mailman/listinfo/asterisk-dev> > -- > Kind Regards, > Nir Simionovich > GreenfieldTech > (schedule) http://nirsimionovich.appointy.com/ > <http://nirsimionovich.appointy.com/> > (w) http://www.greenfieldtech.net <http://www.greenfieldtech.net/> > (p) +972-73-2557799 (MSN): n...@greenfieldtech.net > <mailto:n...@greenfieldtech.net> > (m) +972-54-6982826 (GTALK): nir.simionov...@gmail.com > <mailto:nir.simionov...@gmail.com> > (f) +972-73-2557202 (SKYPE): greenfieldtech.nir > > ---------------------------------------------------------- > Zero Your Inbox <https://mailstrom.co/referral/ARZJE> | Cloud > Servers <https://www.digitalocean.com/?refcode=97eeea09917a> > ---------------------------------------------------------- > > Disclaimer: > This e-mail is intended solely for the person to whom it is addressed and may > contain confidential or legally privileged information. Access to this e-mail > by anyone else is unauthorized. If an addressing or transmission error has > misdirected this e-mail, please notify the author by replying to this e-mail > and destroy this e-mail and any attachments. > E-mail may be susceptible to data corruption, interception, unauthorized > amendment, viruses and delays or the consequences thereof. If you are not the > intended recipient, be advised that you have received this email in error and > that any use, dissemination, forwarding, printing or copying of this email is > strictly prohibited. > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-dev mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-dev
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-dev mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-dev