Title :
Taming the downtime: high availability in Sybase ASE 12
Author :
Raghuram, S. ; Ranganath, Sheshadri ; Olson, Steve ; Nandi, Subrata
Abstract :
The new companion architecture in Sybase Adaptive Server Enterprise (ASE) 12 for high availability is supported on a 2-node cluster with each node running a separate ASE 12 server in a companion configuration. This architecture is designed to withstand a single point of failure for unplanned outages, and allow both nodes to be used for productive workload during normal operation. It enables fast failover and data recovery, supports automatic client migration during failure, and integrates seamlessly with adjoining layers in multi-tier architecture. It supports single system presentation of data for applications, and presents a rich set of features/infrastructure to reduce the planned downtime. During failover and failback, only the persistent data component is moved between the companion ASEs, making it fast and efficient. Introducing the proxy databases, this architecture enables user databases to be visible and accessible from either of the companions by shipping the queries to the appropriate node and returning the results to the client
Keywords :
database management systems; software architecture; software fault tolerance; system recovery; 2-node cluster; ASE 12 server; Sybase ASE 12; Sybase Adaptive Server Enterprise 12; automatic client migration; companion architecture; data recovery; failback; failure; fast failover; high availability; multi-tier architecture; normal operation; persistent data component movement; planned downtime reduction; productive workload; proxy databases; queries; unplanned outages; Availability; Birth disorders; Computational Intelligence Society; Computer architecture; Costs; Data engineering; Information systems; Internet; Power generation economics; Power system economics;
Conference_Titel :
Data Engineering, 2000. Proceedings. 16th International Conference on
Conference_Location :
San Diego, CA
Print_ISBN :
0-7695-0506-6
DOI :
10.1109/ICDE.2000.839398