Analysis of Sybase Data Disaster Solutions

I. High Availability of the system (High Availability)

1. High Availability Solution

With the development of computer applications, people have higher and higher requirements on the High Availability and High Availability of computer systems. In particular, key database-based business systems of enterprises often maintain the lives of enterprises. People not only want to ensure the integrity of key business data, but also hope that online applications can be automatically restored without interruption or in the shortest possible time. This is called the reliability and availability of computer systems.

High Availability is a topic raised by users to the entire computer industry, this requires that all manufacturers of computer systems, including computer power supply, hardware, operating systems, networks, database management systems, and application software, provide corresponding safeguard measures, in addition, these measures must be comprehensively considered and used in a unified manner.

 

Computer systems and their high availability

Currently, many measures are available, such as fault tolerance mode based on hardware, dual-host or multi-host cluster system based on the widely used cluster mode), and data replication mode. The prices vary depending on different levels and targeting.

Measure and compare the high availability of computer systems

Currently, users in China use the cluster mode Dual-host or multi-host cluster system. The basic configuration is shown in 3. The basic principle can be summarized as: the same cluster) all key business data is stored in the shared disk group. When a faulty node is replaced by another node, A part of the data device that the data under the jurisdiction of the faulty node shares a disk group) is taken over. The time when the node replaces/takes over is determined by the monitoring software running in the cluster. The database management system runs on the node, manage the data on the device controlled by the node. The customer application can use one or more database servers in the cluster. The replacement of the node means that the process of the database management system running on the node is switched, these processes are completed in the server background and transparent to front-end applications.

Group Machine backup solution

Sybase ase databases can use a group machine system for online and real-time security backup, it is also supported by all mainstream Hardware/platform vendors such as IBM, HP, SUN, NCR, DEC, NT, Veritas, and EMC. It is also widely used in key business application systems such as banking, post and telecommunications. In particular, cooperation with Veritas and EMC makes ASE databases more efficient for Secure Backup.

2. Problems with high availability solutions

Currently, most of the telecom industry uses dual-host Fault Tolerance solutions to achieve high system availability, such as SYBASE's HA method, Oracle's OPS or RAC, they share a disk array with two machines). When one machine fails, the other machine takes over the entire disk array to implement dual-Machine Fault tolerance. Specific 4.

 

Sybase HA System

1. Sybase Data Warehouse Dapeng securities application case (1)
2. Sybase Database Engine running methods
3. Sybase data backup-BCP usage Overview
4. Several configuration problems of Sybase Database
5. How to Set Sybase user permissions to process Processes