Post reply

How to do peer to peer Load Balancing in SQL Server 2008

  • June 7, 2012 at 9:37 pm

    #257568

    how can i achieve this setup? can anyone please help me?

    i need to do the setup on the right image.

    Thanks!

  • June 9, 2012 at 7:07 pm

    #1499066

    ejosephss (6/7/2012)

    how can i achieve this setup? can anyone please help me?

    i need to do the setup on the right image.

    Thanks!

    Peer to Peer replication should handle your replication needs. For the scenario on the left you'll need to make sure your app writes to mutually exclusive sets of data. In borh scenarios you'll need to make sure your app can handle replication latency when data is written to one db server and has not yet replicated prior to the other server before the app tries to read it.

    A better option, usually, is to scale up one server to handle all requests as SQL Server does not necessarily scale out all that easily.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • June 10, 2012 at 5:46 am

    #1499086

    Start by reading these:

    http://msdn.microsoft.com/en-US/library/cc917714.aspx

    http://www.microsoft.com/technet/prodtechnol/sql/2005/scaleout.mspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply