Application and Research of Read-write Separation Technology in Active-active Database

Abstract

Data security, business, and performance could be unexpectedly affected in the case of information system interruption, and thus an active-active disaster recovery system is needed to recover the system urgently. For such a purpose, this paper conducted the research using a read-write separation technology, analyzed its technical advantages of solving high-concurrency business system performance bottlenecks, and applied the redo-based read-write separation technology to the data layers between two data centers. A complete active-active architecture was designed for an information system to achieve a dual active data center disaster recovery system. Then, an OMS business system was upgraded by using this design scheme. It can not only achieve disaster recovery of data, keep service continuity after a disaster, and zero-data loss, but also the response speed of the new system increased by more than 50%, based on the read-write separation technology under normal status which improved the overall business processing capability of the system.