 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / July 2008Network load-balancing for active-active clusters
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 SQL is not designed to do active/dynamic load balancing. You can however do "static" load balancing if you design your application/clients appropriately > Hi, > [quoted text clipped - 6 lines] > regards, > Windows Fan 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]" <EdwinvMie...@discussions.microsoft.com> wrote: > SQL is not designed to do active/dynamic load balancing. > [quoted text clipped - 16 lines] > > - Mostra testo citato 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 > Instead of a cluster solution you can obtain load balancing with peer > to peer replication. Peer to peer replication is an high avalability [quoted text clipped - 31 lines] > > > > - Mostra testo citato 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...@discussions.microsoft.com> 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 [quoted text clipped - 46 lines] > > - Mostra testo citato |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.