Would a nice solution be to create a federated database, with each node being a high availability cluster?
By having each node in the federation being a high availability cluster, that takes the issues regarding the entire DB being down with one node failure.
Being a high availbility cluster, that would remove issues about data syncronisation wouldn't it?