Virtual server specific SQL schema.

[Stephen Fulton]

Hi Stefan,

Thanks for the suggestion, that's actually my back-up plan.  The key issue is 
that a single MySQL server will be used, and peak-load on that server can be 
quite high.  By creating multiple instances, I cannot scale the maximum number 
of sockets high enough meet the requirements.  Perhaps on missing something with 
regard to MySQL optimization, but during testing I found increasing the maximum 
number of sockets was necessary to meet the performance requirements.

-- Stephen


On 6/15/2010 15:20, Stefan A. wrote:
> Stephen,
>
> what's about using instances in the sql.conf like
>
> sql sql_virtual_1{
> 	database = "mysql"
> 	driver = "rlm_sql_${database}"
> 	server = "dbcnode2"
> 	port="3306"
> 	login = "user"
> 	password = "pw"
> 	radius_db = "dbname"
> 	...all the other stuff...
> }
>
> Having several such sections, you'd be able to call them in cour virtual
> server as
>
> authorize {
> 	preprocess
> 	chap
> 	mschap
> 	suffix
> 	eap {
> 		ok = return
> 	}
> 	unix
> -->	sql_virtual_1	
> 	files
> 	expiration
> 	logintime
> 	pap
> }
>
>
> You only have to exchange the values of
> 	server = "dbcnode2"
> 	port="3306"
> 	login = "user"
> 	password = "pw"
>
> for each instance...
>
>
>
>
> Does this help?
> Stefan
>
>
>
>> -----Original Message-----
>> From: freeradius-users-
>> bounces+a.freeradius=premit.de at lists.freeradius.org [mailto:freeradius-
>> users-bounces+a.freeradius=premit.de at lists.freeradius.org] On Behalf Of
>> Stephen Fulton
>> Sent: Tuesday, June 15, 2010 8:43 PM
>> To: freeradius user
>> Subject: Virtual server specific SQL schema.
>>
>> Greetings,
>>
>> I am building an FR server using a shared MySQL database that will have
>> multiple
>> virtual servers.  Each of the virtual servers needs to use different
>> radcheck
>> and radacct tables, each of which has a unique name (eg. radcheck1,
>> radcheck2).
>>    The stated preference is that a single database be used, and the
>> different
>> tables reside within.  For performance reasons, I would rather specify
>> the DB
>> server specific parameters (hostname, user/pass, maximum number of
>> sockets etc)
>> globally.
>>
>> My question:  Is it possible to use a global DB configuration as
>> outlined above,
>> but call the schema specific info from within a virtual server?
>>
>> Thanks,
>>
>> -- Stephen
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html