|
|
|
date: Thu, 26 Jun 2008 23:09:00 -0700,
group: microsoft.public.sqlserver.clustering
back
Re: Network load-balancing for active-active clusters
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
> 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]"
> 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" wrote in message
> >
> > news:5B8C4FC0-87BB-480C-9EA0-80040DE0451F@microsoft.com...
> >
> >
> >
> > > 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
> > > 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
>
>
date: Tue, 1 Jul 2008 12:34:00 -0700
author: Linchi Shea
Re: Network load-balancing for active-active clusters
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
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
> > 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]"
> > 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" wrote in message
>
> > >news:5B8C4FC0-87BB-480C-9EA0-80040DE0451F@microsoft.com...
>
> > > > 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
> > > > 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
date: Wed, 2 Jul 2008 06:25:40 -0700 (PDT)
author: Riccardone
|
|
