> On 26 Oct 2017, at 15:20, Nir Simionovich <nir.simionov...@gmail.com> wrote: > > Just looked into the code, this is not a simple task to put a new backend for > astdb. The code isn't even designed > for something like that. Judging from what I can tell, and tell me if I'm > wrong - turning this into a configurable thing > would be more or less an open-heart surgery. My patch wasn’t that bad, but it was before sqlite.
/O > > > > On Thu, Oct 26, 2017 at 4:16 PM Olle E. Johansson <o...@edvina.net > <mailto:o...@edvina.net>> wrote: > 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 >> <mailto: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 <tel:073-255-7799> (MSN): >> n...@greenfieldtech.net <mailto:n...@greenfieldtech.net> >> (m) +972-54-6982826 <tel:054-698-2826> (GTALK): >> nir.simionov...@gmail.com <mailto:nir.simionov...@gmail.com> >> (f) +972-73-2557202 <tel:073-255-7202> (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 >> <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> > -- > _____________________________________________________________________ > -- 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