> On 26 Oct 2017, at 15:25, Nir Simionovich <nir.simionov...@gmail.com> wrote: > > I suspect the original code didn't change the overall mechanism dramatically, > it's mainly a new implementation. > This thing is this - replacing the implementation seems straight forward > enough, making it configurable, seems > like a pain in the butt. Look for the “appleraisin” branch if you want to see code :-)
/O > > > > On Thu, Oct 26, 2017 at 4:23 PM Olle E. Johansson <o...@edvina.net > <mailto:o...@edvina.net>> wrote: >> On 26 Oct 2017, at 15:20, Nir Simionovich <nir.simionov...@gmail.com >> <mailto: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 <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