Real estate registration data read-write separation method for RAC cluster

The invention provides an RAC cluster-oriented real estate registration data read-write separation method, which comprises the following steps of: establishing two nodes A and B of a database, checking CPU and IO performance of servers on double nodes through a program on a node C, automatically dis...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: CHEN YANJUN, CHEN XUEPING, ZHU XINGWANG, WANG SHIPIN, ZHANG ZHENG, DOU YIHONG, TANG WENWU, WANG ZHU, CHE DELUN, ZHANG LU, ZHANG LILI, ZHANG YINBO, WANG ZHUQING, LIU LEIBAO, WANG JUNGANG, JIANG XIONG
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention provides an RAC cluster-oriented real estate registration data read-write separation method, which comprises the following steps of: establishing two nodes A and B of a database, checking CPU and IO performance of servers on double nodes through a program on a node C, automatically distributing data read-write task distribution of the double nodes, designing a high-frequency read-only module in a system to access the node A, and a read-write hybrid module to access the node C, and the data batch writing module accesses the node B. The RAC, Exadata intelligent Scan and other technologies are adopted to realize database multi-node distributed data read-write resource flexible scheduling, read-write separation application is designed according to a demand scene, the system processing capacity and throughput are comprehensively improved, the data read-write efficiency is effectively improved, the server performance is maximized, rationalized and effectively utilized, and the working efficiency is im