Database access method and system

An access method and database technology, applied in the direction of database distribution/replication, structured data retrieval, special data processing applications, etc., can solve problems such as accessing wrong databases, network address conflicts, accessing errors, etc., to achieve improved reliability, reliable host Standby switching and little impact on the network
CN108009239BActive Publication Date: 2020-08-04杭州有赞科技有限公司
5 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
杭州有赞科技有限公司
Publication Date
2020-08-04

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention discloses a database visit method and system. The database visit method comprises steps of arranging a database agent, receiving a database visit request sent by a client end via the database agent, visit the database, controlling the database agent to dynamically change a database practically visited by the client end, converting master and spare databases, and transmitting the database visit request to a normally-working master database or a spare database. Master and spare database conversion can be realized when the database practically visited by the client end is dynamically changed by the database agent. Without the use of virtual network addresses, network address conflicts due to failures of unload of the virtual network address, or faults due to failures of reception of address resolution protocols by the client end can be prevented; and database visit reliability can be greatly enhanced.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the technical field of database systems, in particular to a database access method and system. Background technique

[0002] In the prior art, a virtual network address (Virtual IP, VIP for short) is usually used to drift from the primary database to the standby database, so that the client accesses the changed database. When the virtual network address is uninstalled from the server where the main database is located, the uninstallation may not be completed due to host machine failure, which may easily cause network address (ie IP) conflicts. Moreover, when the address of the virtual network changes, an Address Resolution Protocol (ARP) broadcast needs to be sent. If the client fails to receive the broadcast, it cannot perceive the change of the virtual network address, which will lead to access to the wrong database.

[0003] Therefore, the existing method of using the virtual network address to realize client access to a c...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More