State Server Failover

WildHare

I am looking for documentation on state server failover. There is a
microsoft article which sort of talks about protecting against a failed
state server by using SQL server...but it about as clear as mud.

http://msdn.microsoft.com/library/de...us/cpguide/htm
l/cpconsessionsta te.asp

which suggests that you can protect against a web server failing by using a
separate SQL Server machine store session state! Yippee!!! But back to the
question...what if the machine storing session state fails??? (in this case
the SQL Server machine).

I sort of prefer (principally because we have no experience with SQL
server...the app talks to Oracle), to use the stateServer mode with a
designated webserver being also the state server. BUT, when this machine
fails (or is taken off line) we are hosed!

Does anyone have a solution to this? ...even a dynamic approach to changing
the stateServer ID would be useful...then if server A is not available, the
applications can switch over to server B.

Comments? Ideas? Thoughts?

Thanks.

Nov 17 '05 #1

Subscribe Reply

2843

Frank Drebin

If you need a highly-available setup back to your databases, run 2 servers
running WLBS (windows load balancing) or any other load balancer and run SQL
on a RAIDed cluster.. Basically, you could have a disk failure, whole
database server outage or either of the web servers down - and you'd still
be up and running..

"WildHare" <ki******@siva. com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

I am looking for documentation on state server failover. There is a
microsoft article which sort of talks about protecting against a failed
state server by using SQL server...but it about as clear as mud.

http://msdn.microsoft.com/library/de...us/cpguide/htm l/cpconsessionsta te.asp

which suggests that you can protect against a web server failing by using a separate SQL Server machine store session state! Yippee!!! But back to the question...what if the machine storing session state fails??? (in this case the SQL Server machine).

I sort of prefer (principally because we have no experience with SQL
server...the app talks to Oracle), to use the stateServer mode with a
designated webserver being also the state server. BUT, when this machine
fails (or is taken off line) we are hosed!

Does anyone have a solution to this? ...even a dynamic approach to changing the stateServer ID would be useful...then if server A is not available, the applications can switch over to server B.

Comments? Ideas? Thoughts?

Thanks.

Nov 17 '05 #2

Similar topics

2220

Application Server Design for .Net

by: Chris Gatto | last post by:

Hello, My organization is currently considering the purchase of a new intranet application server and we are looking for opinions from those who have been down this road before. In brief the server must support the following: - 600+ users using various ASP.Net based applications, only 2 currently but growing over time as old legacy apps are converted; - Some applications are mission critical, others not so much; - DB back-end is a...

by: Andrew Rawnsley | last post by:

Anyone out there using beta 2 in production situations? Comments on stability? I am rolling out a project in the next 4 weeks, and really don't want to go though an upgrade soon after its released on an Unsuspecting Client, so I would LIKE to start working with 7.4. -------------------- Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd.

PostgreSQL Database

4058

What is IBM's licensing policy regarding a backup/test DB2 server?Is this legal?

by: aj | last post by:

I currently have 2 official DB2 Workgroup Edition licenses for my 2 v8 production servers. I also have tech support/software upgrade agreements in place for both servers. I am interested in building a separate backup/test DB2 server upon which I can experiment with impunity. This backup server will not be in production in any way, and the only person who will ever connect to it is me. It will be up and online most if not all of the...

DB2 Database

2326

Out of Process State - MSSQL

by: Chad Crowder | last post by:

I've taken a look at this article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspnet/html/asp12282000.asp which someone posted a month or so ago regarding setting up SQL server to handle state data. The article references .Net beta, and the file state.sql in the framwork/1.0x directory, but that file doesn't exist for version 1.1.4322. I'm wondering if there's a component that I need to install, or if I need to...

ASP.NET

2354

ASP.NET State Service vs. SQL

by: Ian Jenkins, MCSD | last post by:

I have a web farm set up using NLBS. I need to manage sessions in one central location. As I see it I have 2 options: SQL SERVER ASP.NET State Service Which has better performance? What is best to use in a situation like this? Can ASP.NET State Service be run across 2 servers? What if I used the

C# / C Sharp

2521

SQL Database Mirroring and the Session State Database

by: Calculated | last post by:

We have a number of databases mirrored including the ASPState session database used by the websites. However the connection string to the ASPState database does not allow you to include the 'Failover Partner = ServerB' parameter, and it does require you to have the 'Data Source = ServerA' parameter. (Where ServerA = Principal, ServerB = Secondary.) Normal databases that allow you to have 'Failover Partner' parameter work great. How is...

.NET Framework

5659

HADR takeover by force during peer state - why does this end up with split brain ?

by: Joachim Klassen | last post by:

Hi all, if I accidentally use a TAKEOVER command with BY FORCE clause while primary and standby are in peer state I'll end up with two primary's (at least with FP10 and Windows). Is this works as designed or a bug ? Manuals say that the standby will inform the primary about the takeover but will not wait for acknowledgement, so the primary knows about whats going on. In my eyes primary should either switch to standby or shutdown...

DB2 Database

842

Storing session state info using framework 2.0

by: abraxas | last post by:

I was able to configure an asp.net app with the 2.0 framework to store session state information in a SQL Server 2000 database. - Is the .net framework 2.0 a supported configuration by MS? - Is is supported on a SQL server failover cluster (MSCS)? If so, any impact to the session data during a cluster failover/failback operation? - Is it suitable for a web farm? Any issues?

ASP.NET

2715

How to increase web server uptime with DNS failover

by: Guy Macon | last post by:

How to increase web server uptime with DNS failover: For illustration, let's start with some really bad hosting... Find four free web hosts that are each 90% reliable -- in other words they each are down on average one day out of ten. Use a failover DNS system with monitoring to switch servers if one fails. On average: One server will be down one day out of ten

HTML / CSS

8473

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8390

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8597

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8667

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7428

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5692

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4402

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2048

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1806

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General