Faster DB Failover in View

December 2004
Storage Magazine;Dec2004, Vol. 3 Issue 10, p14
This article focuses on the difficulties faced in dealing with database high availability (HA). Traditional approached to database HA, such as running Veritas Cluster Server or Microsoft Cluster Server, require information technology managers to double their administrative duties. Traditional HA approaches can also take a long time to get a secondary server online. A failure first needs to be detected and then the secondary server has to claim the disk through a Small Computer System Interface reserve/release command. Then, it must check and restore the file system, mount the file system, and finally, load Oracle. PolyServe's solution to the database HA problem relies on its clustered file system software. To use such a solution, one should run Matrix Serve on both the primary and secondary database servers, and load Oracle on the same shared storage area network volume. Upon detecting that the primary server has failed, the secondary server needs to load Oracle, because it sees the same file system as the primary server, it can bypass the restoring and mounting steps. Norall estimates that PolyServe's database HA package can get one back up and running in under five minutes. In addition, the software supports Windows and Linux.


Related Articles

  • Sizing Up the Year to Come. Walker, Christy; Hammond, Mark; Nobel, Carmen; Gray, Lloyd // PC Week;01/04/99, Vol. 16 Issue 1, p45 

    Forecasts developments in 1999 which will benefit information technology departments. New releases of groupware and messaging products like Lotus Notes, Domino and Microsoft Exchange; Computer input/output developments; The PCI-X initiative; Multiprocessing; Storage area networks (SAN); Fibre...

  • Relentless Improvements in Hardware Dwarf the Open Source Revolution. Agosta, Lou // DM Review;Mar2004, Vol. 14 Issue 3, p52 

    Looks at the trends in the data warehousing hardware sector as hardware improvements continue to dwarf open source revolution, as of March 2004. Actual savings due to open source; Significance of improved hardware performance; Improvement in the price of the hardware.

  • I/O I/O It's Why My Server's Slow. Pearl, Robert // SQL Server Magazine;Mar2010, Vol. 12 Issue 3, p9 

    The article offers tips for getting and analyzing input/output (I/O) information on the SQL Server. It recommends the use of sys.dm_io_virtual_file_stats, a dynamic management function (DMF) introduced in SQL Server 2005 which returns I/O statistics for database files. It suggests to use SQL...

  • Use hardware to fill DBMS tool gaps. Musich, Paula // PC Week;3/8/93, Vol. 10 Issue 9, p105 

    Suggests the use of hardware to augment the lack of database-management systems (DBMS) tools in rightsizing client/server database operations. Unavailability of tools for mainframes to control and manage data; Network-management software. INSET: Expert advice..

  • Effective Steps for Planning Oracle Database Upgrades. R., Arun Kumar // Database Trends & Applications;Jun2006, Vol. 20 Issue 6, p17 

    The article provides effective steps for planning database upgrades from Oracle Corp. A series of preliminary steps need to be completed prior to investing with the new installation or to upgrade process of Oracle Database 10g. New features of the database has to be familiarized then few key...

  • Extendable Standards. Wilson, Andrew // Vision Systems Design;Jan2009, Vol. 14 Issue 1, p41 

    The article deals with the increasing flexibility of standard camera-to-computer interfaces. Limitations of the point-to-point interface Camera Link include the lack of an upgrade to support ultrahigh-speed cameras, the limited distance that can be achieved between camera and computer, and the...

  • SOA tools--virtually bridging the legacy divide: Part 1. Harney, John // KM World;Feb2006, Vol. 15 Issue 2, p22 

    The article provides a sampling of the kind of activities that service-oriented architecture (SOA) tools need to address. SOA is defined as an approach to organizing information technology resources to better enable the business to leverage them in a flexible manner. The three classes of SOA...

  • Resistance is futile... Sharwood, Simon // Australian Personal Computer;Jan2005, Vol. 25 Issue 1, p86 

    This article reports that Kevin Warwick is the world's first functioning cyborg. Inside his arm a transponder identifies him to computers in his lab via radio, activating lights and opening doors as he approaches. And an array of 100 electrodes embedded in his other arm gives him ultrasonic...

  • West Group Releases Access-Friendly Westlaw.  // Computers in Libraries;Sep2002, Vol. 22 Issue 8, p57 

    Reports that West Group has released Westlaw Text Only, a text-only, user-friendly Westlaw interface that optimizes the program for those using assistive technologies, such as screen readers and voice-recognition software. Visually simplistic design; Use of the interface for legal research.


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics