High Availability For The Database Server System Design And Implementation,

Along with the rapid development of computer technology, database application has already pervaded all fields; which always sustains the whole system. Once the database collapses, it will cause data loss or service pause, and bring immeasurable loss to the user or enterprise, especially the bank system and electronic commerce trading system, the economic losses of some unpredictable fault or outage caused can be as high as millions of dollars/hour. Therefore, to keep system running is too important. To improve the high availability of database system has become the first premise of enterprise operations.Since the high availability of database system plays a decisive role, what measures can be taken to ensure its high availability? In view of this, this paper studied a lot of high availability solutions for database system, such as cluster, database mirror, log delivery etc.By referring to the factors affect high availability and design principle of high availability system, and the selection and analysis on high availability solutions, this paper designs an high availability system oriented database server. It constitutes cluster, log transmit and network backup independent technical organically. This system can prevent disk failure, cluster faults and local system failure. Once the system failure, whether planned or unplanned failures, the system can transfer the tasks on the failed node to the normal node within a short period of time, and recover services to client. It ensures the continuity of systems operation to a great extent. Moreover, because the database server has the function of single system image, failover process off-screen is transparent for users. In addition, this paper adopts virtual machine technology as software platform to build system; on the one hand, it improves the system availability, on the other hand, it reduces cost and optimizes the system resource utilization.Finally, the paper use visual basic 6.0 SP5 to compile "The System Of Managing Student File",and connect remotely to database server of high availability structure, after many times tests this system can solve system faults in a relatively short period of time successfully, and verifies the high availability. Moreover, through the contrast experiment data, this paper give practice proof to "memory transfer" in improving ram usage superiority。...