dbTalk Databases Forums  

Network load-balancing for active-active clusters

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


Discuss Network load-balancing for active-active clusters in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
chua
 
Posts: n/a

Default Network load-balancing for active-active clusters - 06-27-2008 , 01:09 AM






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

Reply With Quote
  #2  
Old   
Edwin vMierlo [MVP]
 
Posts: n/a

Default Re: Network load-balancing for active-active clusters - 06-27-2008 , 03:07 AM






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

Quote:
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



Reply With Quote
  #3  
Old   
Edwin vMierlo [MVP]
 
Posts: n/a

Default Re: Network load-balancing for active-active clusters - 06-27-2008 , 03:07 AM



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

Quote:
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



Reply With Quote
  #4  
Old   
Edwin vMierlo [MVP]
 
Posts: n/a

Default Re: Network load-balancing for active-active clusters - 06-27-2008 , 03:07 AM



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

Quote:
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



Reply With Quote
  #5  
Old   
Edwin vMierlo [MVP]
 
Posts: n/a

Default Re: Network load-balancing for active-active clusters - 06-27-2008 , 03:07 AM



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

Quote:
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



Reply With Quote
  #6  
Old   
Edwin vMierlo [MVP]
 
Posts: n/a

Default Re: Network load-balancing for active-active clusters - 06-27-2008 , 03:07 AM



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

Quote:
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



Reply With Quote
  #7  
Old   
Edwin vMierlo [MVP]
 
Posts: n/a

Default Re: Network load-balancing for active-active clusters - 06-27-2008 , 03:07 AM



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

Quote:
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



Reply With Quote
  #8  
Old   
Edwin vMierlo [MVP]
 
Posts: n/a

Default Re: Network load-balancing for active-active clusters - 06-27-2008 , 03:07 AM



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

Quote:
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



Reply With Quote
  #9  
Old   
Edwin vMierlo [MVP]
 
Posts: n/a

Default Re: Network load-balancing for active-active clusters - 06-27-2008 , 03:07 AM



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

Quote:
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



Reply With Quote
  #10  
Old   
Edwin vMierlo [MVP]
 
Posts: n/a

Default Re: Network load-balancing for active-active clusters - 06-27-2008 , 03:07 AM



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

Quote:
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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.