• clustering or replication.

    Both will suck for different reasons, but those are your options. Personally I'd lean replication if you don't have too many tables and the workload isn't too high.

    You could also look at SAN snapshotting regularly if your hardware can do that.