[Deploying Sakai] Dataguard failover mechanisms
Todd Williams
tcwill at ufl.edu
Wed Nov 4 10:45:28 PST 2009
I'm beginning to work on an initial Dataguard config for our early
dev/proof-of-concept Sakai implementation. I'm doing this with 11gR2 on
a primary and one physical standby. The big question I keep running
into is how to handle switchover/failover scenarios.
My understanding is that Oracle's thin jdbc driver is capable of
receiving the various fast-application notification signals, but that
the actual failover is dependent upon the application *doing* something
with those notifications. So I guess this leads me to ask if anybody
been able to do this with Sakai 2.6?
In an earlier thread Adi at Michigan mentioned that they were never able
to pin down TAF for RAC, so I wonder if there are similar outcomes with
FAN and DataGuard.
So generally I'm interested in how folks are handling Dataguard
fail/switchover. I suppose there's the option of whole-cluster failover
via network load-balancer; however, I'd love to retain the flexibility
of failing the DB tier w/out having to fail the entire application cluster.
Thanks in advance for your input!
--
Todd Williams
tcwill at ufl.edu
CNS Open Systems
University of Florida
More information about the production
mailing list