The Data Synchronization And Switch Of Main Memory Database

As the economy developing, modern Application requires the database more and more quickly. Traditional database can't satisfy those requirements at some field, so the memory resident database (MMDB) comes true. Data synchronization technology can ensure the data consistency that on different node in distributed system. Many commercial databases have provided their own solution like Oracle and SQL Server. At the other side, as to MMDB, the important thing is how to synchronize the data more efficiently and how to keep the data consistency.The background of this paper is a futures transaction system named JinCheng . It is also a distributed system. The features that transaction area is independent of the system make the data synchronization necessary. On the basis of research of the technology and the project that we are working on, considering the requirement and efficiency of the system, we propose a data synchronization solution based on transaction log. And the advantage is that it can decrease the data quantity transported and lighten the backup database's burden. In another way, asynchronous mode can improve the whole system's performance. The problem about delay between Primary database and backup database is analyzed and solved.Following the design, we show how to implement the system that divided into two parts: Primary database and backup database. At last, we introduce the database switch which can recover the system from failure and make the system more usable and strong.