[Asterisk-Users] voicemail.conf from DB

[Preston Garrison]

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