[Serusers] Multiple Registration Servers

[Iqbal]

Also if possible do a quick debug on slow queries in mysql, to see if 
any of the tables might be ndexed incorrectly.

Iqbal

Greger V. Teigre wrote:

> As several people have pointed out, you have a bottleneck somewhere in 
> your system.  I have not seen numbers on the penalty you get for using 
> mysql for authentication, I wouldn't think it is much. However, if you 
> get hundreds if registration attempts simultaneously, you will reach 
> the limit, sooner or later. I would guess you get your problems with 
> the database lookups.  Try hitting mysql with a high load directly and 
> performance tune mysql. Take a look at this:
> http://dev.mysql.com/doc/mysql/en/server-parameters.html
> You should most definitely increase max_connections as mentioned 
> earlier. Also, with 4,000 accounts, mysql should be able to cache all 
> the users.
>
> Would appreciate you reporting back to your list on your results!
> g-)
>
>
> Darren Nay wrote:
>
>> Hey All,
>>
>> This is a long email, so please bare with me...
>>
>> Up until now we have used our primary SER serve as both registrar and
>> call routing engine.  However, we've recently hit a growth point
>> where the registration load on our servers is high enough that it's
>> affecting our call routing.
>>
>> We currently have about 4,000 IAD's all registering every 5 minutes.
>> This works out to be almost 13.5 regs every second, which in itself
>> is a lot .. If they were sequential.  However, at times we will get
>> hundreds of IADs all attempting to register simultaneously (within
>> seconds of each other) and it will keep the server busy for a few
>> moments and cause SIP timeouts on calls that are in the process of
>> being setup.
>>
>> Currently I am using the auth_db module with MySQL for client
>> registration authentication.  I believe that the MySQL authentication
>> is what is causing the high load on the server.
>>
>> What I want to do is try to offload the the registrations from our
>> primary routing server, yet, I need the primary server to be stateful
>> of the all registered clients.
>> -or-
>> Find a more efficient way to authenticate client registrations so
>> that the load is not so high.
>>
>> Problem is that most of our customers are home-based VoIP telephone
>> customers behind a Linksys cable/DSL router.  So, in order to avoid
>> NAT issues we must have all of our traffic which terminates to the
>> IAD from our PSTN provider come from the same IP address that the the
>> IAD registered from.  So I can't use another server and then
>> t_replicate the requests back to the routing server .. Because then
>> the registrar /  IP address that will be open on the customers router
>> NAT gateway / firewall will differ from the IP that will terminate
>> the traffic to the IAD from our system.
>>
>> So - my question is .. How do I take load off of the primary server??
>>
>> Would implementing radius for authentication fix this problem?  I am
>> very familiar with radius (using Freeradius) and could easily set
>> this up, but I would prefer not to go to the trouble if it's not
>> going to help with the load.
>>
>> Has anyone else had an issue with client authentication via MySQL and
>> auth_db causing a high load with SER?
>>
>> I am hoping that you fine folks might be able to point me in the right
>> direction.  Thanks so much!
>>
>> Darren Nay
>> VoIP Network Development
>> Ionosphere, Inc
>> dnay at ionosphere.net
>>
>>
>> _______________________________________________
>> Serusers mailing list
>> serusers at lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers 
>
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
> .
>