On Fri, Sep 22, 2017, at 02:12 PM, Ryan Wagoner 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.
It was chosen not just because of that but also because to a user there's nothing they need to do to set it up or have it work - you just run Asterisk and off it goes. I'm more curious over why they didn't use func_odbc instead but chose to use AstDB. Perhaps for similar reasons. -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org -- _____________________________________________________________________ -- 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