There is a problem with this approach
that may only become apparent at high
concurrency.
Since you are operating with two-phase
commits, you may come up against the case
where writers block readers.
Your client issues a commit to both servers.
Each server get the PREPARE message,
and when both
Jonathan,
Thanks for this valuable information.
However, I'm using regular commits, not distributed two-phased ones and I
just have simple code to handle the situation where servers return different
success/error codes.
Tanel.
There is a problem with this approach
that may only become
Tanel,
If this is the approach, then quite a bit of code would have to be developed on the front end to handle transaction integrity. For example when one fails and the other has completed the write successfully, they will have to be physically removed.What about if the record that is commited
-358-8211 x 359
http://www.gridapp.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tanel Poder
Sent: Monday, December 15, 2003 6:29 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re: 24 x 7 x 365
Jonathan,
Thanks for this valuable
t to remove every possible outage and it can be much easier to manage a small outage every few months. Regards, Mark. "Tracy Rahmlow" <[EMAIL PROTECTED] Multiplerecipients of list ORACLE-L <[EMAIL PROTECTED]> xp.com cc: Sent by: Subject: 24 x 7 x 365 [EMAIL PROTECTED] .com 11/12/200
If this is the customer you are talking about, this database supports over 12 million subscribers..
Murali Tim Gorman [EMAIL PROTECTED] wrote:
As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs
AM
Subject: Re: 24 x 7 x 365
If this is the customer you are talking about, this database supports
over 12 million subscribers..
Murali Tim Gorman [EMAIL PROTECTED] wrote:
As I mentioned a few minutes ago in another thread, there is an
application using Oracle Rdb on an HP
Yep, I also think so. I'm currently developing a small prototype for this kind of
transparent proxy, which I'll post here when it's stable...
Tanel.
Tanel,
I think this is a good solution, provided the application can handle
two phased commit protocol across both the databases, else there
Hello,
Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve
Well, first
thing that needs to be noted is that 24 x 7 x 365 indicates
uptime for 7 years, which always gives me a chuckle when people say it. Mind you, Ive been guilty of
saying it too! J
And probably
the second thing that needs to be said is that no single product addresses true
HA
Title: RE: 24 x 7 x 365
As 2004 is a Leap Year, in February you have a one day window of opportunity to do upgrades. ;-)
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED]
Sent
-Original Message-
From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject:24 x 7 x 365
Hello,
Our company would like to know whether or not Oracle supports true 24x7x365
PROTECTED]
Date: 2003/12/10 Wed AM 11:44:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: 24 x 7 x 365
Hello,
Our company would like to know whether or not Oracle supports true
24x7x365 availability for an oltp database. We currently are using the
8.1.7 enterprise
Tracy, both OPS (8i) and RAC (9i)support independent node shutdown.
Both support listener based load balancing so that incoming connections
will be evenly spread on all nodes. That still doesn't give you the true
24 x 7 x 365 availability. For that, you need two replicated copies of the
database
cc:
Sent by: Subject: 24 x 7 x 365
[EMAIL PROTECTED
True
24x365 is just about impossible. No if, ands. or buts about it. Why
is because of the number of factors outside your control that affect system
availability. Sure your web sever and database are up 24x365, but your ISP
has 1 hour down time each month for maintenance. OOPS!! from a
recipients of list ORACLE-L [EMAIL PROTECTED]
xp.com cc:
Sent by: Subject: 24 x 7 x 365
[EMAIL PROTECTED]
.com
11/12/2003 03:44
Title: Re: 24 x 7 x 365
As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs that has been up and available continuously for the past 11-12 years.
on 12/10/03 2:49 PM, Goulet, Dick at [EMAIL
18 matches
Mail list logo