I've *never* done this before, and don't know if Pedant has either, so I'm curious (and I'm also not well versed on it
What of a clustered MySQL environment and using of a federated environment for the each of the servers assigned via ip? In the event that a machine is no longer reachable, shouldn't both machines if set up with federated tables simply be contacting the same mysql anyway (with the mysql clustered for some redundancy as well)?
Would such a thing work (I've never done anything more than a quick peek at federation where I go "neat, but nothing I need it for atm"). Would this be a situation where federated would actually have some value?