CN108093094A - Database instance access method, device, system, storage medium and equipment - Google Patents

Database instance access method, device, system, storage medium and equipment Download PDF

Info

Publication number
CN108093094A
CN108093094A CN201711294064.7A CN201711294064A CN108093094A CN 108093094 A CN108093094 A CN 108093094A CN 201711294064 A CN201711294064 A CN 201711294064A CN 108093094 A CN108093094 A CN 108093094A
Authority
CN
China
Prior art keywords
link address
address
database
entity
virtual link
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201711294064.7A
Other languages
Chinese (zh)
Other versions
CN108093094B (en
Inventor
黄辉
王甲坤
胡彬
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Tencent Technology Shenzhen Co Ltd
Tencent Cloud Computing Beijing Co Ltd
Original Assignee
Tencent Technology Shenzhen Co Ltd
Tencent Cloud Computing Beijing Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Tencent Technology Shenzhen Co Ltd, Tencent Cloud Computing Beijing Co Ltd filed Critical Tencent Technology Shenzhen Co Ltd
Priority to CN201711294064.7A priority Critical patent/CN108093094B/en
Publication of CN108093094A publication Critical patent/CN108093094A/en
Application granted granted Critical
Publication of CN108093094B publication Critical patent/CN108093094B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L61/00—Network arrangements, protocols or services for addressing or naming
    • H04L61/09—Mapping addresses
    • H04L61/25—Mapping addresses of the same type
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention relates to a kind of database instance access method, device, system, storage medium and equipment, database instance access method includes：Obtain database instance access request；Virtual link address is extracted from the database instance access request；Ask the target database example accessed corresponding with the database instance access request in the virtual link address；Obtain the entity link address there are mapping relations with the virtual link address；Determine the type of database belonging to the target database example；According to the entity link address, the target database example is accessed by database plug-in unit matched with the type of database.The scheme that the application provides realizes the access between different database instances.

Description

Database instance access method, device, system, storage medium and equipment
Technical field
The present invention relates to field of computer technology, more particularly to a kind of database instance access method, device, system, Storage medium and equipment.
Background technology
With the fast development of computer technology, data scale is skyrocketed through.More and more user's selections pass through data The data service that storehouse server provides carries out data processing.At present, the database instance on database server is by connecting ground The mode of location provides data service to the user.
However traditional this database access form, the virtual link address that each database instance externally provides only allow User individually distinguishes connected reference from external to each database instance, so as to cause can not phase between different database instances The problem of mutually accessing.
The content of the invention
Based on this, it is necessary to the problem of for can not mutually be accessed between different database instance at present, provide one Kind database instance access method, device, system, storage medium and equipment.
A kind of database instance access method, including：
Obtain database instance access request；
Virtual link address is extracted from the database instance access request；The virtual link address and the data Storehouse example access request asks the target database example accessed to correspond to；
Obtain the entity link address there are mapping relations with the virtual link address；
Determine the type of database belonging to the target database example；
According to the entity link address, the target is accessed by database plug-in unit matched with the type of database Database instance.
A kind of database instance access mechanism, including：
First acquisition module, for obtaining database instance access request；
Extraction module, for extracting virtual link address from the database instance access request；The virtual link Ask the target database example accessed corresponding with the database instance access request in address；
Second acquisition module, for obtaining the entity link address with the virtual link address there are mapping relations；
Determining module, for determining the type of database belonging to the target database example；
Access modules, for according to the entity link address, by being inserted with the matched database of the type of database Part accesses the target database example.
A kind of database instance accesses system, including node server and management server, wherein：
The node server is used to obtain database instance access request；It is carried from the database instance access request Take virtual link address；The target database accessed is asked with the database instance access request in the virtual link address Example corresponds to；
The node server is additionally operable to send source host address to the management server and virtual link address is common Corresponding address of cache request；The source host address is corresponding with source database example；The source database example runs on institute State node server；
The management server is used to connect the source host address and virtual link address co-map for entity It is grounded location；The entity link address is fed back to the node server according to described address mapping request；
The node server is additionally operable to determine the type of database belonging to the target database example；According to the reality Body link address accesses the target database example by database plug-in unit matched with the type of database.
A kind of computer readable storage medium is stored with computer program on the computer readable storage medium, described When computer program is executed by processor so that the processor performs following steps：
Obtain database instance access request；
Virtual link address is extracted from the database instance access request；The virtual link address and the data Storehouse example access request asks the target database example accessed to correspond to；
Obtain the entity link address there are mapping relations with the virtual link address；
Determine the type of database belonging to the target database example；
According to the entity link address, the target is accessed by database plug-in unit matched with the type of database Database instance.
A kind of computer equipment including memory and processor, stores computer program, the meter in the memory When calculation machine program is performed by the processor so that the processor performs following steps：
Obtain database instance access request；
Virtual link address is extracted from the database instance access request；The virtual link address and the data Storehouse example access request asks the target database example accessed to correspond to；
Obtain the entity link address there are mapping relations with the virtual link address；
Determine the type of database belonging to the target database example；
According to the entity link address, the target is accessed by database plug-in unit matched with the type of database Database instance.
Above-mentioned database instance access method, device, system, storage medium and computer equipment are locally getting number During according to database instance access request, you can the virtual link corresponding to target database example that directly extraction intention accesses Location, and then get that there are mapping relations, the entity that can mutually be accessed between database instance with the virtual link address Link address, then determine the type of database belonging to target database example, so as to can be realized according to the entity link address, The data service provided by database plug-in unit access target database instance matched with the type of database, realizes difference Database instance between access.
A kind of database instance management method, including：
Receive the corresponding address of cache request jointly of source host address and virtual link address；The source host address and source Database instance corresponds to；The virtual link address is corresponding with target database example；
It is entity link address by the source host address and virtual link address co-map；
The entity link address is fed back according to described address mapping request；The entity link address is used to indicate described Source database example accesses the target database example according to the entity link address.
A kind of database instance managing device, including：
Receiving module, for receiving the corresponding address of cache request jointly of source host address and virtual link address；It is described Source host address is corresponding with source database example；The virtual link address is corresponding with target database example；
Mapping block, for being connected ground with virtual link address co-map for entity by the source host address Location；
Feedback module, for feeding back the entity link address according to described address mapping request；The entity connection ground Location is used to indicate the source database example and accesses the target database example according to the entity link address.
A kind of computer readable storage medium is stored with computer program on the computer readable storage medium, described When computer program is executed by processor so that the processor performs following steps：
Receive the corresponding address of cache request jointly of source host address and virtual link address；The source host address and source Database instance corresponds to；The virtual link address is corresponding with target database example；
It is entity link address by the source host address and virtual link address co-map；
The entity link address is fed back according to described address mapping request；The entity link address is used to indicate described Source database example accesses the target database example according to the entity link address.
A kind of computer equipment including memory and processor, stores computer program, the meter in the memory When calculation machine program is performed by the processor so that the processor performs following steps：
Receive the corresponding address of cache request jointly of source host address and virtual link address；The source host address and source Database instance corresponds to；The virtual link address is corresponding with target database example；
It is entity link address by the source host address and virtual link address co-map；
The entity link address is fed back according to described address mapping request；The entity link address is used to indicate described Source database example accesses the target database example according to the entity link address.
Above-mentioned database instance management method, device, storage medium and computer equipment are receiving address of cache request Afterwards, you can obtain with the address of cache corresponding source host address of request and virtual link address, and then by source host address and Virtual link address co-map is the entity link address that can mutually be accessed between database instance, source database example from And the data service that can be provided according to the entity link address access target database instance, realize different database instances Between access.
Description of the drawings
Fig. 1 is the applied environment figure of database instance access method in one embodiment；
Fig. 2 is the flow diagram of database instance access method in one embodiment；
Fig. 3 is that database instance accesses the principle schematic that connection is established in one embodiment；
Fig. 4 is the sequence diagram that Connecting quantity is updated in one embodiment；
Fig. 5 is the flow diagram of database instance management method in one embodiment；
Fig. 6 is the principle schematic that database instance accesses in one embodiment；
Fig. 7 is that database instance accesses the newer principle schematic of connection in one embodiment；
Fig. 8 is the sequence diagram that Connecting quantity is deleted in one embodiment；
Fig. 9 is the function structure chart of database instance access mechanism in one embodiment；
Figure 10 is the function structure chart of database instance managing device in one embodiment；
Figure 11 is the function structure chart of database instance managing device in another embodiment；
Figure 12 is the cut-away view of one embodiment Computer equipment.
Specific embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, with reference to the accompanying drawings and embodiments, it is right The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and It is not used in the restriction present invention.
Fig. 1 is the applied environment figure of database instance access method in one embodiment.With reference to Fig. 1, the database instance Access method is applied to database instance and accesses system.The database instance, which accesses system, includes user terminal 110, node serve Device 120, management server 130 and gateway device 140.Wherein, node server 120 includes at least first node server 121 With section point server 122.Active data storehouse example is run on first node server 121, on section point server 122 Operation has target database example.Source database example on first node server 121, passes through database provided by the invention Example access method accesses the target database example on section point server 122.User terminal 110 passes through network and first Node server 121 connects, and first node server 121 passes through network connection by network and management server 130.First segment It is connected between point server 121 and section point server 122 by gateway device 140.Gateway device 140 can be specifically road By device or interchanger etc..
It will be understood by those skilled in the art that node server 120 and management server 130 can be located at Cloud Server Network environment.Specifically, node server 120 and management server 130 are located at the public cloud net in Cloud Server network environment Network environment or the private clound network environment in Cloud Server network environment.First node server 121 and second Node server 122 can be positioned at same Cloud Server network environment or positioned at different Cloud Server network rings Border.
Fig. 2 is the flow diagram of database instance access method in one embodiment.The present embodiment is mainly in this way It is illustrated applied to the first node server 121 in above-mentioned Fig. 1.With reference to Fig. 2, the database instance access method is specific Include the following steps：
S202 obtains database instance access request.
Wherein, database instance access request is for applying for accessing the request of a database instance.Database instance Access request can be the request of user terminal application one database instance of access or a database instance application Access the request of another database instance.Database instance is the example that database server provides data service to the user. The internal data for the data service operation database instance that user terminal can be provided by database instance.In one embodiment In, database instance can be specifically PostgreSOL examples, MySQL examples, Mongo examples or Redis examples etc..
In one embodiment, it is real can to initiate database to the management server in Cloud Server network environment for user terminal Example application request, management server are receiving database instance application request, are notifying the section in Cloud Server network environment Point server carries out database instance and creates operation, so as to create the database instance for belonging to user on node server.Pipe Virtual link address can be distributed for the database instance again by managing server, and the virtual link address is back to user terminal, So as to which user terminal can access one's own database instance according to the virtual link address.It is appreciated that user terminal can Different database instances is created on different node servers by management server, it can also be on same node server Create different database instances.
Specifically, user terminal can be accessed by the virtual link address of first database example and be located at Cloud Server net First database example (source database example) in network environment on first node server.User terminal can pass through the first number again The data base administration control command provided according to storehouse example initiates database instance access request, and request is accessed to be taken positioned at section point The second database instance (target database example) being engaged on device, first node server access so as to get database instance Request.
Wherein, the first node server in Cloud Server network environment can be the physical server of physical presence, It can be the dummy node server for thering is physical server virtually to obtain.
For example, user terminal can create PostgreSOL examples by management server on node server A, MySQL examples are created on node server B, and obtain virtual link address A and visit that user accesses the PostgreSOL examples Ask the virtual link address B of the MySQL examples.Under normal conditions, user terminal need to pass through virtual link address A and virtual link Address B distinguishes connecting node server A and node server B, to access PostgreSOL examples and MySQL examples respectively. In the present embodiment, user terminal first passes through virtual link address A and accesses PostgreSOL examples, is accessing PostgreSOL examples When, MySQL examples are accessed by PostgreSOL examples.
S204 extracts virtual link address from database instance access request；Virtual link address and database instance Access request asks the target database example accessed to correspond to.
Wherein, link address is for connecting the network address of database instance.Link address may include Internet protocol Address (Internet Protocol Address, IP address) and the network port.Virtual link address is unallocated to true section The link address of point server.Entity link address has been distributed to the true link address of real node server.
In Cloud Server network environment, the host (node serve corresponding to the database server of data service is provided Device) entity link address and virtual link address can be corresponding with respectively.Theoretically, user terminal passes through in the two link addresses Any one link address may be connected to this node server, and then the database on accessed node server is real Example.And it only can mutually be accessed by entity link address between the node server under Cloud Server network environment.
It is appreciated that in order to ensure the Information Security under Cloud Server network environment, cloud service provider usually only will Virtual link address is supplied to user terminal.That is, current number of the user terminal in the case where accessing Cloud Server network environment During according to storehouse example, it can only be realized by virtual link address and individually access different database instances.
Specifically, database instance access request can carry Connecting quantity.Connecting quantity is that characterization is intended to realize connection The data of source database example and target database example.User terminal is when initiating database instance access request, you can will The related data for being intended to the target database example accessed is carried as Connecting quantity in database instance access request.Due to Virtual link address is usually only supplied to user terminal by cloud service provider, then Connecting quantity can be target database reality Corresponding virtual link address of example etc..Connecting quantity can be specifically the IP address and network port number of target database example Deng.
S206 obtains the entity link address there are mapping relations with virtual link address.
Specifically, first node server can inquire about reflecting for the virtual link address established in advance and entity link address Relation is penetrated, the virtual link address of extraction and each virtual link address in mapping relations are compared, is inquiring and is carrying During the consistent virtual link address in the virtual link address that takes, the entity connection of the virtual link address of cache inquired extremely is obtained Address, so as to the virtual link address that obtains and extract, there are the entity link addresses of mapping relations.
Here the virtual link address established in advance and the mapping relations of entity link address, can be current time it The mapping relations established when being accessed mutually between preceding disparate databases example.The mapping relations are established by management server, mapping Relation can store on the management server after foundation, be stored in setting independently of other computers of management server It is standby upper, so that node server can be inquired about when needing and inquiring about mapping relations.In one embodiment, mapping is closed System can be stored as network connection relation mapping table by way of form.
S208 determines the type of database belonging to target database example.
Wherein, type of database is the foundation classified to database.In the present embodiment, it is during database difference Belong to different type of database.For example, PostgreSOL examples, MySQL examples, Mongo examples or Redis examples are Each belong to different type of database.
Specifically, database instance access request may specify request type.First node server can analyze the database Request type specified by example access request obtains the class database belonging to the database instance that user terminal intention accesses Type.
S210, according to entity link address, by with the matched database plug-in unit access target database of type of database Example.
Wherein, database plug-in unit is the computer program that expanded function is provided for database.It is patrolled between different databases It is independent from each other on volume, when a certain database instance is intended to access the inter-library operation of progress of other databases, then needs to pass through Database plug-in unit realizes the expanded function of inter-library operation.
For example, for PostgreSOL examples, PostgreSOL officials develop postgres_fdw modules for it, should Postgres_fdw modules provide external data wrapper fdw, it can be used to access in PostgreSOL examples outer Portion's data.It can be realized for the external data for belonging to disparate databases example by different types of external data wrapper, For example, mongo_fdw, for accessing Mongo examples, mysql_fdw is used to access MySQL examples and redis_fdw is used for Access Redis examples etc..
Specifically, first node server determine target database example belonging to type of database, and get with After entity link address corresponding to target database example, you can call with the matched database plug-in unit of type of database according to The entity link address is initiated the connection to target database example, with access target database instance.
Above-mentioned database instance access method, when locally getting data database example access request, you can directly Extraction is intended to the virtual link address corresponding to the target database example accessed, and then gets and deposited with the virtual link address In mapping relations, the entity link address that can mutually be accessed between database instance, then determine target database example institute The type of database of category, so as to can be realized according to the entity link address, by with the matched database of the type of database The data service that plug-in unit access target database instance provides, realizes the access between different database instances.
In one embodiment, entity link address is by by local host address and virtual link address, according to mesh What the corresponding mapping mode co-map of network environment residing for mark database instance obtained.
It is appreciated that the data bank access method provided in the embodiment of the present invention is applied to Cloud Server network environment.Cloud Server network environment is the basic network environment for building other networks.The such as publicly-owned cloud network of other networks or private clound net Network etc..Publicly-owned cloud network is the external cloud network that cloud service provider provides, and public cloud network struction is in cloud service network environment On, cellular logic is isolated between publicly-owned cloud network.Privately owned cloud network is a kind of self-defined cloud net that cloud service provider provides Network, is supplied to the ability of the self-defined network environment of cloud service user, and cloud service user can affix one's name in private clound network internal The cloud services resources such as the fast storage of cloud host, load balancing, database and Nosql.Cellular logic is isolated between privately owned cloud network.
For example, a kind of plug and play that Cloud Server network environment, which can be Tencent cloud, to be provided, it is reliable and stable, can bullet Network environment where the online database service (CDB, Cloud Database) that property is stretched.Tencent's Cloud Server (CVM, Cloud Virtual Machine) be high-performance high stable cloud virtual machine, user can create one's own number on CVM According to storehouse example.The privately owned cloud network of Tencent (VPC, Virtual Private Cloud) is can user-defined cyberspace.
Specifically, the step of mapping obtains entity link address is performed by management server.Management server is for unified Manage the network connection mapping relations under Cloud Server network environment.
In one embodiment, when network environment residing for network environment residing for target database example and source database example It is taken for the node where the node server where consolidated network environment, that is, target database example and source database example When business device belongs to same Internet data center (IDC, Internet Data Center), source database example and target data Can access be directly attached by host-physical address between the example of storehouse.Management server can directly acquire and virtual link The host-physical address is fed back to first node server by the host-physical address of the corresponding node server in address, and first Node server is so as to getting the entity link address with virtual link address there are mapping relations.
In one embodiment, it is empty when running on the cloud that is virtualized by physical server residing for target database example Node server where plan server CVM, that is, target database example and the node serve where source database example When device belongs to same Cloud Server network environment, management server can determine node server corresponding with virtual link address The host parameter of host parameter (host parameters) and source database example the machine, further according to current Cloud Server network environment The routing policy of middle gateway device is formed by source database example access target database instance access path, obtains may have access to mesh The entity link address of database instance is marked, thus will be in virtual link address of cache to the entity link address.Wherein, gateway Equipment may include router and interchanger etc..The routing policy of gateway device is to add routed path between each gateway device Foundation.
In one embodiment, the node server where target database example and the node where source database example Server belongs to the node server and source database where different Internet data centers, that is, target database example When node server where example belongs to different Cloud Server network environments, management server can be by determining with virtually connecting The host address of the corresponding database server in location and/or the host parameter of source database example the machine are grounded, further according to current The routing policy formation of gateway device in Cloud Server network environment and SiteServer LBS is accessed by source database example Target database example routed path obtains may have access to the entity link address of target database example, so as to by virtual link Address of cache is in the entity link address.Wherein, SiteServer LBS can be specifically that TGW (Tencent GateWay) is A set of system for realizing that more nets are uniformly accessed into, outer net network request forwards, supports automatic load balancing.
In above-described embodiment, provide for the target database example under different network environments, mapping obtains really may be used The approach of the link address of access realizes the mutual access between the database instance under different network environments.
In one embodiment, which further includes：It is reflected when there is no corresponding with virtual link address When penetrating relation, local host address is obtained；Local host address and virtual link address are sent to management server；Reception pipe Manage the entity link address of server feedback；The entity link address of feedback is management server according to local host address with What virtual link address determined jointly；Newly-built virtual link address is for the mapping relations of the entity link address of feedback.
Specifically, first node server can be obtained when not inquiring mapping relations corresponding with virtual link address Local host address, then local host address and virtual link address are sent to management server.Management server is receiving During to the virtual link address, can jointly be determined according to the local host address and virtual link address can be by source database example The entity link address of access target database instance.Wherein, entity link address can also be management server by incite somebody to action this Ground host address and virtual link address, according to target database example residing for the corresponding mapping mode of network environment reflect jointly It penetrates.
Wherein, local host address can only be the host-physical address of node server where source database example； Can be the host parameter of node server where source database example, which is the data for the address for reflecting host, Including host-physical address.
In the present embodiment, do not find currently can the directly link address of access target database instance when solution Approach, by server according to local host address and the generation of virtual link address can direct access target database instance connection Address, it is achieved thereby that the access between different database instances.
In one embodiment, database instance access request intercepts to obtain by proxy plug-ins.Proxy plug-ins are installed on In database instance, wound is initiated for intercepting the data base administration control command that user terminal is provided by first database example The request of external server is built, generates database instance access request.
For example, user when accessing PostgreSOL examples, can call CREATE SERVER orders to create server.Here " CREATE SERVER " is the data base administration control command that PostgreSOL examples provide, for defining One new external server, owner can be become by defining the user of the server.Server is the external server created, External server generally includes external data wrapper fdw and is used for accessing needed for an external data source (target database example) Connecting quantity.
Specific code is as follows：
CREATE SERVER foreign_server
FOREIGN DATA WRAPPER postgres_fdw
OPTIONS(host'192.83.123.89',port'5432',dbname'foreign_db')；
In this example, user terminal intention is connected to one and is located on host 192.83.123.89 and monitors The PostgreSQL examples of 5432 ports.The entitled foreign_db of the database instance.
Specifically, outside the foundation for intercepting intercepting api calls user terminal and initiating that proxy plug-ins can be provided by database instance The request of portion's server generates database instance access request.Such as：Proxy plug-ins Agent can pass through PostgreSQL's Hook functions ProcessUtility_hook intercepts the request that user creates Server, generates database instance access request.
Further, first node server, can after generation database instance access request is intercepted by proxy plug-ins The Connecting quantity that the database instance access request defines is extracted, corresponding with target database example is virtually connected so as to get It is grounded location.First node server can inquire about network connection mapping table by proxy plug-ins again, obtain depositing with virtual link address In the entity link address of mapping relations.
In one embodiment, do not inquired and virtual link address in network connection mapping table when by proxy plug-ins During corresponding mapping relations, local host address and virtual link address are sent to management server；It is connect by proxy plug-ins Closed tube manages the entity link address of server feedback；The entity link address of feedback, be management server according to local host Location determines jointly with virtual link address；By proxy plug-ins, virtual link address pair is created in network connection mapping table In the mapping relations of the entity link address of feedback.
Specifically, first node server is not inquired in network connection mapping table not inquired by proxy plug-ins During mapping relations corresponding with virtual link address, the database instance access request of generation can be sent to management server, Management server obtains the virtual link address corresponding to target database example from database instance access request.Management clothes Business device can also obtain the corresponding host address of first node server, by the host address and virtual link address, according to mesh The corresponding mapping mode co-map of network environment residing for mark database instance obtains entity link address.
Fig. 3 shows that database instance accesses the principle schematic that connection is established in one embodiment.With reference to figure 3, this reality It applies in example, source database example is PostgreSQL examples.User terminal can call CREATE SERVER in PostgreSQL Order creates server, the Hook functions that the proxy plug-ins Agent installed on PostgreSQL passes through PostgreSQL ProcessUtility_hook intercepts the request that user terminal creates Server, analysis request type and Connecting quantity, then will Connecting quantity is sent to management server Center.Management server can be further according to the virtual link address in Connecting quantity, really Set the goal network environment residing for database instance, and then the network environment classification according to residing for target database example creates network and reflects It penetrates, obtains for the entity link address of the direct access target database instance of source database example.
Wherein, when the virtual link address in Connecting quantity is the virtual ip address of privately owned cloud network VPC, it may be determined that mesh Mark database instance residing for network environment for internal IDC (with source database example where server be in consolidated network) or The Cloud Server CVM that privately owned cloud network VPC machine tools virtually dissolve.When the virtual link address in Connecting quantity is external network During virtual ip address, it may be determined that network environment residing for target database example is exterior I DC (with being serviced where source database example Device is in different cloud service network environments).Belong between the database instance of identical IDC environment can directly by host address into Row connected reference.Can virtual private be established by the routing policy of gateway device for the Cloud Server CVM that machine tool virtually dissolves Network (VPN, Virtual Private Network), so as to establish the net between source database example and target database example Network connects.(virtual link address is outer net IP address) can be built by TGW between database instance for belonging to different IDC environment Vertical network connection between source database example and target database example.
Management server Center is back to agency after network mapping success is created, by obtained entity link address and inserts Part Agent.After Agent receives the entity link address of Center returns, newly-built mapping is inserted into network connection mapping table Relation terminates Hook function flows, enters the program circuit that PostgreSQL creates Server in itself, and then pass through fdw roots Factually body link address initiates TCP connection, with access target database instance.
In one embodiment, the source database example on first node server, which can also be, is accessing first object number After the example of storehouse, continue to access the second target database example.At this point, proxy plug-ins, which can intercept user terminal, passes through the first data The data base administration control command that storehouse example provides initiates the request of update external server, and proxy plug-ins check network connection again It whether there is mapping relations corresponding with virtual link address in mapping table.For example, user is when accessing PostgreSOL examples, ALTER SERVER orders can be called to update server.
In one embodiment, which further includes：It obtains corresponding with database instance access request Requesting party identifies.Local host address and virtual link address are sent to management server, including：Requesting party is identified, this Ground host address and virtual link address, which correspond to, is sent to management server；Exist when requesting party identifies for virtual link address Access rights when, perform receive management server feedback entity link address the step of.
Wherein, requesting party's mark can include the character string of at least one of number, letter and symbol character, be used for One requesting party of unique mark.Requesting party is the user for initiating database instance access request.The database that user terminal is initiated Requesting party's mark can be carried in example access request.User terminal can also correspond to requesting party and identify initiation database instance visit Ask request.
Specifically, proxy plug-ins hair of the management server on first node server or first node server is received During the database instance access request sent, parameter verification is carried out first.Parameter verification includes parameter format verification and user right Verification.User right verification needs detection requesting party to identify whether the access rights for having for virtual link address.Work as request When side's mark has the access rights for virtual link address, management server just continues to execute subsequent operation.
In the present embodiment, by virtual link address of cache for entity link address with access target database instance Before, authentication is first carried out, only address of cache is just carried out by rear in authentication, ensure that the security of data access.
In one embodiment, which further includes：Entity link address is recorded as database instance Connecting quantity corresponding to access request；The Connecting quantity of record, for retain in network connection mapping table with Connecting quantity pair The mapping relations answered；When end, which accesses, runs on the target database example on standby node server, Connecting quantity is deleted It removes.
Specifically, the node server in cloud service network environment takes outside being created by local database instance When business device (server) accesses other database instances, Connecting quantity can be recorded in local database instance, for table Show that the corresponding connection both sides of the Connecting quantity are carrying out data access operation, management server is in management network connection mapping table When, it is necessary to retain mapping relations corresponding with the Connecting quantity in network connection mapping table.
Wherein, Connecting quantity is the general designation for connecting data corresponding to both sides.Connecting quantity can be multiple data.This landlord Machine address can be Connecting quantity, and the virtual link address of target database example can also be Connecting quantity, target database The entity link address of example can also be Connecting quantity.
In the present embodiment, for the Connecting quantity in access target database instance during timely record access, visiting Relevant connection parameter is deleted after asking, avoids the residual waste storage resource of invalid data.
Fig. 4 shows the sequence diagram that Connecting quantity is updated in one embodiment.With reference to figure 4, user terminal is connected in triggering After parameter updating request (ALTER SERVER orders), first node server can intercept the request, and then be reflected in network connection It (can be specifically the Hook of Agent that mapping relations corresponding with the virtual link address of target database example are searched in firing table The function request, and inquire about network connection mapping table).In the absence of the mapping relations, first node server (Agent) to The newly-built mapping relations of management server request.Management server identifies the power of accessing when listening to the request, to requesting party Limit verification, and create routed path after verification passes through, obtain the corresponding entity link address in virtual link address and be back to First node server (Agent).First node server (Agent) can reflecting virtual link address and entity link address It penetrates in relation write-in network connection mapping table.Entity link address can be also recorded as connecting by first node server (Agent) Updated Connecting quantity to update Connecting quantity, is returned to user terminal by parameter.
In above-described embodiment, the access process of integration across database example is uniformly processed by proxy plug-ins, ensure that different The feasibility of access between database instance improves the access efficiency between different database instances.
In one embodiment, according to entity link address, accessed by database plug-in unit matched with type of database Target database example, including：According to entity link address, by with the matched database plug-in unit of type of database, access fortune Row is in the target database example on host node server.The database instance access method further includes：When access runs on master When target database example on node server fails, then spare link address corresponding with entity link address is obtained；Root According to spare link address, by with the matched database plug-in unit of type of database, access run on standby node server Target database example.
It is appreciated that the database instance in cloud service network environment can usually correspond to two node servers to ensure High reliability.After host node server delays machine, standby node server can be switched to, to ensure that database instance provides number According to reliability of service.
Specifically, the entity link address acquired in first node server is to run on host node service for accessing The link address of target database example on device.Spare link address is for accessing operation and standby node server The link address of target database example.When first node server access runs on the target database on host node server When example fails, judgement may be that active-standby switch has occurred in the node server corresponding to target database example, at this point, first Node server can obtain spare link address corresponding with entity link address, so as to according to spare link address, by with The matched database plug-in unit of type of database accesses the target database example run on standby node server.
In the present embodiment, when active-standby switch has occurred in the node server corresponding to target database example, in time It is contacted with the foundation of standby node server, accesses the target database example on standby server, ensure that database instance is visited That asks is smoothed out.
In one embodiment, first node server, can be according to spare connection ground when getting spare link address Location updates Connecting quantity.
Fig. 5 is the flow diagram of database instance management method in one embodiment.The present embodiment is mainly in this way It is illustrated applied to the management server 130 in above-mentioned Fig. 1.With reference to Fig. 5, which specifically includes Following steps：
S502 receives the corresponding address of cache request jointly of source host address and virtual link address；Source host address with Source database example corresponds to；Virtual link address is corresponding with target database example.
Specifically, address of cache request is to apply for that by routing policy be entity link address by virtual link address of cache Request.First node server where source database example can obtain local source host address and be intended to what is accessed Source host address and virtual link address are corresponded to and are sent to management server by the virtual link address of target database example, And address of cache request is initiated, management server is to so as to receiving source host address and virtual link address corresponding address jointly Mapping request.
Source host address and virtual link address co-map are entity link address by S504.
Specifically, management server can be common by source host address and virtual link address according to default routing policy It is mapped as entity link address.For example, management server can call the interface that public cloud network management module provides to obtain reality Body link address, public cloud network management module is for managing related routing policy, by virtual link address of cache for can be The link address that internal network directly accesses.
S506, according to address mapping request feedback entity link address；Entity link address is used to indicate source database reality Example is according to entity link address access target database instance.
Fig. 6 shows the principle schematic that database instance accesses in one embodiment.With reference to figure 6, user terminal can be sent out Database instance access request is played, the Agent installed on source database example (PostgreSQL examples) is intercepting the request Afterwards, source host address and virtual link address are corresponded to and is sent to management server center, and initiate address of cache request. For center by source host address and virtual link address co-map to feed back to Agent after entity link address, Agent will be new In the mapping relations write-in network connection mapping table built, and (MySQL is real according to entity link address access target database instance Example, Mongo examples or Redis examples).
Above-mentioned database instance management method, after address of cache request is received, you can obtaining please with the address of cache Ask corresponding source host address and virtual link address, and then by source host address and virtual link address co-map for can be with The entity link address accessed mutually between database instance, source database example is so as to according to entity link address access The data service that target database example provides, realizes the access between different database instances.
In one embodiment, it is entity link address by source host address and virtual link address co-map, including： According to virtual link address, the network environment residing for target database example is determined；According to the side of mapping corresponding with network environment Source host address and virtual link address co-map are entity link address by formula.
In one embodiment, which further includes acquisition and the corresponding request of address of cache request Side's mark；Verify access rights of requesting party's mark for virtual link address；After access rights verification passes through, perform source The step of host address and virtual link address co-map are entity link address.
In one embodiment, source database example runs on the first host node server.Database instance manager Method further includes：When source database example is changed to run on the first standby node server, the first standby node service is notified Think highly of new access target database instance.
Specifically, the first host node server for running source database example can report operating status to monitoring server, Monitoring server can carry out respective record when receiving the operating status reported.Management server is so as to passing through query monitor The operating status recorded in server obtains the hardware environment of source database example.Run the first main section of source database example Point server also directly can report operating status to management server.
When monitoring server or management server time-out do not receive the operating status that the first host node server reports When, it can determine that source database example is changed to run on the first standby node server, management server notifies that first is spare Node server access target database instance again.
In one embodiment, the first host node server can be in same public cloud network rings with monitoring server Border, the first host node server also can be in same public cloud network environment with management server.
In one embodiment, the first standby node server access target database instance again is notified, including：It obtains Backup host address corresponding with the first standby node server；First is determined according to backup host address and virtual link address Spare link address；First spare link address is fed back into the first standby node server；First spare link address is used for Indicate access target database instance again.
Fig. 7 shows that database instance accesses the newer principle schematic of connection in one embodiment.With reference to figure 7, source number Host node server Master1 and Slave1 are corresponded to according to storehouse example, target database example corresponds to host node server Master2 And Slave2.Master1 is connected realization with Master2 and passes through source database example access target database instance.Wherein, Master1 can report node state to monitoring server, and management server center is so as to by query monitor server The operating status of record obtains the hardware environment of source database example.After Master1 delays machine, center can be in network connection Slave1 is checked in mapping table, corresponding mapping relations is connected with Master2, if obtained there is no if with The corresponding backup host addresses of Slave1 determine the first spare link address according to backup host address and virtual link address, Corresponding mapping relations are connected to create Slave1 with Master2.The mapping relations can be write network connection and reflected by Center In firing table, and the first spare link address is fed back into Slave1, Slave1 so as to by the first spare link address with Master2 connections are realized through source database example access target database instance.
In above-described embodiment, the node server corresponding to source database example employs that a master one is standby to ensure High Availabitity Property, and when detecting active-standby switch, upgrade in time and establish the node server of connection, it ensure that the height that database instance accesses Availability.
In one embodiment, entity link address is used to indicate source database example, is accessed according to entity link address Run on the target database example on the second host node server.The database instance management method further includes：Work as number of targets When being changed to run on the second standby node server according to storehouse example, the second spare connection corresponding with entity link address is obtained Address；Second spare link address is fed back according to address mapping request；Second spare link address is used to indicate source database reality Example runs on the target database example on the second standby node server according to the access of spare link address.
Specifically, the second host node server of operational objective database instance can report operation shape to monitoring server State, monitoring server can carry out respective record when receiving the operating status reported.Management server is inquired about so as to pass through The operating status recorded in monitoring server obtains the hardware environment of source database example.The of operational objective database instance Two host node servers also directly can report operating status to management server.
When monitoring server or management server time-out do not receive the operating status that the second host node server reports When, it can determine that source database example is changed to run on the second standby node server, management server is obtained to be connected with entity The corresponding second spare link address in location is grounded, the second spare link address is fed back to；Second spare link address is used to refer to Show source database example, the target database run on according to the access of spare link address on the second standby node server is real Example.
In one embodiment, the second host node server can be in same public cloud network rings with monitoring server Border, the second host node server also can be in same public cloud network environment with management server.
Referring again to Fig. 7, wherein, Master2 can report node state to monitoring server, management server center so as to Can the hardware environment of target database example be obtained by the operating status recorded in query monitor server.Work as Master2 It delays after machine, center can check for Master1 in network connection mapping table and corresponding mapping is connected with Slave2 Relation, if obtaining backup host address corresponding with Slave2 there is no if, according to backup host address and virtual link address It determines the second spare link address, corresponding mapping relations is connected to create Master1 with Slave2.Center can reflect this It penetrates in relation write-in network connection mapping table, and the second spare link address is fed back into Master1, Master1 is so as to passing through The first spare link address is connected realization with Slave2 and passes through source database example access target database instance.
In the present embodiment, the node server corresponding to target database example employs that a master one is standby to ensure that height can It with property, and when detecting active-standby switch, upgrades in time and establishes the node server of connection, ensure that database instance accessed High availability.
In one embodiment, which further includes：In network connection mapping table, create virtual Link address is for the mapping relations of entity link address；The first node server record of scanning operation source database example Connecting quantity；For mapping relations addition mark corresponding with Connecting quantity in network connection mapping table；By network connection mapping table In be not added with mark mapping relations delete.
Specifically, the Connecting quantity on node server that management server can be in periodic scanning cloud service network environment, When often scanning is to Connecting quantity, i.e., it is the corresponding mapping relations addition mark of the Connecting quantity in network connection mapping table.It should Mark represents that the mapping relations are still valid, needs to be retained in cleaning.After the completion of scanning, detection network connects management server It connects in mapping table and marks, deleted for the mapping relations for being not added with mark.Management server can also delete create this reflect Penetrate the routing policy added during relation.
In one embodiment, which can be cleaning flag bit.Fig. 8, which is shown, deletes connection ginseng in one embodiment Several sequence diagrams.With reference to figure 8, management server is when proceeding by the cleaning of network connection mapping table, to network connection mapping table In each mapping relations cleaning flag bit initialization.Management server can scan the node server in cloud service network environment again On Connecting quantity, often scanning to Connecting quantity when, i.e., the corresponding mapping of the Connecting quantity is set in network connection mapping table The cleaning flag bit of relation.After the completion of Connecting quantity scanning, the cleaning flag bit record in network connection mapping table is detected, such as Fruit, which is found, not to be set, then according to the routed path added when deleting and creating the mapping relations, and in map information table Delete the mapping relations.
In the present embodiment, for the Connecting quantity in access target database instance during timely record access, visiting Relevant connection parameter is deleted after asking, avoids the residual waste storage resource of invalid data.
It should be understood that although each step in the flow chart of the various embodiments described above is shown successively according to the instruction of arrow Show, but these steps are not the inevitable order according to arrow instruction to be performed successively.Unless expressly state otherwise herein, this The order that the execution of a little steps is not stringent limits, these steps can perform in other order.Moreover, above-mentioned each implementation At least a portion step in example can include multiple sub-steps, and either these sub-steps of multiple stages or stage be not necessarily It is to perform completion in synchronization, but can performs at different times, the execution sequence in these sub-steps or stage It is not necessarily and carries out successively, but can be with other steps either at least a portion wheel in the sub-step of other steps or stage Stream alternately performs.
As shown in figure 9, in one embodiment, provide a kind of database instance access mechanism 900.With reference to Fig. 9, the number Include according to storehouse example access mechanism 900：First acquisition module 901, extraction module 902, the second acquisition module 903, determining module 904 and access modules 905.
First acquisition module 901, for obtaining database instance access request.
Extraction module 902, for extracting virtual link address from database instance access request；Virtual link address with Database instance access request asks the target database example accessed to correspond to.
Second acquisition module 903, for obtaining the entity link address with virtual link address there are mapping relations.
Determining module 904, for determining the type of database belonging to target database example.
Access modules 905, for according to entity link address, being accessed by database plug-in unit matched with type of database Target database example.
In one embodiment, entity link address, by by local host address and virtual link address, according to mesh What the corresponding mapping mode co-map of network environment residing for mark database instance obtained.
In one embodiment, the second acquisition module 903 is additionally operable to when there is no mappings corresponding with virtual link address During relation, local host address is obtained；Local host address and virtual link address are sent to management server；Receive management The entity link address of server feedback；The entity link address of feedback is management server according to local host address and void Intend what link address determined jointly；Newly-built virtual link address is for the mapping relations of the entity link address of feedback.
In one embodiment, the second acquisition module 903 is additionally operable to obtain ask corresponding with database instance access request The side's of asking mark；Requesting party is identified, local host address and virtual link address correspond to and be sent to management server；Work as requesting party When mark has the access rights for virtual link address, the step for the entity link address for receiving management server feedback is performed Suddenly.
In one embodiment, access modules 905 are additionally operable to according to entity link address, by being matched with type of database Database plug-in unit, access and run on target database example on host node server；When access runs on host node service When target database example on device fails, then spare link address corresponding with entity link address is obtained；According to spare company Be grounded location, by with the matched database plug-in unit of type of database, access and run on target data on standby node server Storehouse example.
In one embodiment, database instance access request intercepts to obtain by proxy plug-ins；Virtual link address leads to It crosses proxy plug-ins and is extracted from database instance access request and obtained.Second acquisition module 903 is additionally operable to look by proxy plug-ins Network connection mapping table is ask, obtains the entity link address there are mapping relations with virtual link address.
In one embodiment, the second acquisition module 903 is additionally operable to work as through proxy plug-ins in network connection mapping table When not inquiring mapping relations corresponding with virtual link address, local host address and virtual link address are sent to management Server；The entity link address of management server feedback is received by proxy plug-ins；The entity link address of feedback is management Server determines jointly according to local host address and virtual link address；By proxy plug-ins, in network connection mapping table In create virtual link address for the entity link address of feedback mapping relations.
In one embodiment, access modules 905 be additionally operable to by entity link address be recorded as database instance access please Seek corresponding Connecting quantity；The Connecting quantity of record, for retaining corresponding with Connecting quantity in network connection mapping table reflect Penetrate relation；When end, which accesses, runs on the target database example on standby node server, Connecting quantity is deleted.
As shown in Figure 10, in one embodiment, a kind of database instance managing device 1000 is provided.Reference Figure 10, The database instance managing device 1000 includes：Receiving module 1001, mapping block 1002 and feedback module 1003.
Receiving module 1001, for receiving the corresponding address of cache request jointly of source host address and virtual link address； Source host address is corresponding with source database example；Virtual link address is corresponding with target database example.
Mapping block 1002, for being entity link address by source host address and virtual link address co-map.
Feedback module 1003, for according to address mapping request feedback entity link address；Entity link address is used to refer to Show source database example according to entity link address access target database instance.
In one embodiment, mapping block 1002 is additionally operable to, according to virtual link address, determine target database example Residing network environment；According to mapping mode corresponding with network environment, source host address and virtual link address are reflected jointly It penetrates as entity link address.
In one embodiment, mapping block 1002 is additionally operable to obtain requesting party's mark corresponding with address of cache request； Verify access rights of requesting party's mark for virtual link address；After access rights verification passes through, perform by source host The step of location and virtual link address co-map are entity link address.
In one embodiment, source database example runs on the first host node server.Feedback module 1003 is additionally operable to When source database example is changed to run on the first standby node server, the first standby node server is notified to access again Target database example.
In one embodiment, feedback module 1003 is additionally operable to obtain spare master corresponding with the first standby node server Machine address；First spare link address is determined according to backup host address and virtual link address；By the first spare link address Feed back to the first standby node server；First spare link address is used to indicate access target database instance again.
In one embodiment, entity link address is used to indicate source database example, is accessed according to entity link address Run on the target database example on the second host node server.Feedback module 1003 is additionally operable to become when target database example When more running on the second standby node server, the second spare link address corresponding with entity link address is obtained；According to Address of cache request the second spare link address of feedback；Second spare link address is used to indicate source database example, according to standby The target database example on the second standby node server is run on link address access.
As shown in figure 11, in one embodiment, database instance managing device 1000 further includes：Cleaning modul 1004.
Cleaning modul 1004, in network connection mapping table, creating virtual link address for entity link address Mapping relations；The Connecting quantity of the first node server record of scanning operation source database example；It is mapped for network connection Mapping relations addition mark corresponding with Connecting quantity in table；The mapping relations that mark is not added in network connection mapping table are deleted It removes.
Figure 12 shows the cut-away view of one embodiment Computer equipment.The computer equipment can be specifically figure Node server 120 and management server 130 in 1.As shown in figure 12, which includes connecting by system bus Processor, memory and network interface.Wherein, memory includes non-volatile memory medium and built-in storage.The computer The non-volatile memory medium of equipment is stored with operating system, can also be stored with computer program, which is processed When device performs, it may be such that processor realizes database instance access/management method.Also computer can be stored in the built-in storage Program when the computer program is executed by processor, may be such that processor performs database instance access/management method.Ability Field technique personnel are appreciated that the structure shown in Figure 12, only with the block diagram of the relevant part-structure of application scheme, and The restriction for the computer equipment being applied thereon to application scheme is not formed, and specific computer equipment can be included than figure Shown in more or fewer components either combine some components or arranged with different component.
In one embodiment, database instance access/managing device that the application provides can be implemented as a kind of calculating The form of machine program, computer program can be run on computer equipment as shown in figure 12, computer equipment it is non-volatile Storage medium can store each program module for forming the database instance access/managing device, for example, shown in Fig. 9 first Acquisition module 901, extraction module 902, the second acquisition module 903, determining module 904 and access modules 905 etc..Each program mould The computer program of block composition causes processor to perform the database instance of each embodiment of the application described in this specification Step in access/management method.
For example, the computer equipment shown in Figure 12 can be by database instance access mechanism 900 as shown in Figure 9 First acquisition module 901 obtains database instance access request.It is carried by extraction module 902 from database instance access request Take virtual link address；The target database example pair accessed is asked with database instance access request in virtual link address It should.Entity link address with virtual link address there are mapping relations is obtained by the second acquisition module 903.By determining mould Block 904 determines the type of database belonging to target database example.By access modules 905 according to entity link address, pass through With the matched database plug-in unit access target database instance of type of database.
In one embodiment, provide a kind of database instance and access system, including node server and management service Device, wherein：
Node server is used to obtain database instance access request；It extracts from database instance access request and virtually connects It is grounded location；Ask the target database example accessed corresponding with database instance access request in virtual link address.
Node server is additionally operable to send source host address and virtual link address to management server common corresponding Location mapping request；Source host address is corresponding with source database example；Source database example runs on node server.
It is entity link address that management server, which is used for source host address and virtual link address co-map,；Base area Location mapping request is to node server feedback entity link address.
Node server is additionally operable to determine the type of database belonging to target database example；According to entity link address, By with the matched database plug-in unit access target database instance of type of database.
In one embodiment, management server is additionally operable to according to virtual link address, determines target database example institute The network environment at place；According to mapping mode corresponding with network environment, by source host address and virtual link address co-map For entity link address.
In one embodiment, management server is additionally operable to obtain requesting party's mark corresponding with address of cache request；School Test access rights of requesting party's mark for virtual link address；After access rights verification passes through, perform source host address With virtual link address co-map be entity link address the step of.Node server is additionally operable to obtain and be visited with database instance Ask request corresponding requesting party's mark；Requesting party is identified, local host address and virtual link address correspond to and be sent to management Server；Newly-built virtual link address is for the mapping relations of the entity link address of feedback.
In one embodiment, node server is additionally operable to entity link address being recorded as database instance access request Corresponding Connecting quantity；The Connecting quantity of record, for retaining mapping corresponding with Connecting quantity in network connection mapping table Relation；When end, which accesses, runs on the target database example on standby node server, Connecting quantity is deleted.Management clothes Business device is additionally operable in network connection mapping table, creates mapping relations of the virtual link address for entity link address；Scanning Run the Connecting quantity of the first node server record of source database example；For in network connection mapping table with Connecting quantity pair The mapping relations addition mark answered；The mapping relations that mark is not added in network connection mapping table are deleted.
In one embodiment, node server is additionally operable to according to entity link address, by being matched with type of database Database plug-in unit, access and run on target database example on host node server；When access runs on host node service When target database example on device fails, then spare link address corresponding with entity link address is obtained；According to spare company Be grounded location, by with the matched database plug-in unit of type of database, access and run on target data on standby node server Storehouse example.
In one embodiment, database instance access request intercepts to obtain by proxy plug-ins；Virtual link address leads to It crosses proxy plug-ins and is extracted from database instance access request and obtained.Node server is additionally operable to inquire about network by proxy plug-ins Mapping table is connected, obtains the entity link address there are mapping relations with virtual link address.
In one embodiment, node server is additionally operable to work as and not inquired about in network connection mapping table by proxy plug-ins During to mapping relations corresponding with virtual link address, local host address and virtual link address are sent to management service Device；The entity link address of management server feedback is received by proxy plug-ins；The entity link address of feedback, is management service Device determines jointly according to local host address and virtual link address；It is new in network connection mapping table by proxy plug-ins Build mapping relations of the virtual link address for the entity link address of feedback.
In one embodiment, node server includes the first host node server, the first standby node server, second Host node server and the second standby node server.First host node server is used to perform performed by above-mentioned node server The step of.When source database example is changed to run on the first standby node server, management server is additionally operable to notify One standby node server access target database instance again.
In one embodiment, management server is additionally operable to obtain backup host corresponding with the first standby node server Address；First spare link address is determined according to backup host address and virtual link address；First spare link address is anti- It is fed to the first standby node server；First spare link address is used to indicate access target database instance again.
In one embodiment, management server is additionally operable to be changed to run on the second spare section when target database example During point server, the second spare link address corresponding with entity link address is obtained；Second is fed back according to address mapping request Spare link address；Second spare link address is used to indicate source database example, is run on according to the access of spare link address Target database example on second standby node server.
In one embodiment, a kind of computer readable storage medium is provided, is deposited on the computer readable storage medium Computer program is contained, when which is executed by processor so that processor performs following steps：It is real to obtain database Example access request；Virtual link address is extracted from database instance access request；Virtual link address is visited with database instance It asks and the target database example accessed is asked to correspond to；Acquisition is connected with entity of the virtual link address there are mapping relations Address；Determine the type of database belonging to target database example；According to entity link address, by being matched with type of database Database plug-in unit access target database instance.
In one embodiment, entity link address, by by local host address and virtual link address, according to mesh What the corresponding mapping mode co-map of network environment residing for mark database instance obtained.
In one embodiment, when which is executed by processor, also so that processor performs following steps：When There is no during mapping relations corresponding with virtual link address, local host address is obtained；By local host address with virtually connecting Ground connection location is sent to management server；Receive the entity link address of management server feedback；The entity link address of feedback is Management server determines jointly according to local host address and virtual link address；Newly-built virtual link address is for feedback The mapping relations of entity link address.
In one embodiment, when which is executed by processor, also so that processor performs following steps：It obtains Requesting party corresponding with database instance access request is taken to identify.Local host address and virtual link address are sent to management Server, including：Requesting party is identified, local host address and virtual link address correspond to and be sent to management server；When please When the side's of asking mark has the access rights for virtual link address, the entity link address for receiving management server feedback is performed The step of.
In one embodiment, according to entity link address, accessed by database plug-in unit matched with type of database Target database example, including：According to entity link address, by with the matched database plug-in unit of type of database, access fortune Row is in the target database example on host node server.When the computer program is executed by processor, also so that processor is held Row following steps：When accessing the target database example failure run on host node server, then obtain and be connected with entity The corresponding spare link address in address；According to spare link address, by with the matched database plug-in unit of type of database, access Run on the target database example on standby node server.
In one embodiment, database instance access request intercepts to obtain by proxy plug-ins；Virtual link address leads to It crosses proxy plug-ins and is extracted from database instance access request and obtained.Obtain the entity there are mapping relations with virtual link address Link address, including：Network connection mapping table is inquired about by proxy plug-ins, obtains that there are mapping relations with virtual link address Entity link address.
In one embodiment, when which is executed by processor, also so that processor performs following steps：When When not inquiring in network connection mapping table mapping relations corresponding with virtual link address by proxy plug-ins, by this landlord Machine address is sent to management server with virtual link address；The entity that management server feedback is received by proxy plug-ins connects Address；The entity link address of feedback is that management server determines jointly according to local host address and virtual link address； By proxy plug-ins, virtual link address is created in network connection mapping table and is closed for the mapping of the entity link address of feedback System.
In one embodiment, when which is executed by processor, also so that processor performs following steps：It will Entity link address is recorded as the Connecting quantity corresponding to database instance access request；The Connecting quantity of record, for retaining Mapping relations corresponding with Connecting quantity in network connection mapping table；When end accesses the mesh run on standby node server When marking database instance, Connecting quantity is deleted.
In one embodiment, a kind of computer equipment is provided, including memory and processor, is stored in memory Computer program, when computer program is executed by processor so that processor performs following steps：Database instance is obtained to access Request；Virtual link address is extracted from database instance access request；Virtual link address and database instance access request The target database example accessed is asked to correspond to；Obtain the entity link address there are mapping relations with virtual link address； Determine the type of database belonging to target database example；According to entity link address, by with the matched number of type of database According to storehouse plug-in unit access target database instance.
In one embodiment, entity link address, by by local host address and virtual link address, according to mesh What the corresponding mapping mode co-map of network environment residing for mark database instance obtained.
In one embodiment, when which is executed by processor, also so that processor performs following steps：When There is no during mapping relations corresponding with virtual link address, local host address is obtained；By local host address with virtually connecting Ground connection location is sent to management server；Receive the entity link address of management server feedback；The entity link address of feedback is Management server determines jointly according to local host address and virtual link address；Newly-built virtual link address is for feedback The mapping relations of entity link address.
In one embodiment, when which is executed by processor, also so that processor performs following steps：It obtains Requesting party corresponding with database instance access request is taken to identify.Local host address and virtual link address are sent to management Server, including：Requesting party is identified, local host address and virtual link address correspond to and be sent to management server；When please When the side's of asking mark has the access rights for virtual link address, the entity link address for receiving management server feedback is performed The step of.
In one embodiment, according to entity link address, accessed by database plug-in unit matched with type of database Target database example, including：According to entity link address, by with the matched database plug-in unit of type of database, access fortune Row is in the target database example on host node server.When the computer program is executed by processor, also so that processor is held Row following steps：When accessing the target database example failure run on host node server, then obtain and be connected with entity The corresponding spare link address in address；According to spare link address, by with the matched database plug-in unit of type of database, access Run on the target database example on standby node server.
In one embodiment, database instance access request intercepts to obtain by proxy plug-ins；Virtual link address leads to It crosses proxy plug-ins and is extracted from database instance access request and obtained.Obtain the entity there are mapping relations with virtual link address Link address, including：Network connection mapping table is inquired about by proxy plug-ins, obtains that there are mapping relations with virtual link address Entity link address.
In one embodiment, when which is executed by processor, also so that processor performs following steps：When When not inquiring in network connection mapping table mapping relations corresponding with virtual link address by proxy plug-ins, by this landlord Machine address is sent to management server with virtual link address；The entity that management server feedback is received by proxy plug-ins connects Address；The entity link address of feedback is that management server determines jointly according to local host address and virtual link address； By proxy plug-ins, virtual link address is created in network connection mapping table and is closed for the mapping of the entity link address of feedback System.
In one embodiment, when which is executed by processor, also so that processor performs following steps：It will Entity link address is recorded as the Connecting quantity corresponding to database instance access request；The Connecting quantity of record, for retaining Mapping relations corresponding with Connecting quantity in network connection mapping table；When end accesses the mesh run on standby node server When marking database instance, Connecting quantity is deleted.
In one embodiment, a kind of computer readable storage medium is provided, is deposited on the computer readable storage medium Computer program is contained, when which is executed by processor so that processor performs following steps：With receiving source host Location and the corresponding address of cache request jointly of virtual link address；Source host address is corresponding with source database example；Virtual link Address is corresponding with target database example；It is entity link address by source host address and virtual link address co-map；Root Feedback entity link address is asked according to address of cache；Entity link address is used to indicate source database example and connects ground according to entity Location access target database instance.
In one embodiment, it is entity link address by source host address and virtual link address co-map, including： According to virtual link address, the network environment residing for target database example is determined；According to the side of mapping corresponding with network environment Source host address and virtual link address co-map are entity link address by formula.
In one embodiment, when which is executed by processor, also so that processor performs following steps：It obtains Requesting party corresponding with address of cache request is taken to identify；Verify access rights of requesting party's mark for virtual link address；When After access rights verification passes through, the step with virtual link address co-map for entity link address by source host address is performed Suddenly.
In one embodiment, source database example runs on the first host node server.The computer program is processed When device performs, also so that processor performs following steps：When source database example is changed to run on the first standby node service During device, the first standby node server access target database instance again is notified.
In one embodiment, the first standby node server access target database instance again is notified, including：It obtains Backup host address corresponding with the first standby node server；First is determined according to backup host address and virtual link address Spare link address；First spare link address is fed back into the first standby node server；First spare link address is used for Indicate access target database instance again.
In one embodiment, entity link address is used to indicate source database example, is accessed according to entity link address Run on the target database example on the second host node server.When the computer program is executed by processor, also so that place It manages device and performs following steps：When target database example is changed to run on the second standby node server, acquisition and entity The corresponding second spare link address of link address；Second spare link address is fed back according to address mapping request；Second is spare Link address is used to indicate source database example, is run on according to the access of spare link address on the second standby node server Target database example.
In one embodiment, when which is executed by processor, also so that processor performs following steps： In network connection mapping table, mapping relations of the virtual link address for entity link address are created；Scanning operation source database The Connecting quantity of the first node server record of example；For mapping relations corresponding with Connecting quantity in network connection mapping table Addition mark；The mapping relations that mark is not added in network connection mapping table are deleted.
In one embodiment, a kind of computer equipment is provided, including memory and processor, is stored in memory Computer program, when computer program is executed by processor so that processor performs following steps：Receive source host address and void Intend link address corresponding address of cache request jointly；Source host address is corresponding with source database example；Virtual link address with Target database example corresponds to；It is entity link address by source host address and virtual link address co-map；According to address Mapping request feedback entity link address；Entity link address is used to indicate source database example and is accessed according to entity link address Target database example.
In one embodiment, it is entity link address by source host address and virtual link address co-map, including： According to virtual link address, the network environment residing for target database example is determined；According to the side of mapping corresponding with network environment Source host address and virtual link address co-map are entity link address by formula.
In one embodiment, when which is executed by processor, also so that processor performs following steps：It obtains Requesting party corresponding with address of cache request is taken to identify；Verify access rights of requesting party's mark for virtual link address；When After access rights verification passes through, the step with virtual link address co-map for entity link address by source host address is performed Suddenly.
In one embodiment, source database example runs on the first host node server.The computer program is processed When device performs, also so that processor performs following steps：When source database example is changed to run on the first standby node service During device, the first standby node server access target database instance again is notified.
In one embodiment, the first standby node server access target database instance again is notified, including：It obtains Backup host address corresponding with the first standby node server；First is determined according to backup host address and virtual link address Spare link address；First spare link address is fed back into the first standby node server；First spare link address is used for Indicate access target database instance again.
In one embodiment, entity link address is used to indicate source database example, is accessed according to entity link address Run on the target database example on the second host node server.When the computer program is executed by processor, also so that place It manages device and performs following steps：When target database example is changed to run on the second standby node server, acquisition and entity The corresponding second spare link address of link address；Second spare link address is fed back according to address mapping request；Second is spare Link address is used to indicate source database example, is run on according to the access of spare link address on the second standby node server Target database example.
In one embodiment, when which is executed by processor, also so that processor performs following steps： In network connection mapping table, mapping relations of the virtual link address for entity link address are created；Scanning operation source database The Connecting quantity of the first node server record of example；For mapping relations corresponding with Connecting quantity in network connection mapping table Addition mark；The mapping relations that mark is not added in network connection mapping table are deleted.
One of ordinary skill in the art will appreciate that realizing all or part of flow in above-described embodiment method, being can be with Relevant hardware is instructed to complete by computer program, the program can be stored in a non-volatile computer and can be read In storage medium, the program is upon execution, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, it is provided herein Each embodiment used in any reference to memory, storage, database or other media, may each comprise non-volatile And/or volatile memory.Nonvolatile memory may include that read-only memory (ROM), programming ROM (PROM), electricity can be compiled Journey ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms, such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) directly RAM (RDRAM), straight Connect memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above example can be combined arbitrarily, to make description succinct, not to above-described embodiment In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance Shield is all considered to be the scope of this specification record.
Above example only expresses the several embodiments of the present invention, and description is more specific and detailed, but can not Therefore it is interpreted as the limitation to the scope of the claims of the present invention.It should be pointed out that for those of ordinary skill in the art, Without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to the protection model of the present invention It encloses.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.

