Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread Rushowr
 good stuff mate.
 
 a few clarifications:
 you had static extensions.conf, realtime sipusers, etc, right?
 
 Also, abt features like call fwding, etc, which one is better,
 performance wise, using a mysql db, or use Asterisk's internal
 DB(berkeley db, isnt it?using those DBput n DBget ops)??Anyone's got any
 figures for these?
 
 This somewot spoils the fun in Asterisk, when talking of performance, to
 query the DB for every call . Sort of pulls things down. Any comments or
 observations guys?
 
 - Ben.

Ben,

Yes, static extensions.conf, realtime everything else. A realtime
dialplan never made much sense to me, as the dialplan shouldn't (in my
humble opinion) be that fluid anyway, it should be fairly static.

In terms of spoiling the fun and/or performance issues, let me note that
in my current implementation we not only have options being queried but
also realtime billing, permissions, limits, and carrier/trunk
performance data, all being pulled and calculated via the database. I
also have handy little timers returning the length of time it takes to
do the processing from request receipt to dial, and I'm still currently
under 1-2 seconds for entire call preparation including all the logic
that goes along with checking all features, the current account's
account status, balance and limits, AND all parent accounts in it's
billing chain. I haven't done a head to head with the berkley DB, but
I think part of the reason it's so fast is due to the highly normalized
database structure, which allows for efficient query design. It's not
all third form, but almost there :D.

I'm in the last days of ALPHA now with my current project. Once we
launch BETA, which will be a semi-public testing by invitation (Murph,
you still going to participate?), I should be able to find a few minutes
to outline the design.

One other quick thing, the berkley DB doesn't allow for clustering
either, MySQL does. Very nice to have your database distributed across
multiple nodes, makes for an easier time designing the failovers :D

Cheers,
Sherwood

___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread Rushowr
  I would like to know how you got Asterisk to function with 2500 SIP
 registrations.  Did you have qualify enabled?

Yes, qualify was enabled, using the standard length of qualification
period between checks. Very few accounts had custom qualify settings.

 What about the 500 simultaneous calls?  How many SQL hits were you
 doing (all said and done).  Any performance logs from the SQL server?
 
 I can't believe you got all this running on one box!

You have to remember, 500 simultaneous calls is not the same as
something like 20 calls per second. some of those calls may have been
quite long, and once the call's been placed, there's no database work
being done until the call ends.

I wish I had statistics from that setup, but I don't, we spent so much
time implementing new features and chasing down problems caused by using
a pre-RTA version of Asterisk with a patched in RTA setup.



-- 
S McGowan
VoIP Consultant
[EMAIL PROTECTED]

-BEGIN PGP PUBLIC KEY BLOCK-
Version: GnuPG v1.4.5 (MingW32) - WinPT 0.12.3

mQGiBETxLJERBACrFvzk3Hd8AO9aGCSSgoabp8GGS7jYhR1UP9zqYeJIHeH+/r/D
sCL0mPUGX1+FnVlh5UAO0Q3hueCdtgbAhdqMJMDhjQ2Tm10kBWu2DjWrLVnGx0QD
Id1XAiQ1WIJkE2VqphKD0WVMsyxj08w+o+DwjD+mu3GCgitRTVOB9OnzpwCg3Ynx
BHlbNUzLTp+3oUuudndpaiEEAIlBCJoIg+zCTg4/kFjsWfSYo3kTwNoQPqqMINMe
GM15CkRvXgUdMgJMPeEqXNmfnUUHNf/6KD2WpP5kJcBZdNWHicvS+A+P1Sjuybio
5XlJgMDW5tzCX0V45n+RgZQjHMg1wpcv0eVOMhmaSL4eC7MyUnZBHzuBYmgNMpiM
EF2wA/4y+hhoZ2SYUzTWk4QUPL8yaHTNS/4/aH8AB5cyRNljqT5//AXzYF3AxMZX
bslWy4MtzX9CI9Zg8hxIzcaYp/oeFSVrv6Or/8ZRQk2T+eB7ymPY6T+SOcKfTgR2
f9kzlxtPjRK/nXDovjaaOGl0U0NaPemB0w8fEuNkF4LxKdAea7QgUyBNY0dvd2Fu
IDxydXNob3dyQHBocmVha2VyLm5ldD6IYAQTEQIAIAUCRPEskQIbAwYLCQgHAwIE
FQIIAwQWAgMBAh4BAheAAAoJEJX0LL+xQYafrbQAoKFzcLsRIkXWL1wzldi2iG4l
FHD/AKCguGXH7GtZKpQfFct6vQUOnJuUB7kCDQRE8SygEAgAlOYMwiFKPALEpi/X
Cb3kTzpDqi9yvlijssnyxY2IxTYJHheE2dkITtdmgFlfud0lCLiSVhf8i9Y2YCar
I+Djz7/LTlX4lhcDBeAaSHfDUtr5jTn3caK5A3inCAxoI7Um9Sy3fSyW9DMww2Mj
t+ysQ2XuXpRZ984/3X79kNttae7L3FqASHjfflUFhBukxpSAn5evmkAnmZDhjy5a
Z9Ut+DGDQOG2qvDTZM/RFDyodLIRoW9AK2O3A7CtVjZVOTSjDdhdOsHzsuBioh51
ngfUo4B3hDy+tv5qtzD5UjVj8g+oFqDpjo7mj7EwhD/AqHxg6yKqOtVLTmeEdZzW
RMMGkwADBQgAjutKcj73K0GqhlKP3D3plXXBLOeAnoUBMoxbd7u7HigTXkTeq7gX
c+zC6pu3atL1piRBOTYPiflf36hkph+EC9Zu7fBmaIdKRqltV9m+XB5l6Kw/C4go
hTeLFI5A61GmiyQ5NPRpaeERGba+EoWswYIUxkCmr7I02DL8R72oLu6bb+bevCz5
d1AKrY2Vg3M8IXhGHPrYoFup6EYC6Thp2wRG4vBtpQStFbdYjXNBYmwWNERPzOzb
k3pU8y96X7mqLHbv6gi5wapJyPidasc3VtU7RrwSEsYDoc2nf+6KzZMTT3rnB9RL
gns2mcXM/4utmBWzSL7tnil5mlI9dynHQYhJBBgRAgAJBQJE8SygAhsMAAoJEJX0
LL+xQYafclwAnAmrmJpITi7ngFNR/obx/l6tNPRqAJ477VYqaBg58lc+TlGK1DoA
HeMrow==
=GJrg
-END PGP PUBLIC KEY BLOCK-



___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread burke
   I would like to know how you got Asterisk to function with 2500 SIP
 registrations.  Did you have qualify enabled?

 Yes, qualify was enabled, using the standard length of qualification
 period between checks. Very few accounts had custom qualify settings.

 What about the 500 simultaneous calls?  How many SQL hits were you
 doing (all said and done).  Any performance logs from the SQL server?

 I can't believe you got all this running on one box!

 You have to remember, 500 simultaneous calls is not the same as
 something like 20 calls per second. some of those calls may have been
 quite long, and once the call's been placed, there's no database work
 being done until the call ends.

 I wish I had statistics from that setup, but I don't, we spent so much
 time implementing new features and chasing down problems caused by using
 a pre-RTA version of Asterisk with a patched in RTA setup.



 --
 S McGowan
 VoIP Consultant
 [EMAIL PROTECTED]


