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...
Gespeichert in:
Hauptverfasser: | , , , , , , , , , , , , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
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 |
---|