Claims (20)

1. a kind of database instance access method, including：
Obtain database instance access request；
Virtual link address is extracted from the database instance access request；The virtual link address is real with the database Example access request asks the target database example accessed to correspond to；
Obtain the entity link address there are mapping relations with the virtual link address；
Determine the type of database belonging to the target database example；
According to the entity link address, the target data is accessed by database plug-in unit matched with the type of database Storehouse example.
2. according to the method described in claim 1, it is characterized in that, the entity link address, by by local host address With the virtual link address, according to the target database example residing for the corresponding mapping mode co-map of network environment It obtains.
3. according to the method described in claim 1, it is characterized in that, method further includes：
When there is no during mapping relations corresponding with the virtual link address, obtaining local host address；
The local host address and the virtual link address are sent to management server；
Receive the entity link address of the management server feedback；The entity link address of feedback is the management clothes It is engaged in what device determined jointly according to the local host address and the virtual link address；
Create mapping relations of the virtual link address for the entity link address of feedback.
4. according to the method described in claim 3, it is characterized in that, the method further includes：
Obtain requesting party's mark corresponding with the database instance access request；
It is described that the local host address and the virtual link address are sent to management server, including：
Requesting party mark, the local host address and the virtual link address are corresponded to and are sent to management server；
When the requesting party, which identifies, there are the access rights for the virtual link address, the reception management is performed The step of entity link address of server feedback.
5. according to the method described in claim 1, it is characterized in that, described according to the entity link address, by with it is described The matched database plug-in unit of type of database accesses the target database example, including：
According to the entity link address, by with the matched database plug-in unit of the type of database, access runs on main section The target database example on point server；
The method further includes：
When accessing the target database example failure run on host node server, then obtain and be connected with the entity The corresponding spare link address in address；
According to the spare link address, by with the matched database plug-in unit of the type of database, access runs on spare The target database example on node server.
6. the method according to any one of claims 1 to 5, it is characterized in that, the database instance access request is led to Proxy plug-ins are crossed to intercept to obtain；The virtual link address is by the proxy plug-ins from the database instance access request Extraction obtains；
The entity link address obtained with the virtual link address there are mapping relations, including：
Network connection mapping table is inquired about by the proxy plug-ins, obtains the reality there are mapping relations with the virtual link address Body link address.
7. according to the method described in claim 6, it is characterized in that, the method further includes：
It is corresponding with the virtual link address when not inquired in the network connection mapping table by the proxy plug-ins During mapping relations, local host address and the virtual link address are sent to management server；
The entity link address of the management server feedback is received by the proxy plug-ins；The entity connection ground of feedback Location is that the management server determines jointly according to the local host address and the virtual link address；
By the proxy plug-ins, the virtual link address is created in the network connection mapping table for described in feedback The mapping relations of entity link address.
8. according to the method described in claim 6, it is characterized in that, the method further includes：
The entity link address is recorded as the Connecting quantity corresponding to the database instance access request；What is recorded is described Connecting quantity, for retaining mapping relations corresponding with the Connecting quantity in the network connection mapping table；
When end, which accesses, runs on the target database example on standby node server, the Connecting quantity is deleted It removes.
9. a kind of database instance management method, including：
Receive the corresponding address of cache request jointly of source host address and virtual link address；The source host address and source data Storehouse example corresponds to；The virtual link address is corresponding with target database example；
It is entity link address by the source host address and virtual link address co-map；
The entity link address is fed back according to described address mapping request；The entity link address is used to indicate the source number The target database example is accessed according to the entity link address according to storehouse example.
It is 10. according to the method described in claim 9, it is characterized in that, described by the source host address and the virtual link Address co-map is entity link address, including：
According to the virtual link address, the network environment residing for the target database example is determined；
According to mapping mode corresponding with the network environment, the source host address and the virtual link address are reflected jointly It penetrates as entity link address.
11. according to the method described in claim 9, it is characterized in that, the method further includes：
Obtain requesting party's mark corresponding with described address mapping request；
Verify access rights of the requesting party's mark for the virtual link address；
After access rights verification passes through, execution is described to be by the source host address and virtual link address co-map The step of entity link address.
12. according to the method described in claim 9, it is characterized in that, the source database example runs on the first host node clothes Business device；
The method further includes：
When the source database example is changed to run on the first standby node server, first standby node is notified to take Business, which is thought highly of, newly accesses the target database example.
13. according to the method for claim 12, which is characterized in that described to notify the first standby node server again The target database example is accessed, including：
Obtain backup host address corresponding with the first standby node server；
First spare link address is determined according to the backup host address and the virtual link address；
Described first spare link address is fed back into the first standby node server；The first spare link address is used The target database example is accessed again in instruction.
14. according to the method described in claim 9, it is characterized in that, the entity link address is used to indicate the source data Storehouse example runs on the target database example on the second host node server according to entity link address access；
The method further includes：
When the target database example is changed to run on the second standby node server, obtains and be connected ground with the entity The corresponding second spare link address in location；
The second spare link address is fed back according to described address mapping request；The second spare link address is used to indicate The source database example runs on the target on the second standby node server according to the spare link address access Database instance.
15. according to the method described in claim 8, it is characterized in that, the method further includes：
In network connection mapping table, mapping relations of the virtual link address for the entity link address are created；
Scanning runs the Connecting quantity of the first node server record of the source database example；
For mapping relations addition mark corresponding with the Connecting quantity in the network connection mapping table；
The mapping relations that mark is not added in the network connection mapping table are deleted.
16. a kind of database instance access mechanism, including：
First acquisition module, for obtaining database instance access request；
Extraction module, for extracting virtual link address from the database instance access request；The virtual link address Ask the target database example accessed corresponding with the database instance access request；
Second acquisition module, for obtaining the entity link address with the virtual link address there are mapping relations；
Determining module, for determining the type of database belonging to the target database example；
Access modules, for according to the entity link address, being visited by database plug-in unit matched with the type of database Ask the target database example.
17. a kind of database instance managing device, including：
Receiving module, for receiving the corresponding address of cache request jointly of source host address and virtual link address；The source master Machine address is corresponding with source database example；The virtual link address is corresponding with target database example；
Mapping block, for being entity link address by the source host address and virtual link address co-map；
Feedback module, for feeding back the entity link address according to described address mapping request；The entity link address is used The target database example is accessed according to the entity link address in the instruction source database example.
18. a kind of database instance accesses system, including node server and management server, wherein：
The node server is used to obtain database instance access request；It is extracted from the database instance access request empty Intend link address；The target database example accessed is asked with the database instance access request in the virtual link address It is corresponding；
The node server is additionally operable to send source host address to the management server and virtual link address corresponds to jointly Address of cache request；The source host address is corresponding with source database example；The source database example runs on the section Point server；
The management server is used to be connected ground with virtual link address co-map for entity by the source host address Location；The entity link address is fed back to the node server according to described address mapping request；
The node server is additionally operable to determine the type of database belonging to the target database example；Connected according to the entity Location is grounded, the target database example is accessed by database plug-in unit matched with the type of database.
19. a kind of computer readable storage medium, computer program, the meter are stored on the computer readable storage medium When calculation machine program is executed by processor so that the processor performs the method as any one of claim 1 to 15 Step.
20. a kind of computer equipment including memory and processor, stores computer program, the meter in the memory When calculation machine program is performed by the processor so that the processor performs the side as any one of claim 1 to 15 The step of method.
CN201711294064.7A 2017-12-08 2017-12-08 Database instance access method, device, system, storage medium and equipment Active CN108093094B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711294064.7A CN108093094B (en) 2017-12-08 2017-12-08 Database instance access method, device, system, storage medium and equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201711294064.7A CN108093094B (en) 2017-12-08 2017-12-08 Database instance access method, device, system, storage medium and equipment