S McGowan,

I don't know if you missed my question (from the slew of questions you've
received and answered), but I was wondering about transcoding and PSTN
channels. What kind of codecs were used and was there any transcoding
happening? Was this box only responsible for VoIP-to-VoIP calls or was
there also PSTN trunks as well? Again, I'm amazed by this example since it
seems to be way over what anyone else normally reports as usable.

Thanks again,
Ryan
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread Rushowr
 S McGowan,
 
 I don't know if you missed my question (from the slew of questions you've
 received and answered), but I was wondering about transcoding and PSTN
 channels. What kind of codecs were used and was there any transcoding
 happening? Was this box only responsible for VoIP-to-VoIP calls or was
 there also PSTN trunks as well? Again, I'm amazed by this example since it
 seems to be way over what anyone else normally reports as usable.
 
 Thanks again,
 Ryan


Ryan, I answered, but for some reason this pop account tends to be
strange... Anyway, we were not doing any transcoding and our PSTN
connectivity was handled via a Tier 1 ISP that does SIP only PSTN
connectivity solutions with G.711u. So, basically as far as Asterisk was
concerned, there was SIP and RDP, that's all.


___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread Kristian Kielhofner

Rushowr wrote:

S McGowan,

I don't know if you missed my question (from the slew of questions you've
received and answered), but I was wondering about transcoding and PSTN
channels. What kind of codecs were used and was there any transcoding
happening? Was this box only responsible for VoIP-to-VoIP calls or was
there also PSTN trunks as well? Again, I'm amazed by this example since it
seems to be way over what anyone else normally reports as usable.

Thanks again,
Ryan




Ryan, I answered, but for some reason this pop account tends to be
strange... Anyway, we were not doing any transcoding and our PSTN
connectivity was handled via a Tier 1 ISP that does SIP only PSTN
connectivity solutions with G.711u. So, basically as far as Asterisk was
concerned, there was SIP and RDP, that's all.



	So there was 2500 SIP registrations with qualify, 500 active calls with 
SIP and RTP, realtime, and CDR logging via MySQL (all on the same box)?


What source changes did you make?  What OS tweaks?

--
Kristian Kielhofner
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread Kristian Kielhofner

[EMAIL PROTECTED] wrote:

Again, I'm amazed by this example since it

seems to be way over what anyone else normally reports as usable.


Exactly!

--
Kristian Kielhofner
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread adebayo omo-dare
Hi Sheerwood,   I unfortunately saw a bit of what I percieve to be an error in what you said. BerkeleyDB does in fact support replication across nodes - see: http://www.sleepycat.com/docs/ref/rep/intro.html- possibly you meant to say the version implemented in * does not support replication. If so, I do appoligise for beinga little pedantic.I have only just started to look at *'s code - so what I say further is with a great deal of hesitation when directly referenced to *. However, I work with both Berkely (on a programming level)and MySQL in a telecom (soft-switch) environment.In terms of performance (judged as speed), a comparison between MySQL and Berkeley would be like comparing a top of the range Mercedes to an F1 racing car. Overheads from MySQL come in the form of SQL translation, use of Sockets, etc... This
 is in addition to its size.Yet, the choice between the two, is a lot more complex, IMHO, than mereley thinking in terms of performance. And possible High Availability solutions, in their own rights, taking in to consideration that * will be workingin concert with numerous otherenvironments,programmes and requirments,are diverse enough to make each deployment a little unique - thereby making each option a potential liability.One rule of thumb for us has always been - if you need raw speed, and intend to deal with the data in a very restricted/rigid/"well defined"manner - opt for Berkeley. But if you want a great deal of fluidity, and intend, or may at some time intend,for that data to interact with other applications and potential requirements -Opt MySQL.It is possibly also best to work with what you feel most comfortable with first and
 then experiment to see if you may require the services of the other.ps. In terms of querying a DB for every call, I would presume that a DB is an active and fragilething and the provision of ACID ensures that everything that occurs with it does sowith a certain measure of safety. In fact, due to the random manner of requests, you will find it, in complete terms,actually performs a lot better than any other form of retrieval.Hope this, in some manner,helps  Bayo  Rushowr [EMAIL PROTECTED] wrote:   good stuff mate.  a few clarifications: you had static "extensions.conf", realtime "sipusers", etc, right?  Also, abt features like call fwding, etc, which one is better, performance
 wise, using a mysql db, or use Asterisk's internal DB(berkeley db, isnt it?using those DBput n DBget ops)??Anyone's got any figures for these?  This somewot spoils the fun in Asterisk, when talking of performance, to query the DB for every call . Sort of pulls things down. Any comments or observations guys?  - Ben.Ben,Yes, static extensions.conf, realtime everything else. A realtimedialplan never made much sense to me, as the dialplan shouldn't (in myhumble opinion) be that fluid anyway, it should be fairly static.In terms of spoiling the fun and/or performance issues, let me note thatin my current implementation we not only have options being queried butalso realtime billing, permissions, limits, and carrier/trunkperformance data, all being pulled and calculated via the database. Ialso have handy little timers returning the length of time it takes todo the
 processing from request receipt to dial, and I'm still currentlyunder 1-2 seconds for entire call preparation including all the logicthat goes along with checking all features, the current account'saccount status, balance and limits, AND all parent accounts in it's"billing chain". I haven't done a head to head with the berkley DB, butI think part of the reason it's so fast is due to the highly normalizeddatabase structure, which allows for efficient query design. It's notall third form, but almost there :D.I'm in the last days of ALPHA now with my current project. Once welaunch BETA, which will be a semi-public testing by invitation (Murph,you still going to participate?), I should be able to find a few minutesto outline the design.One other quick thing, the berkley DB doesn't allow for clusteringeither, MySQL does. Very nice to have your database distributed acrossmultiple nodes, makes for an easier time
 designing the failovers :DCheers,Sherwood___--Bandwidth and Colocation provided by Easynews.com --asterisk-users mailing listTo UNSUBSCRIBE or update options visit:http://lists.digium.com/mailman/listinfo/asterisk-users 
		 
Now you can scan emails quickly with a reading pane. Get the new Yahoo! Mail.___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread Tzafrir Cohen
On Wed, Sep 20, 2006 at 03:57:07PM +0100, adebayo omo-dare wrote:
 Hi Sheerwood, 
   I unfortunately saw a bit of what I percieve to be an error in what 
 you said. BerkeleyDB does in fact support replication across nodes - 
 see: http://www.sleepycat.com/docs/ref/rep/intro.html - possibly you 
 meant to say the version implemented in * does not support replication. 
 If so, I do appoligise for being a little pedantic.


The version in Asterisk is the last one before the relicense to the
Sleepycat license. 1.86 (?), and not 4.

-- 
Tzafrir Cohen sip:[EMAIL PROTECTED]
icq#16849755  iax:[EMAIL PROTECTED]
+972-50-7952406  jabber:[EMAIL PROTECTED]
[EMAIL PROTECTED] http://www.xorcom.com
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread Jay R. Ashworth
On Wed, Sep 20, 2006 at 10:26:25AM +0530, Benjamin Jacob wrote:
 This somewot spoils the fun in Asterisk, when talking of performance, to 
 query the DB for every call . Sort of pulls things down. Any comments or 
 observations guys?

