bind + mysql

[Brad Knowles]

At 10:49 AM -0400 7/5/01, Forrest Aldrich wrote:

>  There are many design issues involved here (and possibly
>  scalability/performance).  The schema being one of them, and whether to use
>  one or more databases, etc. etc.

	Yup.

>  Before BIND-9 hooks, there was the sql-bind project, which ceased.  Some
>  experience from that might be worth looking at.

	Also agreed.

>  I wonder how MySQL would peform in a high I/O situation like this.    I
>  know of a company that began using MySQL (a while ago) in radius
>  transactions, but eventually they had to go with Oracle, due to performance
>  reasons.  That may not be an issue now, with the newer hardware and
>  features of MySQL.

	At my former employer, we used MySQL with the Radiator RADIUS 
database package.  Our real problem was not MySQL (even with millions 
of records), but with the lossy nature of the UDP RADIUS protocol. 
We found that putting remote RADIUS servers at the POPs and then 
having them use our central database server tended to work much 
better.  However, we were only able to do this in the case of one 
POP, and the others were seriously suffering from drops, retransmits, 
storms, etc....

	This was for something like 650-700k customers at the time that 
were using our dial-in facilities (which we actually leased from 
Belgacom, the former PTT of Belgium, and still primarily state-owned).


	I don't know how many queries per second we were getting, 
however.  My guess is that you're not talking about anything remotely 
close to hundreds of RADIUS database accesses per second, so you'd 
need to find some other way to provide that order of magnitude 
scaling improvement for the database side.

-- 
Brad Knowles, <brad.knowles at skynet.be>

/*        efdtt.c  Author:  Charles M. Hannum <root at ihack.net>          */
/*       Represented as 1045 digit prime number by Phil Carmody         */
/*     Prime as DNS cname chain by Roy Arends and Walter Belgers        */
/*                                                                      */
/*     Usage is:  cat title-key scrambled.vob | efdtt >clear.vob        */
/*   where title-key = "153 2 8 105 225" or other similar 5-byte key    */

dig decss.friet.org|perl -ne'if(/^x/){s/[x.]//g;print pack(H124,$_)}'