CN108093094A - Database instance access method, device, system, storage medium and equipment - Google Patents
Database instance access method, device, system, storage medium and equipment Download PDFInfo
- 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
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
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.
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)
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)
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 |
-
2017
- 2017-12-08 CN CN201711294064.7A patent/CN108093094B/en active Active
Patent Citations (8)
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)
Title |
---|
朱薏 等: "数据库管理系统强制访问控制形式化分析与明证", 《小型微型计算机系统》 * |
黄辉: "浅谈数据库设计与安全性策略", 《西部皮革》 * |
Cited By (31)
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 |