[Asterisk-Users] Asterisk and LCR

[Damon Estep]

> How about  this:
> 
> 1. Put all the routes of  all the providers in a MySQL table
> 2. Write a script with a 'clever' algorithm to find out cheapest route
of
> each prefix.

Are you saying realtime mysql is not clever? That is exactly what it is
supposed to do.


> 3. Based on #2..  make a lcr_cheapest_route.conf
> 4. include lcr_cheapest_route.conf in extension.conf

That is what we are doing, 3 minute reloads!
> 
> But I don't know, how much resource asterisk will take after loading
> lcr_cheapest_route.conf
> Also, I don't have any idea about the performance would be.
> 
> What do you think?
> 
> Thanks
> 
> 
> 
> > -----Original Message-----
> > From: asterisk at lists.styx.org
> > Sent: Tue, 16 Aug 2005 12:57:14 -0400
> > To: asterisk-users at lists.digium.com
> > Subject: Re: [Asterisk-Users] Asterisk and LCR
> >
> > On Tue, Aug 16, 2005 at 10:22:01AM -0600, Damon Estep wrote:
> > >
> > > Any input from others that have already done what I am doing would
be
> > > helpful, what works best?
> >
> > For 100k routes+, you will have trouble holding them in a SQL
database,
> > particularly if your route selection query is complex. With a modern
PC
> > running PostgreSQL, you'll run into trouble at around 250k BHCA even
> with
> > a much smaller number of routes. (This is quite apart from Asterisk
> > itself,
> > try writing a simple program that runs sample queries in a loop,
perhaps
> > with several threads. To a certain extent it depends on how you
write
> the
> > query and how judiciously you place indexes on the tables) When you
want
> > NPANXX granularity from several carriers (commonly 75-100k routes
each)
> > you'll get hit even worse.
> >
> > In my experience the safe limits of this approach are about a 2x DS3
> > worth of traffic with 10,000 routes in the table... After that
you've
> got
> > to pull everything into RAM and write a clever route selection
> > algorithm...
> >
> > -w
> > --
> > William Waites
> > ww -NO at SPAM- magicphone.ca
> > _______________________________________________
> > 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