replace astdb with a cluster-capable sql databaseengine

3 msg	dialplan logic questions: macro not reachingDIA...
2 msg	1.6.beta5 (format 0x40 (slin))
26 msg	Microsoft Office Communications Server
3 msg	What replaces Macro() now? And how do you do th...
1 msg	Local music on hold -- mohinterpret=passthrough...
1 msg	phones start ringing randomly with GrandstreamG...
1 msg	Re: replace astdb with a cluster-capablesql dat...
1 msg	Realtime error - PgSQL with 1.6 beta 5
15 msg	Read function
6 msg	How Do I continue after Dial Command ??
8 msg	PRI suppliers in Switzerland

replace astdb with a cluster-capable sql databa...
\ Vieri (8 Mar 2008)
. \ Bruce Reeves (8 Mar 2008)
. . \ Vieri (9 Mar 2008)
. . . \ Tzafrir Cohen (9 Mar 2008)
. \ Atis Lezdins (9 Mar 2008)
. . \ Vieri (9 Mar 2008)
. . . \ Tilghman Lesher (9 Mar 2008)
. . \ Rob Hillis (9 Mar 2008)
. \ Vieri (9 Mar 2008)
. . \ Vieri (10 Mar 2008)
. . . \ Philipp von Klitzing (11 Mar 2008)

2 msg	I am now on Refriendz!
3 msg	Experiences with grandstream GXW 4024 FXS?
3 msg	Sync Problem (astribank)
1 msg	Motorola SBV5220
4 msg	sip show channels - gives a growing list of dea...
1 msg	VoiceMail dialout context
1 msg	How to get call back during attendant transfer?
2 msg	WirelessIP5000 SIP registration problem

Subject:	replace astdb with a cluster-capable sql databaseengine
Group:	Asterisk-users
From:	Vieri
Date:	8 Mar 2008

I've been searching the Internet for information
regarding the replacement of astdb with a modern sql
engine.

There are several reasons one would like to do this.
First of all, external applications have a hard time
reading/writing to the now-old astdb format.
Also (and this is what interests me most), the sql
astdb could easily be clustered throughout several
servers (I'm looking for a master-master MySQL
2-server cluster solution).

Asterisk has brought up Realtime which is very
powerful but, correct me if I'm wrong, it still
requires astdb internally. In other words, if I call
Set(DB) in the dialplan then it will always be using
astdb regardless of realtime.

Some projects like Callweaver have forked from
Asterisk 1.2 and replaced astdb with sqlite.

I'm wondering if Asterisk has plans to allow the user
to choose the astdb backend: standard db1, sqlite,
MySQL (which I would use with nbcluster for my
clustering purposes), Postgresql with Slony-II,
PGcluster, etc.

Or is it already possible?

There has been some talk on this before:
http://lists.digium.com/pipermail/asterisk-dev/2004-December/007846.html

Also, the func_odbc feature seems to be very powerful:
http://www.asteriskpbx.org/func_odbc
but:
1) would there be potential issues with db handles on
a very busy asterisk system after a relatively long
run time?
2) would there be a way to "map" the odbc function(s)
to the DB functions (Set(DB), read and write, DBdel,
etc) so that rewriting the whole dialplan would not be
necessary? (that's the whole point of defining a
different astdb "backend")

If there are known
problems/issues/projects/alternatives then please let
me know.

Thanks

________________________________________________________________________________ ____
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users