[asterisk-dev] MySQL vs MariaDB

[Matthew Jordan]

On 01/24/2013 08:05 AM, Bruce Ferrell wrote:
> On 01/24/2013 05:54 AM, Jared Smith wrote:
>> On Thu, Jan 24, 2013 at 8:47 AM, Bruce Ferrell <bferrell at baywinds.org>
>> wrote:
>>> With various distros either moving to or considering a move to
>>> MariaDB, are
>>> there thoughts on Asterisk compatibility with MariaDB?
>>>
>>> I'm almost certain some will say that ODBC renders the issue moot,
>>> but I'm
>>> not so certain about that.
>> Maybe I'm not up to speed on MariaDB as much as I should be, but it's
>> my understanding that MariaDB is a drop-in replacement for MySQL --
>> same ABI, same data directory, and so forth.  Am I mistaken?
> It's supposed to be.  It's on my agenda to attempt in the next week or
> so and see what happens.  Just wondering what thought(s) might be put
> into this and what I may need to know to get it to build
> 

The current MySQL integration modules in Asterisk are, unfortunately,
relatively unsupported by the community. There have been discussions
about this in the past (originated by a discussion regarding the
deprecation of said modules - see [1]), but to date there hasn't been a
lot of movement on those issues [2]. This may be because developers
haven't personally run into the issue; the issue is complex and hard to
reproduce (there's at least one memory corruption in the mix); or no one
feels like supporting them any longer. This is not an indictment or a
means to cast blame; it's just the reality of the situation.

As Tilghman and others have noted, focusing efforts on supporting the
ODBC modules means that we can provide reliable database integration
that works (generally) with everything. This gives us the most bang for
the buck, and keeps us from attempting to support everyone and actually
supporting no one.

Now, if someone would like to (a) write drivers to support MariaDB
(which may be just improving on the existing MySQL ones), (b) fix the
issues in the existing MySQL drivers (if necessary), and (c) commit to
being the module maintainer for said modules, I'd be happy to see them
in Asterisk.

[1] http://lists.digium.com/pipermail/asterisk-dev/2012-July/055988.html

[2] To see the bugs, run the following query in Jira: project=ASTERISK
and component in ("Addons/app_mysql", "Addons/cdr_mysql",
"Addons/res_config_mysql") and status=Open

Matt

-- 
Matthew Jordan
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at: http://digium.com & http://asterisk.org