468,554 Members | 1,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,554 developers. It's quick & easy.

Load balancing and clustering

When a web application becomes overloaded with traffic, one can offload it
by load balancing and clustering the front end web servers. What happens
when the back-end MSSQL database becomes overloaded? Does MYSQL offer load
balancing and clustering?
Jul 20 '05 #1
3 4883

"Shabam" <in**@pcconnect.net> wrote in message
news:U4********************@adelphia.com...
When a web application becomes overloaded with traffic, one can offload it
by load balancing and clustering the front end web servers. What happens
when the back-end MSSQL database becomes overloaded? Does MYSQL offer load balancing and clustering?


I'm not sure if you're talking about MSSQL (Microsoft SQL Server) or MySQL.
In the case of MSSQL, clustering is supported for failover only, not for
load-balancing. If you need load-balancing, then it can be implemented in a
middle-tier.

Simon
Jul 20 '05 #2
> I'm not sure if you're talking about MSSQL (Microsoft SQL Server) or
MySQL.
In the case of MSSQL, clustering is supported for failover only, not for
load-balancing. If you need load-balancing, then it can be implemented in a middle-tier.


What do you mean middle tier?
Jul 20 '05 #3
"Shabam" <in**@pcconnect.net> wrote in message news:<9o********************@adelphia.com>...
I'm not sure if you're talking about MSSQL (Microsoft SQL Server) or

MySQL.
In the case of MSSQL, clustering is supported for failover only, not for
load-balancing. If you need load-balancing, then it can be implemented in

a
middle-tier.


What do you mean middle tier?


I mean an application server, such as WebSphere, WebLogic, Microsoft
Transaction Server etc., which sits between the web server and the
database server. Clients connect to the application server, which
manages all the database connections, so you can use the application
server to spread database access across several physical databases.

Simon
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by GeekBoy | last post: by
6 posts views Thread by Andrew Robinson | last post: by
2 posts views Thread by RahulBose | last post: by
2 posts views Thread by zzzbla | last post: by
2 posts views Thread by =?Utf-8?B?YW5hbmQga3VtYXI=?= | last post: by
1 post views Thread by m.a | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.