Well, my personal observation is that if you can't make your DBMS be
about 6 orders of magnitude faster than your people, you're either not
trying very hard...

or you're trying to replicate a 5ESS-2000 using Asterisk, which is
similarly silly.  :-)

Cheers,
-- jra
-- 
Jay R. Ashworth[EMAIL PROTECTED]
Designer  Baylink RFC 2100
Ashworth  AssociatesThe Things I Think'87 e24
St Petersburg FL USA  http://baylink.pitas.com +1 727 647 1274

That's women for you; you divorce them, and 10 years later,
  they stop having sex with you.  -- Jennifer Crusie; _Fast_Women_
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread Rushowr
Kristian Kielhofner wrote:
 Rushowr wrote:
 S McGowan,

 I don't know if you missed my question (from the slew of questions
 you've
 received and answered), but I was wondering about transcoding and PSTN
 channels. What kind of codecs were used and was there any transcoding
 happening? Was this box only responsible for VoIP-to-VoIP calls or was
 there also PSTN trunks as well? Again, I'm amazed by this example
 since it
 seems to be way over what anyone else normally reports as usable.

 Thanks again,
 Ryan



 Ryan, I answered, but for some reason this pop account tends to be
 strange... Anyway, we were not doing any transcoding and our PSTN
 connectivity was handled via a Tier 1 ISP that does SIP only PSTN
 connectivity solutions with G.711u. So, basically as far as Asterisk was
 concerned, there was SIP and RDP, that's all.

 
 So there was 2500 SIP registrations with qualify, 500 active calls
 with SIP and RTP, realtime, and CDR logging via MySQL (all on the same
 box)?
 
 What source changes did you make?  What OS tweaks?
 
 -- 
 Kristian Kielhofner
 ___
 --Bandwidth and Colocation provided by Easynews.com --
 
 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
 

None, literally. CentOS 4.3, Asterisk Trunk that was updated practically
weekly, at least on the dev box. The production server wouldn't get
recompiled unless a fix was in from trunk.

Incidentally, I just doublechecked my numbers with my former co-worker.
He confirms we had roughly the following numbers/setup:

*2,500 registered SIP users, 95% being qualified by Asterisk
*Max of 300 concurrent calls, with about half that on average (my
mistake  earlier with the 500 estimation)
*Realtime SIP Users/Peers, Voicemail, and dialplan calls
*Static extensions with MySQL queries for data retrieval/manipulation
*NO Reinvites allowed due to the fact that most clients were residential
behind NAT.

Hardware:
CPU:Dual 3Ghz XEON
RAM:2GB RAM



-- 
S McGowan
VoIP Consultant
[EMAIL PROTECTED]

-BEGIN PGP PUBLIC KEY BLOCK-
Version: GnuPG v1.4.5 (MingW32) - WinPT 0.12.3

mQGiBETxLJERBACrFvzk3Hd8AO9aGCSSgoabp8GGS7jYhR1UP9zqYeJIHeH+/r/D
sCL0mPUGX1+FnVlh5UAO0Q3hueCdtgbAhdqMJMDhjQ2Tm10kBWu2DjWrLVnGx0QD
Id1XAiQ1WIJkE2VqphKD0WVMsyxj08w+o+DwjD+mu3GCgitRTVOB9OnzpwCg3Ynx
BHlbNUzLTp+3oUuudndpaiEEAIlBCJoIg+zCTg4/kFjsWfSYo3kTwNoQPqqMINMe
GM15CkRvXgUdMgJMPeEqXNmfnUUHNf/6KD2WpP5kJcBZdNWHicvS+A+P1Sjuybio
5XlJgMDW5tzCX0V45n+RgZQjHMg1wpcv0eVOMhmaSL4eC7MyUnZBHzuBYmgNMpiM
EF2wA/4y+hhoZ2SYUzTWk4QUPL8yaHTNS/4/aH8AB5cyRNljqT5//AXzYF3AxMZX
bslWy4MtzX9CI9Zg8hxIzcaYp/oeFSVrv6Or/8ZRQk2T+eB7ymPY6T+SOcKfTgR2
f9kzlxtPjRK/nXDovjaaOGl0U0NaPemB0w8fEuNkF4LxKdAea7QgUyBNY0dvd2Fu
IDxydXNob3dyQHBocmVha2VyLm5ldD6IYAQTEQIAIAUCRPEskQIbAwYLCQgHAwIE
FQIIAwQWAgMBAh4BAheAAAoJEJX0LL+xQYafrbQAoKFzcLsRIkXWL1wzldi2iG4l
FHD/AKCguGXH7GtZKpQfFct6vQUOnJuUB7kCDQRE8SygEAgAlOYMwiFKPALEpi/X
Cb3kTzpDqi9yvlijssnyxY2IxTYJHheE2dkITtdmgFlfud0lCLiSVhf8i9Y2YCar
I+Djz7/LTlX4lhcDBeAaSHfDUtr5jTn3caK5A3inCAxoI7Um9Sy3fSyW9DMww2Mj
t+ysQ2XuXpRZ984/3X79kNttae7L3FqASHjfflUFhBukxpSAn5evmkAnmZDhjy5a
Z9Ut+DGDQOG2qvDTZM/RFDyodLIRoW9AK2O3A7CtVjZVOTSjDdhdOsHzsuBioh51
ngfUo4B3hDy+tv5qtzD5UjVj8g+oFqDpjo7mj7EwhD/AqHxg6yKqOtVLTmeEdZzW
RMMGkwADBQgAjutKcj73K0GqhlKP3D3plXXBLOeAnoUBMoxbd7u7HigTXkTeq7gX
c+zC6pu3atL1piRBOTYPiflf36hkph+EC9Zu7fBmaIdKRqltV9m+XB5l6Kw/C4go
hTeLFI5A61GmiyQ5NPRpaeERGba+EoWswYIUxkCmr7I02DL8R72oLu6bb+bevCz5
d1AKrY2Vg3M8IXhGHPrYoFup6EYC6Thp2wRG4vBtpQStFbdYjXNBYmwWNERPzOzb
k3pU8y96X7mqLHbv6gi5wapJyPidasc3VtU7RrwSEsYDoc2nf+6KzZMTT3rnB9RL
gns2mcXM/4utmBWzSL7tnil5mlI9dynHQYhJBBgRAgAJBQJE8SygAhsMAAoJEJX0
LL+xQYafclwAnAmrmJpITi7ngFNR/obx/l6tNPRqAJ477VYqaBg58lc+TlGK1DoA
HeMrow==
=GJrg
-END PGP PUBLIC KEY BLOCK-





