Method and device for realizing distributed database agent

A database and distributed technology, applied in the field of distributed database proxy, can solve problems such as unsatisfactory distributed database proxy and inability of clients to access in time

Active Publication Date: 2013-03-20
BEIJING SOHU NEW MEDIA INFORMATION TECH
View PDF6 Cites 46 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] With the expansion of database application scale, distributed databases are more and more widely used. For distributed databases, some local databases may be added or deleted at any time. However, since general database agents can only be statically configured A group of databases, when a local database increases, the client cannot access the database in time, so it cannot meet the needs of distributed database agents

Method used

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
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for realizing distributed database agent
  • Method and device for realizing distributed database agent
  • Method and device for realizing distributed database agent

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0069] In order to make the above objects, features and advantages of the present invention more comprehensible, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0070] see figure 1 , is a flow chart of a method for implementing a distributed database agent provided by the present invention, as shown in the figure, the method includes:

[0071] S101. Update the saved database configuration information by monitoring changes in the database configuration information, the database configuration information at least including the database name, its corresponding IP address and port;

[0072] S102. Receive a connection request from the client to the target database, and obtain the name of the target database;

[0073] S103. If the target database name is in the saved database configuration information, establish a connection between the client and the target datab...

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

PUM

No PUM Login to view more

Abstract

The invention discloses a method and a device for realizing a distributed database agent so as to achieve a purpose of preventing client access from being influenced at the change moment of a database. The method comprises the following steps: updating the stored database configuration information by monitoring the change of the database configuration information, wherein the configuration information at least comprises a database name, and an IP address and a port corresponding to the database name; receiving a connecting request of a client for a target database and obtaining a target database name; and if the target database name is in the stored database configuration information, establishing the connection of the client and the target database according to the IP address and the port corresponding to the target database name, thereby realizing the timely updating for the configuration information of the database following the change of a back-end database when the back-end database is changed, and preventing the access of the client from being influenced.

Description

technical field [0001] The invention relates to the field of distributed databases, in particular to a method and device for realizing distributed database agents. Background technique [0002] The database proxy is an entity between the database client and the server, which mainly plays the role of request forwarding. When the client uses each database, it does not need to know the IP and port of the back-end database server, but only needs to know the IP and port of the database proxy, as well as the database user name, password and database name to be used, and the database can be accessed through the database proxy. For example, MySQL Proxy database proxy. [0003] With the expansion of database application scale, distributed databases are more and more widely used. For distributed databases, some local databases may be added or deleted at any time. However, since general database agents can only be statically configured A group of databases, when a local database incr...

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

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30H04L29/06
Inventor 张辉华
Owner BEIJING SOHU NEW MEDIA INFORMATION TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap