(RADIATOR) Questions about MySQL and Oracle

[Hugh Irvine]

Hello Julio -

On Monday 11 June 2001 21:45, julio.prada at bt.es wrote:
> Hello all,
>
> we use SessionDatabase SQL with a MySQL instance in a server, and a
> Radiator 2.18.2 server.
>
> We are thinkig about including an extra Radiator server.
>
> In fact, both Radiator servers will share the same database which are in
> the MySQL server (pool table, accounting table ...)
>

This is the correct approach.

>
> - Could this 'sharing' cause any problem to the Radiator servers behaviour?
>
> - Has anybody implemented this architecture of one centralized database
> server for a Radiator 'farm'?
>

Many Radiator users employ exactly this architecture.

>
>
> In the second hand,
>
> we are trying to migrate MySQL implementation to Oracle. Our performance
> obtained in MySQL (100 req/sec) has been decreased with Oracle
> substantially.
>
> We are reviewing indexes, database tunning, queries and so on. For example,
> we're trying to do the 'limit 1' feature with MySQL in the Oracle database.
>
> - Has anyone experience with improving performance with Radiator-Oracle?
> Any advices?
>

I have copied this mail to Mike for his comments on relative SQL performance.

regards

Hugh


-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.