signature.asc
Description: OpenPGP digital signature
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread Rushowr
adebayo omo-dare wrote:
 Hi Sheerwood,
 I unfortunately saw a bit of what I percieve to be an error in what you
 said. BerkeleyDB does in fact support replication across nodes - see:
 http://www.sleepycat.com/docs/ref/rep/intro.html - possibly you meant to
 say the version implemented in * does not support replication. If so, I
 do appoligise for being a little pedantic.
  
 I have only just started to look at *'s code - so what I say further is
 with a great deal of hesitation when directly referenced to *. However,
 I work with both Berkely (on a programming level) and MySQL in a telecom
 (soft-switch) environment.
  
 In terms of performance (judged as speed), a comparison between MySQL
 and Berkeley would be like comparing a top of the range Mercedes to an
 F1 racing car. Overheads from MySQL come in the form of SQL translation,
 use of Sockets, etc... This is in addition to its size.
  
 Yet, the choice between the two, is a lot more complex, IMHO, than
 mereley thinking in terms of performance. And possible High Availability
 solutions, in their own rights, taking in to consideration that * will
 be working in concert with numerous other environments, programmes and
 requirments, are diverse enough to make each deployment a little unique
 - thereby making each option a potential liability.
  
 One rule of thumb for us has always been - if you need raw speed, and
 intend to deal with the data in a very restricted/rigid/well
 defined manner - opt for Berkeley. But if you want a great deal of
 fluidity, and intend, or may at some time intend, for that data to
 interact with other applications and potential requirements - Opt MySQL.
  
 It is possibly also best to work with what you feel most comfortable
 with first and then experiment to see if you may require the services of
 the other.
  
 ps. In terms of querying a DB for every call, I would presume that a DB
 is an active and fragile thing and the provision of ACID ensures that
 everything that occurs with it does so with a certain measure of safety.
 In fact, due to the random manner of requests, you will find it, in
 complete terms, actually performs a lot better than any other form of
 retrieval.
  
 Hope this, in some manner, helps
 Bayo

Bayo,
Thanks for your input! I was actually not aware that Berkley DB allowed
replication.

The primary reason for using MySQL (and PostgreSQL in some of my other
projects) is the ease with which you can have the data used in other
systems.

Thanks again for your input :)



signature.asc
Description: OpenPGP digital signature
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-20 Thread Rushowr
Kristian Kielhofner wrote:
 [EMAIL PROTECTED] wrote:
 
 Again, I'm amazed by this example since it
 seems to be way over what anyone else normally reports as usable.
 
 Exactly!
 
 -- 
 Kristian Kielhofner
 ___
 --Bandwidth and Colocation provided by Easynews.com --
 
 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
 

Well, first of all, how many people are attempting to run an entire ITSP
off of Asterisk? Also, how many of those reports you refer to are SIP
only? There's amazingly little system utilization when all you're doing
is processing the call requests and logging CDRs?

Past that, I can't say anything more to convince you all that this is
true without sounding like I'm trying too hard for belief. I'd release
the name of the ITSP (some of you may remember it anyway) that I used to
work for, and once the one I currently work for goes ahead into public
release I'll be more than glad to share the name.


-- 
S McGowan
VoIP Consultant
[EMAIL PROTECTED]

-BEGIN PGP PUBLIC KEY BLOCK-
Version: GnuPG v1.4.5 (MingW32) - WinPT 0.12.3

mQGiBETxLJERBACrFvzk3Hd8AO9aGCSSgoabp8GGS7jYhR1UP9zqYeJIHeH+/r/D
sCL0mPUGX1+FnVlh5UAO0Q3hueCdtgbAhdqMJMDhjQ2Tm10kBWu2DjWrLVnGx0QD
Id1XAiQ1WIJkE2VqphKD0WVMsyxj08w+o+DwjD+mu3GCgitRTVOB9OnzpwCg3Ynx
BHlbNUzLTp+3oUuudndpaiEEAIlBCJoIg+zCTg4/kFjsWfSYo3kTwNoQPqqMINMe
GM15CkRvXgUdMgJMPeEqXNmfnUUHNf/6KD2WpP5kJcBZdNWHicvS+A+P1Sjuybio
5XlJgMDW5tzCX0V45n+RgZQjHMg1wpcv0eVOMhmaSL4eC7MyUnZBHzuBYmgNMpiM
EF2wA/4y+hhoZ2SYUzTWk4QUPL8yaHTNS/4/aH8AB5cyRNljqT5//AXzYF3AxMZX
bslWy4MtzX9CI9Zg8hxIzcaYp/oeFSVrv6Or/8ZRQk2T+eB7ymPY6T+SOcKfTgR2
f9kzlxtPjRK/nXDovjaaOGl0U0NaPemB0w8fEuNkF4LxKdAea7QgUyBNY0dvd2Fu
IDxydXNob3dyQHBocmVha2VyLm5ldD6IYAQTEQIAIAUCRPEskQIbAwYLCQgHAwIE
FQIIAwQWAgMBAh4BAheAAAoJEJX0LL+xQYafrbQAoKFzcLsRIkXWL1wzldi2iG4l
FHD/AKCguGXH7GtZKpQfFct6vQUOnJuUB7kCDQRE8SygEAgAlOYMwiFKPALEpi/X
Cb3kTzpDqi9yvlijssnyxY2IxTYJHheE2dkITtdmgFlfud0lCLiSVhf8i9Y2YCar
I+Djz7/LTlX4lhcDBeAaSHfDUtr5jTn3caK5A3inCAxoI7Um9Sy3fSyW9DMww2Mj
t+ysQ2XuXpRZ984/3X79kNttae7L3FqASHjfflUFhBukxpSAn5evmkAnmZDhjy5a
Z9Ut+DGDQOG2qvDTZM/RFDyodLIRoW9AK2O3A7CtVjZVOTSjDdhdOsHzsuBioh51
ngfUo4B3hDy+tv5qtzD5UjVj8g+oFqDpjo7mj7EwhD/AqHxg6yKqOtVLTmeEdZzW
RMMGkwADBQgAjutKcj73K0GqhlKP3D3plXXBLOeAnoUBMoxbd7u7HigTXkTeq7gX
c+zC6pu3atL1piRBOTYPiflf36hkph+EC9Zu7fBmaIdKRqltV9m+XB5l6Kw/C4go
hTeLFI5A61GmiyQ5NPRpaeERGba+EoWswYIUxkCmr7I02DL8R72oLu6bb+bevCz5
d1AKrY2Vg3M8IXhGHPrYoFup6EYC6Thp2wRG4vBtpQStFbdYjXNBYmwWNERPzOzb
k3pU8y96X7mqLHbv6gi5wapJyPidasc3VtU7RrwSEsYDoc2nf+6KzZMTT3rnB9RL
gns2mcXM/4utmBWzSL7tnil5mlI9dynHQYhJBBgRAgAJBQJE8SygAhsMAAoJEJX0
LL+xQYafclwAnAmrmJpITi7ngFNR/obx/l6tNPRqAJ477VYqaBg58lc+TlGK1DoA
HeMrow==
=GJrg
-END PGP PUBLIC KEY BLOCK-




___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-19 Thread Benjamin Jacob

Rushowr wrote:


___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

 





Date:
Tue, 19 Sep 2006 05:52:52 -0500




Marco Mouta wrote:
 


Hi all,

I'm planing to develop a solution based on Asterisk for about 300 users.
My question now is, do I really need to use openSER as the sip proxy and
Asterisk for the PBX functions?

Can i trust in a solution only with Asterisk to make all this install?

Please help me with your experience on this kind of asterisk solutions.

I've googled and read about asterisk at large scale solutions, but still
in doubt.
http://www.voip-info.org/wiki-Asterisk+at+large


--
Com os melhores cumprimentos,

Marco Mouta




___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users
   



