<div dir="ltr">G'day listers,<br>Well, I just found this one:<br><br><a href="http://svn.digium.com/view/asterisk/team/russell/events/doc/distributed_devstate.txt?view=markup">http://svn.digium.com/view/asterisk/team/russell/events/doc/distributed_devstate.txt?view=markup</a><br>
<br>Time to read.<br><br><br><div class="gmail_quote">On Tue, Sep 9, 2008 at 2:29 PM, Nguyen <span dir="ltr"><<a href="mailto:chinhnam.nguyen@gmail.com">chinhnam.nguyen@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Dear Tilghman,<br>
<br>
Thanks for your feedback. Scratching my head to see how to turn the<br>
standalone box to something more scalable. func_odbc , mysql in<br>
dialplan, all are missing the states of devices, agents... etc<br>
<br>
Realtime, as far as it goes, also touch only one part of asterisk, by<br>
storing all the reginfo in db. If we want to move further, and<br>
touching the states, we have to dig in.<br>
<br>
We understand that for asterisk as it is, local db1 is good enough.<br>
Maybe Digium can take another look at the problem.<br>
<br>
Will keep you in touch with progress, if any :)<br>
<div><div></div><div class="Wj3C7c"><br>
<br>
<br>
On 9/9/08, Tilghman Lesher <<a href="mailto:tilghman@mail.jeffandtilghman.com">tilghman@mail.jeffandtilghman.com</a>> wrote:<br>
> On Monday 08 September 2008 12:43:53 Nguyen wrote:<br>
>> Hi listers,<br>
>><br>
>> We want to implement one call center with asterisk. The idea is it should<br>
>> be scalable, with openser as an dispatcher and bunch of asterisk servers<br>
>> to<br>
>> do ACD, Queues, Agents things... Easy to say :(<br>
>><br>
>> Look closely to the current asterisk, we do see some problem:<br>
>><br>
>> - SIP registrations was stored in astdb.<br>
>> - And queue members also was stored in astdb.<br>
>> - ...<br>
>><br>
>> asterisk was built as standalone PBX, so it's understandable.<br>
>><br>
>> Is it time to replace astdb with something like MySQL, so all asterisk<br>
>> boxes in cluster can have identical access to all the informations,<br>
>> devstates, etc...?<br>
>><br>
>> Our first thought is replacing the astdb implementation, currently with<br>
>> DB1, with MySQL. app_dbodbc is a hint, but there are still many things to<br>
>> consider: concurrency access from many box to same row, performance<br>
>> issues,<br>
>> ...<br>
>><br>
>> We need your pointers here. Where are the caveats? Is it the correct way<br>
>> to<br>
>> start add clustering capabilities to asterisk?<br>
>><br>
>> Your replies are much appreciated,<br>
><br>
> There are some very major issues with trying to replace astdb with any other<br>
> backend. One possibility which has been floated is to replace the DB1<br>
> implementation with sqlite, as the backend is still a Berkeley database,<br>
> while<br>
> having the advantages of a SQL interface layer. An implementation has been<br>
> coded, though we've held off on committing such a change until we have the<br>
> ability to convert an old db1-based database to a sqlite-based database.<br>
><br>
> I would highly recommend, though, that you do not attempt to replace db1<br>
> with<br>
> MySQL for this purpose. There are some higher level databases where it may<br>
> make good sense to go with MySQL as your backend (such as for Realtime<br>
> database maintenance), but astdb is most certainly not one of them.<br>
><br>
> In addition, you may want to look at func_odbc for an additional interface<br>
> from the dialplan to your database.<br>
><br>
> --<br>
> Tilghman<br>
><br>
> _______________________________________________<br>
> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
><br>
> AstriCon 2008 - September 22 - 25 Phoenix, Arizona<br>
> Register Now: <a href="http://www.astricon.net" target="_blank">http://www.astricon.net</a><br>
><br>
> asterisk-users mailing list<br>
> To UNSUBSCRIBE or update options visit:<br>
> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
><br>
<br>
<br>
</div></div>--<br>
With best regards,<br>
<font color="#888888">Nguyen<br>
</font></blockquote></div><br><br clear="all"><br>-- <br>With best regards,<br>Nguyen<br>
</div>