Announcement

Collapse
No announcement yet.

Is it possible to implement Peer to peer replication without MSCS SQL 2k8 clustering?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Is it possible to implement Peer to peer replication without MSCS SQL 2k8 clustering?

    Hi Everyone,

    I am looking for SQL Server database solution which can replicate data between two sites vice versa (not just one way)

    Iíve looked into SQL Server failover cluster (MSCS) but then since I have two different sites (Production and DR) it would be to hard or maybe impossible to implement peer to peer data content replication ?

    My plan is to build this solution on top of VMware ESXi with Windows Server 2008 for our server monitoring in both sites.

    In terms of database mirroring though, I certainly considered this approach but decided that peer to peer replication would provide more availability for the collection of data reading from systems going into the DB. The scenario was if one of the sites was disconnected from the outside world, I wanted the monitoring software (which uses SQL Server 200 to still continue to collect the data from all the systems within that site still. Database mirroring wouldn't allow as only the primary database is writeable. Peer to peer replication would allow me to take advantage of load balancing, which could potentially give performance gains and not just redundancy

  • #2
    Re: Is it possible to implement Peer to peer replication without MSCS SQL 2k8 cluster

    Log shipping is what you want
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: Is it possible to implement Peer to peer replication without MSCS SQL 2k8 cluster

      Originally posted by Ossian View Post
      Log shipping is what you want
      ah circular log shipping to make both nodes self updating each other ?

      Comment


      • #4
        Re: Is it possible to implement Peer to peer replication without MSCS SQL 2k8 cluster

        No -- log shipping from one (live) node to others
        Why would you want to ship both ways?
        Tom Jones
        MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
        PhD, MSc, FIAP, MIITT
        IT Trainer / Consultant
        Ossian Ltd
        Scotland

        ** Remember to give credit where credit is due and leave reputation points where appropriate **

        Comment


        • #5
          Re: Is it possible to implement Peer to peer replication without MSCS SQL 2k8 cluster

          Originally posted by Ossian View Post
          No -- log shipping from one (live) node to others
          Why would you want to ship both ways?
          oh ? rather than deploying complex clustering on top of the Hypervisor HA, I was just thinking to utilize the SQL Server replication to both sites (active/Active scenario) so that the data in both sites can be usable and available straightaway.

          Comment

          Working...
          X