• 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?