In my experience, yes you can use *just* asterisk for the implementation
of a large scale setup, you just better be sure you've planned it out
well. I've set up a few large scale Asterisk implementations, covering
more than 1K users on a single box. And that was in 2005 using trunk.
There were problems, but all in all it was (and is, for the former
client) not a bad implementation. If you're just looking at a large PBX
install, you're definitely fine with a well planned system.

Just my $0.02, not to be taken as a guarantee ;-)


 

You mean, 1 K simultaneous calls? or 1 K registered users(yes yes. this 
is the one!!)???


___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-19 Thread Rushowr
Benjamin Jacob wrote:
 Rushowr wrote:
 
 ___
 --Bandwidth and Colocation provided by Easynews.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

  


 

 Date:
 Tue, 19 Sep 2006 05:52:52 -0500


 

 Marco Mouta wrote:
  

 Hi all,

 I'm planing to develop a solution based on Asterisk for about 300 users.
 My question now is, do I really need to use openSER as the sip proxy and
 Asterisk for the PBX functions?

 Can i trust in a solution only with Asterisk to make all this install?

 Please help me with your experience on this kind of asterisk solutions.

 I've googled and read about asterisk at large scale solutions, but still
 in doubt.
 http://www.voip-info.org/wiki-Asterisk+at+large


 -- 
 Com os melhores cumprimentos,

 Marco Mouta


 

 ___
 --Bandwidth and Colocation provided by Easynews.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
   

 In my experience, yes you can use *just* asterisk for the implementation
 of a large scale setup, you just better be sure you've planned it out
 well. I've set up a few large scale Asterisk implementations, covering
 more than 1K users on a single box. And that was in 2005 using trunk.
 There were problems, but all in all it was (and is, for the former
 client) not a bad implementation. If you're just looking at a large PBX
 install, you're definitely fine with a well planned system.

 Just my $0.02, not to be taken as a guarantee ;-)


  

 You mean, 1 K simultaneous calls? or 1 K registered users(yes yes. this
 is the one!!)???
 
 ___
 --Bandwidth and Colocation provided by Easynews.com --
 
 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users
 

Sorry, should have been a little more specific. I've had Asterisk
running realtime SIP users/peers and realtime sql calls from the
dialplan (all with MySQL), and have had around 2.5k registered users and
a peak (that I recall) of around 500 concurrent calls.

-- 
S McGowan
VoIP Consultant
[EMAIL PROTECTED]

-BEGIN PGP PUBLIC KEY BLOCK-
Version: GnuPG v1.4.5 (MingW32) - WinPT 0.12.3

mQGiBETxLJERBACrFvzk3Hd8AO9aGCSSgoabp8GGS7jYhR1UP9zqYeJIHeH+/r/D
sCL0mPUGX1+FnVlh5UAO0Q3hueCdtgbAhdqMJMDhjQ2Tm10kBWu2DjWrLVnGx0QD
Id1XAiQ1WIJkE2VqphKD0WVMsyxj08w+o+DwjD+mu3GCgitRTVOB9OnzpwCg3Ynx
BHlbNUzLTp+3oUuudndpaiEEAIlBCJoIg+zCTg4/kFjsWfSYo3kTwNoQPqqMINMe
GM15CkRvXgUdMgJMPeEqXNmfnUUHNf/6KD2WpP5kJcBZdNWHicvS+A+P1Sjuybio
5XlJgMDW5tzCX0V45n+RgZQjHMg1wpcv0eVOMhmaSL4eC7MyUnZBHzuBYmgNMpiM
EF2wA/4y+hhoZ2SYUzTWk4QUPL8yaHTNS/4/aH8AB5cyRNljqT5//AXzYF3AxMZX
bslWy4MtzX9CI9Zg8hxIzcaYp/oeFSVrv6Or/8ZRQk2T+eB7ymPY6T+SOcKfTgR2
f9kzlxtPjRK/nXDovjaaOGl0U0NaPemB0w8fEuNkF4LxKdAea7QgUyBNY0dvd2Fu
IDxydXNob3dyQHBocmVha2VyLm5ldD6IYAQTEQIAIAUCRPEskQIbAwYLCQgHAwIE
FQIIAwQWAgMBAh4BAheAAAoJEJX0LL+xQYafrbQAoKFzcLsRIkXWL1wzldi2iG4l
FHD/AKCguGXH7GtZKpQfFct6vQUOnJuUB7kCDQRE8SygEAgAlOYMwiFKPALEpi/X
Cb3kTzpDqi9yvlijssnyxY2IxTYJHheE2dkITtdmgFlfud0lCLiSVhf8i9Y2YCar
I+Djz7/LTlX4lhcDBeAaSHfDUtr5jTn3caK5A3inCAxoI7Um9Sy3fSyW9DMww2Mj
t+ysQ2XuXpRZ984/3X79kNttae7L3FqASHjfflUFhBukxpSAn5evmkAnmZDhjy5a
Z9Ut+DGDQOG2qvDTZM/RFDyodLIRoW9AK2O3A7CtVjZVOTSjDdhdOsHzsuBioh51
ngfUo4B3hDy+tv5qtzD5UjVj8g+oFqDpjo7mj7EwhD/AqHxg6yKqOtVLTmeEdZzW
RMMGkwADBQgAjutKcj73K0GqhlKP3D3plXXBLOeAnoUBMoxbd7u7HigTXkTeq7gX
c+zC6pu3atL1piRBOTYPiflf36hkph+EC9Zu7fBmaIdKRqltV9m+XB5l6Kw/C4go
hTeLFI5A61GmiyQ5NPRpaeERGba+EoWswYIUxkCmr7I02DL8R72oLu6bb+bevCz5
d1AKrY2Vg3M8IXhGHPrYoFup6EYC6Thp2wRG4vBtpQStFbdYjXNBYmwWNERPzOzb
k3pU8y96X7mqLHbv6gi5wapJyPidasc3VtU7RrwSEsYDoc2nf+6KzZMTT3rnB9RL
gns2mcXM/4utmBWzSL7tnil5mlI9dynHQYhJBBgRAgAJBQJE8SygAhsMAAoJEJX0
LL+xQYafclwAnAmrmJpITi7ngFNR/obx/l6tNPRqAJ477VYqaBg58lc+TlGK1DoA
HeMrow==
=GJrg
-END PGP PUBLIC KEY BLOCK-





signature.asc
Description: OpenPGP digital signature
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-19 Thread burke
 Benjamin Jacob wrote:
 Rushowr wrote:

 ___
 --Bandwidth and Colocation provided by Easynews.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users




 

 Date:
 Tue, 19 Sep 2006 05:52:52 -0500


 

 Marco Mouta wrote:


 Hi all,

 I'm planing to develop a solution based on Asterisk for about 300
 users.
 My question now is, do I really need to use openSER as the sip proxy
 and
 Asterisk for the PBX functions?

 Can i trust in a solution only with Asterisk to make all this install?

 Please help me with your experience on this kind of asterisk
 solutions.

 I've googled and read about asterisk at large scale solutions, but
 still
 in doubt.
 http://www.voip-info.org/wiki-Asterisk+at+large


 --
 Com os melhores cumprimentos,

 Marco Mouta


 

 ___
 --Bandwidth and Colocation provided by Easynews.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


 In my experience, yes you can use *just* asterisk for the
 implementation
 of a large scale setup, you just better be sure you've planned it out
 well. I've set up a few large scale Asterisk implementations, covering
 more than 1K users on a single box. And that was in 2005 using trunk.
 There were problems, but all in all it was (and is, for the former
 client) not a bad implementation. If you're just looking at a large PBX
 install, you're definitely fine with a well planned system.

 Just my $0.02, not to be taken as a guarantee ;-)




 You mean, 1 K simultaneous calls? or 1 K registered users(yes yes. this
 is the one!!)???

 ___
 --Bandwidth and Colocation provided by Easynews.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


 Sorry, should have been a little more specific. I've had Asterisk
 running realtime SIP users/peers and realtime sql calls from the
 dialplan (all with MySQL), and have had around 2.5k registered users and
 a peak (that I recall) of around 500 concurrent calls.

 --
 S McGowan
 VoIP Consultant
 [EMAIL PROTECTED]


