| The new technology driven new demand, with the development of high speed network and massive handheld Internet access device, the data requests from Internet product foreground sent to background increases exponentially; while the traditional single node database systems are facing the problem of storage and computation of PB data set.Meanwhile, a lot of applications have to keep in running state 24-hours a day without stopping, For example, a temporary shutdown in the ATM, medical & military monitor or stock processing system will lead to disastrous consequences.The traditional method is to use the super computer system to work out the calculation task. But the price of super computer is too expensive, and the availability and scalability is not strong enough. Therefore, high performance and high availability database cluster system has become the focus in the field of computer science.Under this background, in this paper, several mainstream cluster technology based on MySQL database is analyzed and studied. And no matter what kind of cluster technology is very one-sided in performance, which can’t redress the balance between load balancing and high performance. So a new idea comes, through to mix different cluster technology, combined with a variety of mainstream technology of cluster in the same cluster architecture, to design and implement a high performance, high availability database cluster architecture, which can give full play to their own advantages of two different technology, to provide a new solution for the enterprise core database with very low hardware cost. By the simulated pressure test, we conducted a confirmatory test for this database cluster architecture, so that it can support millions page view access and has much substance of commercial significance by running in the real on-line production environment. |