Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How about just open one node of RAC in read-write mode, others in read-only mode?

Re: How about just open one node of RAC in read-write mode, others in read-only mode?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Dec 2005 05:35:06 -0800
Message-ID: <1133876106.140265.291780@g14g2000cwa.googlegroups.com> 





AnySQL, we have been able to run multi-node write OPS/RAC since OPS was
introduced with version 7 with acceptable results so your basic premise
is false.



If you want to limit your updates to come from one or a few instances
you would need to direct the update modules of the application to use
connections to those instances while the query only connections are
made to the other instances.  You can do this through writing your own
connection pool management routines for web based access or by having
the update modules directly connect to Oracle without going through a
pool.



HTH -- Mark D Powell --
Received on Tue Dec 06 2005 - 07:35:06 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US