Hi, i want a system of four sql servers that have the same data on a single database per server, one of them updates the others and all of them can read by the application (clients), and if the read-write server crashed down to have available read-write server another of the three read ones . The ideal scale out solution is p2p replication but costs too much because it is only available for enterprise sql 2008 edition. Is there any other solution with standard sql 2008 server? Thanks
In P2P replication, each server works as PUBLISHER as well as DISTRIBUTOR means you can update the data at all three places... Why don't you go with one way transactional replication instead of P2P but incase of R/W server fails, you have to change the replication configuration to make other server as publisher.
If i have a cluster of two nodes with two sql instances one A being read and the other B read/write and two other standalone sql servers C, D read and we have still four separate databases with the same data can B do the replication job sending data to the other three instances A, C, D? Do you think this is going to work? Thank you.