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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> >To: Asterisk Users Mailing List - Non-Commercial Discussion ><asterisk-users@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 > >[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 >> Asterisk-Users@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@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@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@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