SQL Server Performance

scale out database

Discussion in 'SQL Server 2008 General DBA Questions' started by klehonia, May 18, 2009.

  1. klehonia New Member

    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
  2. MohammedU New Member

    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.
  3. klehonia New Member

    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.

Share This Page