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-
[email protected] [mailto:freeradius-
[email protected]] 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
