• DocumentCode
    1960740
  • Title

    Taming the downtime: high availability in Sybase ASE 12

  • Author

    Raghuram, S. ; Ranganath, Sheshadri ; Olson, Steve ; Nandi, Subrata

  • fYear
    2000
  • fDate
    2000
  • Firstpage
    111
  • Lastpage
    120
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Data Engineering, 2000. Proceedings. 16th International Conference on
  • Conference_Location
    San Diego, CA
  • ISSN
    1063-6382
  • Print_ISBN
    0-7695-0506-6
  • Type

    conf

  • DOI
    10.1109/ICDE.2000.839398
  • Filename
    839398