[asterisk-dev] AstDB mySQL implementation

[Joshua Colp]

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