An Efficient Approach For Avoiding Down Time of Production Data Base Server in Active/Passive Windows Failover Clustering Environment
A.Arockia Aswini1, V.R.Manisankar2, J.Jagadeesan3
1A.Arockia Aswni, Assistant Professor (OG), SRM University, India.
2V.R.Manisankar, M.Tech Student, SRM University, India.
3J.Jagadeesan, Assistant Professor (SG), SRM University, India.
Manuscript received on July 25, 2012. | Revised Manuscript received on July 30, 2012. | Manuscript published on August 10, 2012. | PP: 86-89 | Volume-1 Issue-3, August 2012. | Retrieval Number: C0221071312/2012©BEIESP
Open Access | Ethics and Policies | Cite
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: Modern IT department facing immense challenge is to ensure the production Server availability at all times. To avoid downtime of Production Server, High availability Solution should be implemented like Microsoft Windows Failover Clustering. Microsoft Failover Windows Cluster provides the automatic failover to the standby node if a hardware (RAM, SMPS, CPU and etc…) failure or software failure (OS, SQL Server and etc…) occurs. Failover automatically occurs if the primary server fails. In this case, Active/passive two node windows Cluster is implemented along with SQL Server cluster. Windows Failover cluster will not failover for the customized application services which are node specific. In three tier architecture (Web, App and DB), SQL Server Database instance installed in Cluster Environment as it has capable of failover to the passive node if primary node SQL instance or with Server level Software/Hardware failure occurs. Suppose, if any Application dependent Services which is installed in Primary Node which is required for providing interface between Web and Database Servers will not failover to the secondary node even though SQL Server and Cluster resources can does. Again, there will be a showstopper of entire business due to this application dependent services non-working. Intention of this paper is to provide the solution for how to failover such dependent application services to the passive node along with Cluster Services in order to avoid downtime.
Keywords: architecture, Application, windows, showstopper, SQL