[Asterisk-Users] voicemail.conf from DB

[Iqbal]

and running mysql with master slave config, can also allow load balancing
on the queries, but the problem is I just cant get it too work :-)

Iqbal

On 5/16/2005, "Preston Garrison" <preston at mailblocks.com> wrote:

>Actually using voicemail from db is alot smarter then using SIP from
>the database.  But that is mostly due to the fact that realtime queries
>the database 4 times everytime it needs a sip record.  Also mysql
>doesn't keep everything in memory at all.  It only keeps stuff it needs
>to in memory, that it finds itself accessing alot.  The algorithms are
>pretty damn good in mysql about what to keep in memory.
>
>Preston Garrison
>direct: 877-748-4142
>fax: 310-774-3901
>cell: 623-748-4140
>
>-----Original Message-----
>From: Senad J <senad at bicom.us>
>To: Asterisk Users Mailing List - Non-Commercial Discussion
><asterisk-users at lists.digium.com>
>Sent: Mon, 16 May 2005 20:33:32 +0100
>Subject: RE: [Asterisk-Users] voicemail.conf from DB
>
>In my opinion.. using voicemail from DB is not good
>for "scaling up" scenarios... in particular if you need to
>provide HA of five nine... 99.999%
>
>The cluster database (well in particular MYSQL puts everything in
>RAM)... so
>as the user base grows.. so does RAM requirement...
>
>Ta
>Senad
>
>asterisk-users-bounces at lists.digium.com wrote:
>> Hi
>>
>> I have been playing with trying to get voicemail.conf from DB, I am
>> using cvs-head, but when I start asterisk, it dies a horrible death,
>> because it cant load any voicemil setting.
>>
>> I looked at my mysql logs to see what query was being sent, and I get
>>
>> SELECT category, var_name, var_val, cat_metric FROM voicemail_users
>> WHERE filename='voicemail.conf' and commented=0 ORDER BY filename,
>> cat_metric desc, var_metric asc, category, var_name, var_val, id;
>>
>> which is in no way related to the table I created following the
>> example on the wiki.
>>
>> Is there another table format , I have
>>
>>
>+-------------+---------------+------+-----+---------+----------------+
>>> Field       | Type          | Null | Key | Default | Extra          |
>>
>+-------------+---------------+------+-----+---------+----------------+
>>> uniqueid    | int(11)       |      | PRI | NULL    | auto_increment |
>>> customer_id | int(11)       |      |     | 0       |                |
>>> context     | varchar(50)   |      |     |         |                |
>>> mailbox     | int(5)        |      | MUL | 0       |                |
>>> password    | varchar(4)    |      |     | 0       |                |
>>> fullname    | varchar(50)   |      |     |         |                |
>>> email       | varchar(50)   |      |     |         |                |
>>> pager       | varchar(50)   |      |     |         |                |
>>> stamp       | timestamp(14) | YES  |     | NULL    |                |
>>
>+-------------+---------------+------+-----+---------+----------------+
>>
>>
>> tks
>> Iqbal
>> _______________________________________________
>> Asterisk-Users mailing list
>> Asterisk-Users at lists.digium.com
>> http://lists.digium.com/mailman/listinfo/asterisk-users
>> To UNSUBSCRIBE or update options visit:
>>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>