On Tue, Nov 01, 2005 at 06:50:05PM -0500, Rod Taylor wrote:
> You can move around the master for a specific set but as Chris reminds
> me failover itself is a global operation (performed only when the
> original DB is no longer available).

Yes, but as Chris also noted, if one database has failed in some way
on a cluster such that you want to failover, that would seem to
entail that the rest of them have too.  For any case where that isn't
true, you can still do MOVE SET.   (Actually, I can think of a case
where it might not be.  If you're using tablespaces to put each of
these on a disk, and you have a disk-controller failure for just one
disk pair, say, then you might have a case.  But that's already way
more administrative burden than I assume the OP was going for.)

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well. 
		--Dennis Ritchie