Xref: alice comp.databases.oracle.misc:56625 Path: alice!news-feed.fnsi.net!netnews.com!howland.erols.net!isdnet!194.53.76.66.MISMATCH!inetway!inetway.net!not-for-mail From: "Jean-Christophe Boggio" Newsgroups: comp.databases.oracle.misc Subject: Faking parallelism... Date: Tue, 4 Apr 2000 12:54:51 +0200 Organization: UUNET Lines: 36 Message-ID: <8cchv3$273$1@reader1.fr.uu.net> X-Trace: reader1.fr.uu.net 954845987 2275 194.98.233.142 (4 Apr 2000 10:59:47 GMT) X-Complaints-To: abuse@fr.uu.net NNTP-Posting-Date: 4 Apr 2000 10:59:47 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 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