Clustering wise, definitely.
I'd probably look at using a single device with multiple connections and as much redundancy I could set up on the mysql server though. Put that on a nix machine and it'd hum.
Federated wise, I'm not sure. They are a table type, but I'm not sure if they're available in standard version: http://dev.mysql.com/doc/refman/5.0/...ge-engine.html
The idea is neat, but unless the remove (and even origin for that matter) servers have good connectivity, I can see issues with performance. Assuming no issues with performance (
), the idea would be useful in having many offloaded webservers without needing replicated copies.
Not that I have a problem with replication mind you.