Research And Improvement In MySQL Replication

With the advent of Web2.0, small and medium sites develop rapidly, and the LAMP suit consist of open source software has become increasingly popular. MySQL as the core of the data management in this model plays a decisive role in performance of the entire site. With the increase in the number of users and site traffic has also brought increased demand for high concurrency, but also the security of the data set forth requirements.Replication as a key technology in distributed database to improve concurrency and data security in the cluster, is used in a variety of database management systems. MySQL implements a proprietary architecture based on asynchronous master-slave replication. In the MySQL cluster, the master node to accept all of the write operation, and sends data updates to each slave node in order to achieve consistency of data between nodes. However, there are delays in asynchronous replication which brought a certain amount of risk, once the master node fails, you may lose some data, write operation in the entire system also cannot perform, you must switch the master to work properly.Based on the above issues, MySQL needs a better replication mechanism to increase the availability of the cluster and the security of the data. In today's researches of replication technology, replication based on the total order group communication to synchronize data in distributed database has been widely recognized, and it can solve the data consistency, deadlock and other important issues.Based on this replication mechanism, we proposed a write set based replication model on multi-master. The beginning of the paper, first introduced the current status of database replication research as well as replication used by popular commercial database, then introduced the relevant content MySQL database, a write set based replication combined with MySQL is proposed, and the implementation on the InnoDB storage engine in MySQL. Finally, this paper summarizes existent problems in current implementation, and put forward the improvement of future.