Publications (2)

Publication Number Publication Date
CN108093094A true CN108093094A (en) 2018-05-29
CN108093094B CN108093094B (en) 2021-05-28

Family

ID=62174809

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711294064.7A Active CN108093094B (en) 2017-12-08 2017-12-08 Database instance access method, device, system, storage medium and equipment

Country Status (1)

Country Link
CN (1) CN108093094B (en)

Cited By (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108846129A (en) * 2018-07-02 2018-11-20 腾讯科技（深圳）有限公司 Storing data access method, device and storage medium
CN109254876A (en) * 2018-09-11 2019-01-22 郑州云海信息技术有限公司 The management method and device of database in cloud computing system
CN109684399A (en) * 2018-12-24 2019-04-26 成都四方伟业软件股份有限公司 Data bank access method, database access device and Data Analysis Platform
CN109831521A (en) * 2019-03-11 2019-05-31 深圳市珍爱捷云信息技术有限公司 Cache instance management method, apparatus, computer equipment and storage medium
CN110086880A (en) * 2019-05-07 2019-08-02 北京字节跳动网络技术有限公司 The method and apparatus for creating the example of network request
CN110727499A (en) * 2019-09-18 2020-01-24 平安科技（深圳）有限公司 Resource data acquisition method and device, computer equipment and storage medium
CN110825795A (en) * 2019-09-18 2020-02-21 平安科技（深圳）有限公司 Method, device and equipment for accessing database and computer readable storage medium
CN111262907A (en) * 2020-01-08 2020-06-09 北京字节跳动网络技术有限公司 Service instance access method and device and electronic equipment
CN111367983A (en) * 2020-03-10 2020-07-03 中国联合网络通信集团有限公司 Database access method, system, device and storage medium
CN112187824A (en) * 2020-10-13 2021-01-05 北京计算机技术及应用研究所 SDN-based virtual network access method and device and SDN controller
CN112434094A (en) * 2020-11-24 2021-03-02 平安普惠企业管理有限公司 Database connection method and device based on encryption algorithm and computer equipment
CN113221180A (en) * 2021-06-09 2021-08-06 永旗(北京)科技有限公司 Database security access system and method
CN113259476A (en) * 2021-06-10 2021-08-13 深圳市腾讯信息技术有限公司 Message pushing method and system
CN113343275A (en) * 2021-06-30 2021-09-03 招商局金融科技有限公司 Data access method and data management service system
CN113452592A (en) * 2021-06-09 2021-09-28 北京奥星贝斯科技有限公司 Cross-cloud data access method and device under hybrid cloud architecture
CN113779603A (en) * 2021-09-13 2021-12-10 成都高新愿景数字科技有限公司 Asset authority control system and method based on 4A unified security management platform
CN114880698A (en) * 2019-06-29 2022-08-09 华为云计算技术有限公司 Database access method and apparatus, computing device and computer program product

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101042767A (en) * 2006-02-28 2007-09-26 国际商业机器公司 Web services database cluster structure and method thereof
US20140250228A1 (en) * 2000-03-23 2014-09-04 Dekel Shiloh Method and system for securing user identities and creating virtual users to enhance privacy on a communication network
CN105279233A (en) * 2015-09-23 2016-01-27 浙江宇视科技有限公司 Resource retrieving method and device
CN105335477A (en) * 2015-10-10 2016-02-17 北京京东尚科信息技术有限公司 Database operation method and device
CN106131233A (en) * 2016-06-20 2016-11-16 腾讯科技（深圳）有限公司 Realize method, Apparatus and system that data base's multipath accesses
CN106301829A (en) * 2015-05-21 2017-01-04 华为技术有限公司 A kind of method and apparatus of Network dilatation
CN107066522A (en) * 2017-02-20 2017-08-18 北京数字联盟网络科技有限公司 Database access method and device
CN107368365A (en) * 2017-07-25 2017-11-21 携程旅游信息技术（上海）有限公司 Cloud platform automatic O＆M method, system, equipment and storage medium

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140250228A1 (en) * 2000-03-23 2014-09-04 Dekel Shiloh Method and system for securing user identities and creating virtual users to enhance privacy on a communication network
CN101042767A (en) * 2006-02-28 2007-09-26 国际商业机器公司 Web services database cluster structure and method thereof
CN106301829A (en) * 2015-05-21 2017-01-04 华为技术有限公司 A kind of method and apparatus of Network dilatation
CN105279233A (en) * 2015-09-23 2016-01-27 浙江宇视科技有限公司 Resource retrieving method and device
CN105335477A (en) * 2015-10-10 2016-02-17 北京京东尚科信息技术有限公司 Database operation method and device
CN106131233A (en) * 2016-06-20 2016-11-16 腾讯科技（深圳）有限公司 Realize method, Apparatus and system that data base's multipath accesses
CN107066522A (en) * 2017-02-20 2017-08-18 北京数字联盟网络科技有限公司 Database access method and device
CN107368365A (en) * 2017-07-25 2017-11-21 携程旅游信息技术（上海）有限公司 Cloud platform automatic O＆M method, system, equipment and storage medium

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
朱薏 等: "数据库管理系统强制访问控制形式化分析与明证", 《小型微型计算机系统》 *
黄辉: "浅谈数据库设计与安全性策略", 《西部皮革》 *

Cited By (31)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108846129A (en) * 2018-07-02 2018-11-20 腾讯科技（深圳）有限公司 Storing data access method, device and storage medium
CN108846129B (en) * 2018-07-02 2023-04-18 腾讯科技（深圳）有限公司 Storage data access method, device and storage medium
CN109254876A (en) * 2018-09-11 2019-01-22 郑州云海信息技术有限公司 The management method and device of database in cloud computing system
CN109684399A (en) * 2018-12-24 2019-04-26 成都四方伟业软件股份有限公司 Data bank access method, database access device and Data Analysis Platform
CN109831521A (en) * 2019-03-11 2019-05-31 深圳市珍爱捷云信息技术有限公司 Cache instance management method, apparatus, computer equipment and storage medium
CN109831521B (en) * 2019-03-11 2021-08-31 深圳市珍爱捷云信息技术有限公司 Cache instance management method and device, computer equipment and storage medium
CN110086880A (en) * 2019-05-07 2019-08-02 北京字节跳动网络技术有限公司 The method and apparatus for creating the example of network request
CN110086880B (en) * 2019-05-07 2020-05-22 北京字节跳动网络技术有限公司 Method and apparatus for creating instances of network requests
CN114880698A (en) * 2019-06-29 2022-08-09 华为云计算技术有限公司 Database access method and apparatus, computing device and computer program product
CN114880698B (en) * 2019-06-29 2022-11-25 华为云计算技术有限公司 Database access method and apparatus, computing device and computer program product
CN110727499B (en) * 2019-09-18 2024-05-28 平安科技（深圳）有限公司 Method, device, computer equipment and storage medium for acquiring resource data
WO2021051880A1 (en) * 2019-09-18 2021-03-25 平安科技（深圳）有限公司 Resource data acquisition method and apparatus, computer device and storage medium
CN110825795B (en) * 2019-09-18 2023-10-13 平安科技（深圳）有限公司 Method, apparatus, device and computer readable storage medium for accessing database
CN110825795A (en) * 2019-09-18 2020-02-21 平安科技（深圳）有限公司 Method, device and equipment for accessing database and computer readable storage medium
CN110727499A (en) * 2019-09-18 2020-01-24 平安科技（深圳）有限公司 Resource data acquisition method and device, computer equipment and storage medium
CN111262907B (en) * 2020-01-08 2021-07-02 北京字节跳动网络技术有限公司 Service instance access method and device and electronic equipment
CN111262907A (en) * 2020-01-08 2020-06-09 北京字节跳动网络技术有限公司 Service instance access method and device and electronic equipment
CN111367983A (en) * 2020-03-10 2020-07-03 中国联合网络通信集团有限公司 Database access method, system, device and storage medium
CN111367983B (en) * 2020-03-10 2023-08-15 中国联合网络通信集团有限公司 Database access method, system, device and storage medium
CN112187824A (en) * 2020-10-13 2021-01-05 北京计算机技术及应用研究所 SDN-based virtual network access method and device and SDN controller
CN112187824B (en) * 2020-10-13 2022-11-22 北京计算机技术及应用研究所 SDN-based virtual network access method and device and SDN controller
CN112434094A (en) * 2020-11-24 2021-03-02 平安普惠企业管理有限公司 Database connection method and device based on encryption algorithm and computer equipment
CN112434094B (en) * 2020-11-24 2023-12-29 人和数智科技有限公司 Database connection method and device based on encryption algorithm and computer equipment
CN113221180A (en) * 2021-06-09 2021-08-06 永旗(北京)科技有限公司 Database security access system and method
CN113452592A (en) * 2021-06-09 2021-09-28 北京奥星贝斯科技有限公司 Cross-cloud data access method and device under hybrid cloud architecture
CN113221180B (en) * 2021-06-09 2024-08-02 佳乔(深圳)投资有限公司 Database security access system and method
CN113259476B (en) * 2021-06-10 2022-09-30 深圳市腾讯信息技术有限公司 Message pushing method and system
CN113259476A (en) * 2021-06-10 2021-08-13 深圳市腾讯信息技术有限公司 Message pushing method and system
CN113343275A (en) * 2021-06-30 2021-09-03 招商局金融科技有限公司 Data access method and data management service system
CN113343275B (en) * 2021-06-30 2024-03-19 招商局金融科技有限公司 Data access method and data management service system
CN113779603A (en) * 2021-09-13 2021-12-10 成都高新愿景数字科技有限公司 Asset authority control system and method based on 4A unified security management platform

Also Published As

Publication number Publication date
CN108093094B (en) 2021-05-28

Similar Documents

Publication Publication Date Title
CN108093094A (en) Database instance access method, device, system, storage medium and equipment
CN108829459B (en) Nginx server-based configuration method and device, computer equipment and storage medium
KR102379721B1 (en) System for controlling network access of application based on tcp session control and method therefor
CN102968719B (en) Paying server, terminal and payment channel cut-in method
CN109714239B (en) Management message issuing method, VNFM (virtual network management frequency) equipment and server
CN104040964B (en) Method, device and data center network across service area communication
CN105577496A (en) System of home gateway for identifying access device type via cloud platform
CN105095103B (en) For the storage device management method and apparatus under cloud environment
US20240259349A1 (en) Tunneling and gateway access system optimized for distributed gateway environment, and method related thereto
CN108959385A (en) Database portion arranging method, device, computer equipment and storage medium
CN110597541B (en) Interface updating processing method, device, equipment and storage medium based on block chain
CN106169994B (en) The method of controlling security and device communicated between container
CN110673941A (en) Migration method of micro-services in multiple computer rooms, electronic equipment and storage medium
CN110519127B (en) Network delay detection method, device and storage medium
CN106101055A (en) The data access method of a kind of multiple database and system thereof and proxy server
CN105263132B (en) The standby configuration file selection method and user terminal of eUICC
CN110493064A (en) Firewall management method, apparatus, computer equipment and storage medium
CN108111325A (en) A kind of resource allocation methods and device
CN106021566A (en) Method, device and system for improving concurrent processing capacity of single database
CN111064786B (en) Account identifier management method and device
CN106708573A (en) System and method used for automatic installation of Hadoop cluster
CN107517121B (en) Equipment configuration method and device
CN113535335B (en) Virtual resource allocation method and device based on block chain and electronic equipment
CN111324389A (en) Cloud platform network management method, device, equipment and storage medium
CN108810092A (en) Network Access Method and device, electronic equipment, computer readable storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant