Database read-write separation cluster real-time consistency method based on JDBC dispatcher

The invention relates to a database read-write separation cluster real-time consistency method based on a JDBC dispatcher, which comprises the following steps that: when an application program calls amiracle database JDBC driver to establish database connection, the miracle database JDBC driver crea...

Full description

Saved in:
Bibliographic Details
Main Authors TAN WEIBO, SUN LEI, JIANG XU, GU YUNSU, LIU BINAN, WU SONG, JI TAOTAO
Format Patent
LanguageChinese
English
Published 03.09.2019
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:The invention relates to a database read-write separation cluster real-time consistency method based on a JDBC dispatcher, which comprises the following steps that: when an application program calls amiracle database JDBC driver to establish database connection, the miracle database JDBC driver creates the read-write separation dispatcher; the application program sends SQL statements on the established database connection through the miracle database JDBC; the read-write separation dispatcher is used for analyzing an input SQL statement to generate an execution strategy: if the SQL statementsare host execution strategies, the SQL statements are distributed to the host for execution by the read-write separation distributor and an execution result is returned, and if the SQL statements arestandby execution strategies, the SQL statements are distributed to the standby for execution by the read-write separation distributor and the execution result is returned. The method is reasonable in design, the load of the h
Bibliography:Application Number: CN201910495097