Method and device capable of achieving database reading and writing separation

The invention discloses a method and a device achieving database reading and writing separation. The device is applied to a system including a client, an application host, a main database and an auxiliary database. The method comprises the steps that the application host receives an operation requir...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: YANG LEI, WANG HANG, CHU XIANZHE, ZHONG LIANG, QIAO XIN
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention discloses a method and a device achieving database reading and writing separation. The device is applied to a system including a client, an application host, a main database and an auxiliary database. The method comprises the steps that the application host receives an operation requirement from the client and determines the operation requirement; the application host sends a writing requirement to the main database, receives writing response return by the main database and returns the writing response to the client, if the operation requirement is the writing requirement; the application host sends a reading requirement to the auxiliary database, receives reading response return by the auxiliary database and returns the reading response to the client if the operation requirement is the reading requirement. By means of the method and the device, reading and writing operations on the databases are corresponding to different databases respectively, so that reading and writing separation of the databases is achieved, and the access pressure and IO pressure of the databases can be reduced effectively.