Re Network load-balancing for active-active clusters

Document Sample
Re Network load-balancing for active-active clusters Powered By Docstoc
					                          Re: Network load−balancing for active−active clusters

Re: Network load−balancing for active−active
clusters

Source:
http://www.tech−archive.net/Archive/SQL−Server/microsoft.public.sqlserver.clustering/2008−07/msg00007.html



      • From: Riccardone <riccardod@xxxxxxxxx>
      • Date: Wed, 2 Jul 2008 06:25:40 −0700 (PDT)

If your service level require only high avalaibility, then cluster is
good. But if you need performance also, an high avalability solution
is peer to peer without headache. For example, there are not conflicts
because replication is transactional. Setup is not so difficult and
hardware is not certified required like cluster.
Peer to peer replication like all other high avalability solutions
other than failover cluster, is at database level and not at instance
level.
Another high avalability solution to obtain a load "read" balancing is
log shipping. With a log shipping solution, you can configure a read
only standby (or more readonly standby servers) and clients can
connect to it for reports and so on. In this case, you can mix a
failover cluster instance with a log shipping solution to obtain load
balance.

regards
Riccardo di Nuzzo

On 1 Lug, 21:34, Linchi Shea <LinchiS...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

        Whether to use peer−to−peer replication for load balancing is a rather
        application specific question. In other words, for some apps, it may be a
        good soultion. But for other apps, it's a terrible solution. If we are to
        look for an infrastructure solution where different layers are cleanly
        separated, I don't think you want to consider a peer−to−peer setup (unless
        you like support headache).

        Linchi



        "Riccardone" wrote:

                 Instead of a cluster solution you can obtain load balancing with peer
                 to peer replication. Peer to peer replication is an high avalability
                 solution with the opportunity to balance the workload on all database

Re: Network load−balancing for active−active clusters                                                1
                       Re: Network load−balancing for active−active clusters
              node available.



              Peer−to−Peer Transactional Replication
              http://msdn.microsoft.com/en−us/library/ms151196(SQL.100).aspx
              How to: Configure Peer−to−Peer Transactional Replication
              http://msdn.microsoft.com/en−us/library/ms152536.aspx



              regards
              Riccardo di Nuzzo



              On 27 Giu, 10:07, "Edwin vMierlo [MVP]"
              <EdwinvMie...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

                      SQL is not designed to do active/dynamic load balancing.



                      You can however do "static" load balancing if you design
                      your
                      application/clients appropriately



                      "chua" <c...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
                      message



                      news:5B8C4FC0−87BB−480C−9EA0−80040DE0451F@xxxxxxxxxxxxxxxx



                                Hi,



                                I have a requirements to deploy SQL 2005
                                clustering as active/active

                      nodes.

                                We also want to achieve load−balancing. For
                                example, when there are 100

                      users

Re: Network load−balancing for active−active clusters                              2
                        Re: Network load−balancing for active−active clusters
                               login to the clusters SQL, the request will
                               split 50 / 50 to each of the

                       sql

                               active node. Can it work in this way?
                               thanks if u could shed some lights



                               regards,
                               Windows Fan− Nascondi testo citato



                       − Mostra testo citato− Nascondi testo citato


       − Mostra testo citato


.




Re: Network load−balancing for active−active clusters                           3

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:2/13/2012
language:English
pages:3