Load balancing and clustering

[Shabam]

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?

[Simon Hayes]

"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

[Shabam]

> 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?

[Simon Hayes]

"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