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 <[EMAIL PROTECTED]>
To: Asterisk Users Mailing List - Non-Commercial Discussion <[email protected]>
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

[EMAIL PROTECTED] 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
[email protected]
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
[email protected]
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
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to