Can you explain your design in a little more detail? What kind of hardware
did you use to get over 1k users on a single box and 500 concurrent calls?
Sounds like a very interesting medium-large scale implementation that
others could learn from.

thanks,
Ryan
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-19 Thread Rushowr
Ryan wrote:
 Can you explain your design in a little more detail? What kind of hardware
 did you use to get over 1k users on a single box and 500 concurrent calls?
 Sounds like a very interesting medium-large scale implementation that
 others could learn from.
 
 thanks,
 Ryan 


I'll do the best I can from memory and without violating confidentiality :)

The build was for a startup ITSP and was the first of that scale that
either myself or my associate who worked for the client had done. The
hardware was something along these lines, but I cannot be absolutely sure:

3Ghz Dual XEON CPU
1GB RAM
2 1Gb NICs

I dont remember the hard drive specs at all, but that's more elementary
anyway.

We initially set up the systems with CentOS 4.2 or 4.3, can't remember.
MySQL 4.x (latest 4.x version from summer 2005)
Asterisk HEAD (constantly updating and recompiling, at the time the
realtime arch wasn't fully in place)
MySQL addons package
Realtime SIP clients
Statically configured SIP trunks, which provided our PSTN connections.
I cannot disclose the company, but the trunk provider is/was extremely
huge, a Tier 1 ISP.
MySQL CDRs (the cdr addon)
User options and feature controls accessed in realtime via a MySQL table
 designated for the purpose (basically an options table, with things
like call_forward (y/n) columns).
LOTS of custom monitoring done in regards to Asterisk status information
Custom PHP/MySQL/Apache web interface for provisioning, configuration,
and general administration written by yours truly, including polling
Asterisk for the status of a client UA when that client's config is
being viewed, provisioning (TFTP) handlers, etc...

Hope this is a good start, anything else you want to know, I'll do my best.

Also, once I finish my latest ITSP launch project, I'll be able to
(hopefully) give a better example, one with failover, custom CDRs,
custom LeastCost+BestPerformance routing, etc...etc... Even realtime
billing, which the previous client didn't have, AND reseller support at
the ITSP levelcan't say more yet, but it'll be rather huge I'm sure.
-- 
S McGowan
VoIP Consultant
[EMAIL PROTECTED]

-BEGIN PGP PUBLIC KEY BLOCK-
Version: GnuPG v1.4.5 (MingW32) - WinPT 0.12.3

mQGiBETxLJERBACrFvzk3Hd8AO9aGCSSgoabp8GGS7jYhR1UP9zqYeJIHeH+/r/D
sCL0mPUGX1+FnVlh5UAO0Q3hueCdtgbAhdqMJMDhjQ2Tm10kBWu2DjWrLVnGx0QD
Id1XAiQ1WIJkE2VqphKD0WVMsyxj08w+o+DwjD+mu3GCgitRTVOB9OnzpwCg3Ynx
BHlbNUzLTp+3oUuudndpaiEEAIlBCJoIg+zCTg4/kFjsWfSYo3kTwNoQPqqMINMe
GM15CkRvXgUdMgJMPeEqXNmfnUUHNf/6KD2WpP5kJcBZdNWHicvS+A+P1Sjuybio
5XlJgMDW5tzCX0V45n+RgZQjHMg1wpcv0eVOMhmaSL4eC7MyUnZBHzuBYmgNMpiM
EF2wA/4y+hhoZ2SYUzTWk4QUPL8yaHTNS/4/aH8AB5cyRNljqT5//AXzYF3AxMZX
bslWy4MtzX9CI9Zg8hxIzcaYp/oeFSVrv6Or/8ZRQk2T+eB7ymPY6T+SOcKfTgR2
f9kzlxtPjRK/nXDovjaaOGl0U0NaPemB0w8fEuNkF4LxKdAea7QgUyBNY0dvd2Fu
IDxydXNob3dyQHBocmVha2VyLm5ldD6IYAQTEQIAIAUCRPEskQIbAwYLCQgHAwIE
FQIIAwQWAgMBAh4BAheAAAoJEJX0LL+xQYafrbQAoKFzcLsRIkXWL1wzldi2iG4l
FHD/AKCguGXH7GtZKpQfFct6vQUOnJuUB7kCDQRE8SygEAgAlOYMwiFKPALEpi/X
Cb3kTzpDqi9yvlijssnyxY2IxTYJHheE2dkITtdmgFlfud0lCLiSVhf8i9Y2YCar
I+Djz7/LTlX4lhcDBeAaSHfDUtr5jTn3caK5A3inCAxoI7Um9Sy3fSyW9DMww2Mj
t+ysQ2XuXpRZ984/3X79kNttae7L3FqASHjfflUFhBukxpSAn5evmkAnmZDhjy5a
Z9Ut+DGDQOG2qvDTZM/RFDyodLIRoW9AK2O3A7CtVjZVOTSjDdhdOsHzsuBioh51
ngfUo4B3hDy+tv5qtzD5UjVj8g+oFqDpjo7mj7EwhD/AqHxg6yKqOtVLTmeEdZzW
RMMGkwADBQgAjutKcj73K0GqhlKP3D3plXXBLOeAnoUBMoxbd7u7HigTXkTeq7gX
c+zC6pu3atL1piRBOTYPiflf36hkph+EC9Zu7fBmaIdKRqltV9m+XB5l6Kw/C4go
hTeLFI5A61GmiyQ5NPRpaeERGba+EoWswYIUxkCmr7I02DL8R72oLu6bb+bevCz5
d1AKrY2Vg3M8IXhGHPrYoFup6EYC6Thp2wRG4vBtpQStFbdYjXNBYmwWNERPzOzb
k3pU8y96X7mqLHbv6gi5wapJyPidasc3VtU7RrwSEsYDoc2nf+6KzZMTT3rnB9RL
gns2mcXM/4utmBWzSL7tnil5mlI9dynHQYhJBBgRAgAJBQJE8SygAhsMAAoJEJX0
LL+xQYafclwAnAmrmJpITi7ngFNR/obx/l6tNPRqAJ477VYqaBg58lc+TlGK1DoA
HeMrow==
=GJrg
-END PGP PUBLIC KEY BLOCK-





signature.asc
Description: OpenPGP digital signature
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-19 Thread Rushowr
[EMAIL PROTECTED] wrote:

 Can you explain your design in a little more detail? What kind of hardware
 did you use to get over 1k users on a single box and 500 concurrent calls?
 Sounds like a very interesting medium-large scale implementation that
 others could learn from.
 
 thanks,
 Ryan

(NOTE: I sent the original reply about 3 hours ago and have not seen it
post, so I'm resending. I apologize for any double receipts of the message.)

I'll do the best I can from memory and without violating confidentiality
 :)

The build was for a startup ITSP and was the first of that scale that
either myself or my associate who worked for the client had done. The
hardware was something along these lines, but I cannot be absolutely sure:

3Ghz Dual XEON CPU
1GB RAM
2 1Gb NICs

I dont remember the hard drive specs at all, but that's more elementary
anyway.

We initially set up the systems with CentOS 4.2 or 4.3, can't remember.
MySQL 4.x (latest 4.x version from summer 2005)
Asterisk HEAD (constantly updating and recompiling, at the time the
realtime arch wasn't fully in place)
MySQL addons package
Realtime SIP clients
Statically configured SIP trunks, which provided our PSTN connections.
I cannot disclose the company, but the trunk provider is/was extremely
huge, a Tier 1 ISP.
MySQL CDRs (the cdr addon)
User options and feature controls accessed in realtime via a MySQL table
 designated for the purpose (basically an options table, with things
like call_forward (y/n) columns).
LOTS of custom monitoring done in regards to Asterisk status information
Custom PHP/MySQL/Apache web interface for provisioning, configuration,
and general administration written by yours truly, including polling
Asterisk for the status of a client UA when that client's config is
being viewed, provisioning (TFTP) handlers, etc...

Hope this is a good start, anything else you want to know, I'll do my best.

Also, once I finish my latest ITSP launch project, I'll be able to
(hopefully) give a better example, one with failover, custom CDRs,
custom LeastCost+BestPerformance routing, etc...etc... Even realtime
billing, which the previous client didn't have, AND reseller support at
the ITSP levelcan't say more yet, but it'll be rather huge I'm sure.


-- 
S McGowan
VoIP Consultant
[EMAIL PROTECTED]

-BEGIN PGP PUBLIC KEY BLOCK-
Version: GnuPG v1.4.5 (MingW32) - WinPT 0.12.3

mQGiBETxLJERBACrFvzk3Hd8AO9aGCSSgoabp8GGS7jYhR1UP9zqYeJIHeH+/r/D
sCL0mPUGX1+FnVlh5UAO0Q3hueCdtgbAhdqMJMDhjQ2Tm10kBWu2DjWrLVnGx0QD
Id1XAiQ1WIJkE2VqphKD0WVMsyxj08w+o+DwjD+mu3GCgitRTVOB9OnzpwCg3Ynx
BHlbNUzLTp+3oUuudndpaiEEAIlBCJoIg+zCTg4/kFjsWfSYo3kTwNoQPqqMINMe
GM15CkRvXgUdMgJMPeEqXNmfnUUHNf/6KD2WpP5kJcBZdNWHicvS+A+P1Sjuybio
5XlJgMDW5tzCX0V45n+RgZQjHMg1wpcv0eVOMhmaSL4eC7MyUnZBHzuBYmgNMpiM
EF2wA/4y+hhoZ2SYUzTWk4QUPL8yaHTNS/4/aH8AB5cyRNljqT5//AXzYF3AxMZX
bslWy4MtzX9CI9Zg8hxIzcaYp/oeFSVrv6Or/8ZRQk2T+eB7ymPY6T+SOcKfTgR2
f9kzlxtPjRK/nXDovjaaOGl0U0NaPemB0w8fEuNkF4LxKdAea7QgUyBNY0dvd2Fu
IDxydXNob3dyQHBocmVha2VyLm5ldD6IYAQTEQIAIAUCRPEskQIbAwYLCQgHAwIE
FQIIAwQWAgMBAh4BAheAAAoJEJX0LL+xQYafrbQAoKFzcLsRIkXWL1wzldi2iG4l
FHD/AKCguGXH7GtZKpQfFct6vQUOnJuUB7kCDQRE8SygEAgAlOYMwiFKPALEpi/X
Cb3kTzpDqi9yvlijssnyxY2IxTYJHheE2dkITtdmgFlfud0lCLiSVhf8i9Y2YCar
I+Djz7/LTlX4lhcDBeAaSHfDUtr5jTn3caK5A3inCAxoI7Um9Sy3fSyW9DMww2Mj
t+ysQ2XuXpRZ984/3X79kNttae7L3FqASHjfflUFhBukxpSAn5evmkAnmZDhjy5a
Z9Ut+DGDQOG2qvDTZM/RFDyodLIRoW9AK2O3A7CtVjZVOTSjDdhdOsHzsuBioh51
ngfUo4B3hDy+tv5qtzD5UjVj8g+oFqDpjo7mj7EwhD/AqHxg6yKqOtVLTmeEdZzW
RMMGkwADBQgAjutKcj73K0GqhlKP3D3plXXBLOeAnoUBMoxbd7u7HigTXkTeq7gX
c+zC6pu3atL1piRBOTYPiflf36hkph+EC9Zu7fBmaIdKRqltV9m+XB5l6Kw/C4go
hTeLFI5A61GmiyQ5NPRpaeERGba+EoWswYIUxkCmr7I02DL8R72oLu6bb+bevCz5
d1AKrY2Vg3M8IXhGHPrYoFup6EYC6Thp2wRG4vBtpQStFbdYjXNBYmwWNERPzOzb
k3pU8y96X7mqLHbv6gi5wapJyPidasc3VtU7RrwSEsYDoc2nf+6KzZMTT3rnB9RL
gns2mcXM/4utmBWzSL7tnil5mlI9dynHQYhJBBgRAgAJBQJE8SygAhsMAAoJEJX0
LL+xQYafclwAnAmrmJpITi7ngFNR/obx/l6tNPRqAJ477VYqaBg58lc+TlGK1DoA
HeMrow==
=GJrg
-END PGP PUBLIC KEY BLOCK-





signature.asc
Description: OpenPGP digital signature
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-19 Thread Benjamin Jacob

Rushowr wrote:


___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

 





Date:
Tue, 19 Sep 2006 23:30:06 -0500




Ryan wrote:
 


Can you explain your design in a little more detail? What kind of hardware
did you use to get over 1k users on a single box and 500 concurrent calls?
Sounds like a very interesting medium-large scale implementation that
others could learn from.

thanks,
Ryan 
   




I'll do the best I can from memory and without violating confidentiality :)

The build was for a startup ITSP and was the first of that scale that
either myself or my associate who worked for the client had done. The
hardware was something along these lines, but I cannot be absolutely sure:

3Ghz Dual XEON CPU
1GB RAM
2 1Gb NICs

I dont remember the hard drive specs at all, but that's more elementary
anyway.

We initially set up the systems with CentOS 4.2 or 4.3, can't remember.
MySQL 4.x (latest 4.x version from summer 2005)
Asterisk HEAD (constantly updating and recompiling, at the time the
realtime arch wasn't fully in place)
MySQL addons package
Realtime SIP clients
Statically configured SIP trunks, which provided our PSTN connections.
I cannot disclose the company, but the trunk provider is/was extremely
huge, a Tier 1 ISP.
MySQL CDRs (the cdr addon)
User options and feature controls accessed in realtime via a MySQL table
designated for the purpose (basically an options table, with things
like call_forward (y/n) columns).
LOTS of custom monitoring done in regards to Asterisk status information
Custom PHP/MySQL/Apache web interface for provisioning, configuration,
and general administration written by yours truly, including polling
Asterisk for the status of a client UA when that client's config is
being viewed, provisioning (TFTP) handlers, etc...

Hope this is a good start, anything else you want to know, I'll do my best.

Also, once I finish my latest ITSP launch project, I'll be able to
(hopefully) give a better example, one with failover, custom CDRs,
custom LeastCost+BestPerformance routing, etc...etc... Even realtime
billing, which the previous client didn't have, AND reseller support at
the ITSP levelcan't say more yet, but it'll be rather huge I'm sure.
 


good stuff mate.

a few clarifications:
you had static extensions.conf, realtime sipusers, etc, right?

Also, abt features like call fwding, etc, which one is better, 
performance wise, using a mysql db, or use Asterisk's internal 
DB(berkeley db, isnt it?using those DBput n DBget ops)??Anyone's got any 
figures for these?


This somewot spoils the fun in Asterisk, when talking of performance, to 
query the DB for every call . Sort of pulls things down. Any comments or 
observations guys?


- Ben.
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-19 Thread Kristian Kielhofner

Benjamin Jacob wrote:

Rushowr wrote:


___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

 





Date:
Tue, 19 Sep 2006 23:30:06 -0500




Ryan wrote:
 

Can you explain your design in a little more detail? What kind of 
hardware
did you use to get over 1k users on a single box and 500 concurrent 
calls?

Sounds like a very interesting medium-large scale implementation that
others could learn from.

thanks,
Ryan   




I'll do the best I can from memory and without violating 
confidentiality :)


The build was for a startup ITSP and was the first of that scale that
either myself or my associate who worked for the client had done. The
hardware was something along these lines, but I cannot be absolutely 
sure:


3Ghz Dual XEON CPU
1GB RAM
2 1Gb NICs

I dont remember the hard drive specs at all, but that's more elementary
anyway.

We initially set up the systems with CentOS 4.2 or 4.3, can't remember.
MySQL 4.x (latest 4.x version from summer 2005)
Asterisk HEAD (constantly updating and recompiling, at the time the
realtime arch wasn't fully in place)
MySQL addons package
Realtime SIP clients
Statically configured SIP trunks, which provided our PSTN connections.
I cannot disclose the company, but the trunk provider is/was extremely
huge, a Tier 1 ISP.
MySQL CDRs (the cdr addon)
User options and feature controls accessed in realtime via a MySQL table
designated for the purpose (basically an options table, with things
like call_forward (y/n) columns).
LOTS of custom monitoring done in regards to Asterisk status information
Custom PHP/MySQL/Apache web interface for provisioning, configuration,
and general administration written by yours truly, including polling
Asterisk for the status of a client UA when that client's config is
being viewed, provisioning (TFTP) handlers, etc...

Hope this is a good start, anything else you want to know, I'll do my 
best.


Also, once I finish my latest ITSP launch project, I'll be able to
(hopefully) give a better example, one with failover, custom CDRs,
custom LeastCost+BestPerformance routing, etc...etc... Even realtime
billing, which the previous client didn't have, AND reseller support at
the ITSP levelcan't say more yet, but it'll be rather huge I'm sure.
 


good stuff mate.

a few clarifications:
you had static extensions.conf, realtime sipusers, etc, right?

Also, abt features like call fwding, etc, which one is better, 
performance wise, using a mysql db, or use Asterisk's internal 
DB(berkeley db, isnt it?using those DBput n DBget ops)??Anyone's got any 
figures for these?


This somewot spoils the fun in Asterisk, when talking of performance, to 
query the DB for every call . Sort of pulls things down. Any comments or 
observations guys?


- Ben.


	I would like to know how you got Asterisk to function with 2500 SIP 
registrations.  Did you have qualify enabled?


	What about the 500 simultaneous calls?  How many SQL hits were you 
doing (all said and done).  Any performance logs from the SQL server?


I can't believe you got all this running on one box!

--
Kristian Kielhofner
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] When does Scalability requests Asterisk to U se SER ?

2006-09-19 Thread Benjamin Jacob

Kristian Kielhofner wrote:


Benjamin Jacob wrote:


Rushowr wrote:


___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

 



 



Date:
Tue, 19 Sep 2006 23:30:06 -0500


 



Ryan wrote:
 

Can you explain your design in a little more detail? What kind of 
hardware
did you use to get over 1k users on a single box and 500 concurrent 
calls?

Sounds like a very interesting medium-large scale implementation that
others could learn from.

thanks,
Ryan   





I'll do the best I can from memory and without violating 
confidentiality :)


The build was for a startup ITSP and was the first of that scale that
either myself or my associate who worked for the client had done. The
hardware was something along these lines, but I cannot be absolutely 
sure:


3Ghz Dual XEON CPU
1GB RAM
2 1Gb NICs

I dont remember the hard drive specs at all, but that's more elementary
anyway.

We initially set up the systems with CentOS 4.2 or 4.3, can't remember.
MySQL 4.x (latest 4.x version from summer 2005)
Asterisk HEAD (constantly updating and recompiling, at the time the
realtime arch wasn't fully in place)
MySQL addons package
Realtime SIP clients
Statically configured SIP trunks, which provided our PSTN 
connections.

I cannot disclose the company, but the trunk provider is/was extremely
huge, a Tier 1 ISP.
MySQL CDRs (the cdr addon)
User options and feature controls accessed in realtime via a MySQL 
table

designated for the purpose (basically an options table, with things
like call_forward (y/n) columns).
LOTS of custom monitoring done in regards to Asterisk status 
information

Custom PHP/MySQL/Apache web interface for provisioning, configuration,
and general administration written by yours truly, including polling
Asterisk for the status of a client UA when that client's config is
being viewed, provisioning (TFTP) handlers, etc...

Hope this is a good start, anything else you want to know, I'll do 
my best.


Also, once I finish my latest ITSP launch project, I'll be able to
(hopefully) give a better example, one with failover, custom CDRs,
custom LeastCost+BestPerformance routing, etc...etc... Even realtime
billing, which the previous client didn't have, AND reseller support at
the ITSP levelcan't say more yet, but it'll be rather huge I'm 
sure.
 


good stuff mate.

a few clarifications:
you had static extensions.conf, realtime sipusers, etc, right?

Also, abt features like call fwding, etc, which one is better, 
performance wise, using a mysql db, or use Asterisk's internal 
DB(berkeley db, isnt it?using those DBput n DBget ops)??Anyone's got 
any figures for these?


This somewot spoils the fun in Asterisk, when talking of performance, 
to query the DB for every call . Sort of pulls things down. Any 
comments or observations guys?


- Ben.



I would like to know how you got Asterisk to function with 2500 
SIP registrations.  Did you have qualify enabled?


What about the 500 simultaneous calls?  How many SQL hits were you 
doing (all said and done).  Any performance logs from the SQL server?


I can't believe you got all this running on one box!

lol... Rushowr(or S McGowan)...  donno abt the SQL hits, but u urself 
being hit with a lot of questions!!

the price one has to pay for knowing things!! ;-)

tuff being a guru!!

___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users