brandonvmoore
asked on
Load Balancing Strategies
OK, let's say I just developed a new websites that will generate hits comparable to that of craigslist.com. How do I manage to keep up with all the incoming hits?
Basically, I just want an idea of what my options are and to be directed to resources where I can further study them. I would also be interested to know the answer to this question as it relates specifically to a SQL Server database as well.
Thanks!
Basically, I just want an idea of what my options are and to be directed to resources where I can further study them. I would also be interested to know the answer to this question as it relates specifically to a SQL Server database as well.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Guess there's just not too many people who know much about this around here...
In truth, there is really no such thing as a load balanced SQL Server. Once an instance opens a SQL DB, that is the only one that will have it open.
There are some front end solutions that cross-replicate and simulate a SQL load balance. You are going to pay for them though.
Your best bet is to tune the database(s) and instances, and then work from there.
There are some front end solutions that cross-replicate and simulate a SQL load balance. You are going to pay for them though.
Your best bet is to tune the database(s) and instances, and then work from there.
ASKER
OK, I said I would 'also' like to know anything about load balancing that relates to SQL Server. I don't know if you reserved any comments because you thought I wanted only to know about that, but if so I would like to hear anything you have to say about load balancing options and where I could further study them.
As it does relate to SQL Server though: I realize a single connection can't be split between multiple engines, but do you think a site like craigslist is running their millions of users off of a single connection? I don't know anything about how they handle this, but I would sure think they'd have multiple db servers that stay synchronized. Unless SQL Server (or whatever db product) has a way to utilize multiple servers on a single connection, I would say they have multiple connections, which would need some kind of loading balancing in order to be effecient, right?
As it does relate to SQL Server though: I realize a single connection can't be split between multiple engines, but do you think a site like craigslist is running their millions of users off of a single connection? I don't know anything about how they handle this, but I would sure think they'd have multiple db servers that stay synchronized. Unless SQL Server (or whatever db product) has a way to utilize multiple servers on a single connection, I would say they have multiple connections, which would need some kind of loading balancing in order to be effecient, right?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please check out the Websphere Application server load balancing redbook. It discusses most of the load balancing strategies using WAS.
http://www.redbooks.ibm.com/abstracts/sg246392.html
http://www.redbooks.ibm.com/abstracts/sg246392.html
ASKER
OK, so it looks to me like I might have multiple database servers that are synchronized and have a connection open to each of them. The load balancing would be implemented by looking at which database is being the least utilized and using the connection I have open to it.
Furthermore, I could have more than one application server so each one would have its own connection to each of my database servers.
Then in front of that would be the web server and it would distribute incoming requests to the least utilized application server.
I really don't know much about what I'm talking about right now, but from what I gather this seems to be how it would be architectured. Does this sound like the way it would/could be done or can you give me some better direction?
Furthermore, I could have more than one application server so each one would have its own connection to each of my database servers.
Then in front of that would be the web server and it would distribute incoming requests to the least utilized application server.
I really don't know much about what I'm talking about right now, but from what I gather this seems to be how it would be architectured. Does this sound like the way it would/could be done or can you give me some better direction?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER