Network load-balancing for active-active clusters

#41

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... (AT) discussions (DOT) microsoft.com>
wrote:

Quote:

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/libr...(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... (AT) discussions (DOT) microsoft.com> 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... (AT) discussions (DOT) microsoft.com> wrote in message

news:5B8C4FC0-87BB-480C-9EA0-80040DE0451F (AT) microsoft (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Network load-balancing for active-active clusters

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: Network load-balancing for active-active clusters - 07-02-2008 , 08:25 AM