Faking parallelism...

From: Jean-Christophe Boggio <cat_at_creaweb.fr>
Date: Tue, 4 Apr 2000 12:54:51 +0200
Message-ID: <8cchv3$273$1@reader1.fr.uu.net>

Hello,

I have an idea to simulate parallel servers with normal oracle servers but I need more infos :

My application is a web site that has to deal with many simultaneous connections. So we have several Apache/linux boxes that all access the same Oracle server. Parallelism is not possible on our config (we miss OSD libraries for our machines : HP-LH3 servers with NetServer RS12 hotplug hard drive bay, SCSI cards are HP NETRAID 3 SI). We will buy the Parallel server if we get these OSDs but the french tech support is minimalist on OPS.

We use a Linux virtual server as load balancer, working in direct routing (only entering packets pass through the load balancer, the returned data goes direct to the firewall).

My idea is this :

for all read-only queries, use the load balancer to direct a query to one Oracle server or the other (by faking IPs or other technique, this should be no problem).
for write operations I wonder if I can code a procedure that will do the INSERTs/UPDATEs on all the Oracle servers at the same time. I can do this in the PHP code but maybe it's possible from within stored procedures in the Oracle database.

Has anyone used this technique ? Does it work well ? Would you have suggestions, comments on this ? Can we secure the mechanism in nested transactions ?

Many thanks for your help.

JC Boggio Received on Tue Apr 04 2000 - 05:54:51 CDT