Summary:ASTERISK-16401: [patch] [branch] AppleRaisin - ASTDB over realtime
Reporter:Olle Johansson (oej)Labels:patch
Date Opened:2010-07-22 03:50:58Date Closed:
Versions:Frequency of
Environment:Attachments:( 0) db.c.patch
( 1) db-trunk.c.patch
( 2) db-trunk-corrected.c.patch
Description:My branch "codename-appleraisin-trunk" contains code for running ASTDB over realtime. The 1.4 version (adb-codename-appleraisin) has been in production for over a year running under FreePBX for failover.

This branch needs some assistance through code review and also addition of some missing features in the CLI commands for managing astdb, something that was out of scope for this project.

I think this would be a good addition for 1.8, but it will need assistance from other developers to get through the process.
Comments:By: Leif Madsen (lmadsen) 2010-07-22 08:58:51

This seems a bit late to be brought up for 1.8...

By: Leif Madsen (lmadsen) 2010-07-26 09:56:00

We should probably get this one up on reviewboard as well.

By: Leif Madsen (lmadsen) 2010-07-26 10:09:42

This is a candidate for going into 1.8.0 if we can get proper testing, documentation, and code review over the next week or two.

By: Philippe Lindheimer (p_lindheimer) 2010-08-09 09:39:18

This has been tested for a year. The concept is very straight forward if a simple layer has been implemented and all the astdb calls remain the same. Since it is optional, it would also seem to put minimal risk/impact on existing systems not taking advantage of it.

Given how valuable this can be to so many applications, particularly in light of the number of internal Asterisk applications that are hard coded to astdb and give no reasonable alternative db storage, this addition would be an invaluable addition for 1.8.

Applications like FreePBX and iSymphony could make tremendous use of such applications given the current limitations that require all astdb access to be done through the manager which sometimes becomes very problematic on large/busy systems.

By: Ruben Sousa (rdsousa) 2010-12-06 11:11:27.000-0600

We use AstDB in MySQL with FreePBX in production for 2 years here in Portugal for about 400 servers. It's very helpful to the high availability mecanism. In order to upgrade to 1.8 we definitely need this feature.

Please get it in 1.8. Thanks.

By: Philippe Lindheimer (p_lindheimer) 2011-04-02 18:45:07

trying to see what the status of this is and what testing is needed to help make sure it gets into 1.10 since it's a shame it did not make it into 1.8. From a FreePBX perspective, we'd like to start looking at this more closely and maybe planning on moving towards it in the future if all looks good.

By: Mikael Carlsson (mickecarlsson) 2011-04-03 02:27:49

I second the motion. From a high availability solution, this needs to get merged in.

By: Mikael Carlsson (mickecarlsson) 2011-04-07 15:22:30

I added a patch to db.c from oej's appleraisin. Patch is against svn for 1.8

By: Malcolm Davenport (mdavenport) 2011-06-01 13:35:48

Added patch against trunk.

By: Leif Madsen (lmadsen) 2011-06-01 14:00:24

If we can get this reviewed and signed off by someone, then I'm ok with this going in 1.10.

By: Mikael Carlsson (mickecarlsson) 2011-06-01 15:18:57

I have uploaded a new and corrected patch. I removed the text about Asterisk core if more than 2000 entries, this was a bug in res_mysql that was fixed in issue 19090.

I also added code to fix a bug found during testing, oej has updated his branch, see revision 317669