SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 02:23 AM
| ||||
| ||||
 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?      |
|
02-29-2008, 02:23 AM
| |||
| |||
| Re: Load balancing and clustering "Shabam" <info@pcconnect.net> wrote in message news:U4ydnZzBnMTWcO_dRVn-tA@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 |
|
02-29-2008, 02:23 AM
| |||
| |||
| Re: 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. What do you mean middle tier? |
|
02-29-2008, 02:24 AM
| ||||
| ||||
| Re: Load balancing and clustering "Shabam" <info@pcconnect.net> wrote in message news:<9oKdnTRxs9oRou7dRVn-uQ@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 |
 |
« Auto created statistics and missing statistics
|
Group newbie: question on parsing a field value »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 09:30 AM.
