CN110287165A - Data library device, database intermediate layer device and the method for running the database - Google Patents
Data library device, database intermediate layer device and the method for running the database Download PDFInfo
- Publication number
- CN110287165A CN110287165A CN201910383508.7A CN201910383508A CN110287165A CN 110287165 A CN110287165 A CN 110287165A CN 201910383508 A CN201910383508 A CN 201910383508A CN 110287165 A CN110287165 A CN 110287165A
- Authority
- CN
- China
- Prior art keywords
- database
- client
- data library
- user name
- address
- 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.)
- Pending
Links
Classifications
-
- 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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/213—Schema design and management with details for schema evolution support
Abstract
The present invention provides a kind of data library device, database intermediate layer device and the method for running the database, this method comprises: database intermediate layer device is sent to data library device after receiving the database access request of client, by the IP address of the client and user name；The data library device corresponds to the client, records IP address and user name.According to the technique and scheme of the present invention, real IP and user name that the client of access database is seen in face on the database are helped to realize.
Description
Technical field
The present invention relates to database technical field, particularly a kind of data library device, database intermediate layer device and
The method for running the database.
Background technique
Some databases (such as MySQL) often will build a middle layer in centre in usage mode, to facilitate management
The flow come in, play filtering, High Availabitity switching, across computer room, load balancing, read and write abruption the effects of, i.e., during client passes through
The case where interbed is connected to database, is directly connected to compared to client before with database, in addition after middle layer, client
End connection middle layer, the TCP/IP that the two is established is the IP of the IP and machine where middle layer of client, and middle layer and data
The connection that library is established is the TCP/IP that the IP of middle layer and the IP of database are established.
In the case where client and database are directly connected to, face can directly be seen that client is connected on the database
The IP and user name of database.Inventor has found in the implementation of the present invention, after plus middle layer, due to multiple visitors
What family end all connected is middle layer, and face can see the IP and user name of client that connection comes on the intermediate layer, but after arriving
The database at end here, just can only see the IP and user name of middle layer, all connections that face is seen on the database, all
Only one IP or identical IP, is exactly the IP of machine where middle layer, and user name is also identical, i.e. middle layer institute
In the user name of machine.
Summary of the invention
In view of this, the present invention provides a kind of data library device, database intermediate layer device and the side for running the database
Method realizes that the real IP and user name for accessing the client of database are seen in face on the database.
To achieve the above object, according to an aspect of the present invention, a kind of method in operation data library is provided.
The method in operation data library of the invention, comprising: database intermediate layer device is visited in the database for receiving client
After asking request, the IP address of the client and user name are sent to data library device；The data library device corresponds to institute
Client is stated, the IP address and user name are recorded.
Optionally, the database access request is TCP/IP request.
Optionally, the database is MySQL database.
According to another aspect of the present invention, a kind of database intermediate layer device is provided.
Database intermediate layer device of the invention, comprising: accept module, the database access for receiving client is asked
It asks；Sending module, for the IP address of the client and user name to be sent to data library device, for database dress
It sets and corresponds to the client, record the IP address and user name.
Optionally, the database access request is TCP/IP request.
Optionally, the database is MySQL database.
According to another aspect of the invention, a kind of data library device is provided.
Data library device of the invention, comprising: receiving module, the client that library intermediate layer device is sent for receiving data
IP address and user name；Logging modle records the IP address and user name for corresponding to the client.
Optionally, the data library device is arranged in the device of operation MySQL database.
Optionally, the logging modle includes the first bound cell and the second bound cell, in which: the first plug-in unit list
Member is for the IP address of the client to be recorded in the first variable；Second bound cell is used for the client
User name is recorded in the second variable.
According to the technique and scheme of the present invention, for each client of access database, IP address and user name are mentioned
Database is supplied, database is made also to be able to know that the real IP address and user name of client there are middle layer.
Detailed description of the invention
Attached drawing for a better understanding of the present invention, does not constitute an undue limitation on the present invention.Wherein:
Fig. 1 is the connection schematic diagram of client, middle layer and database according to prior art；
Fig. 2 is the schematic diagram of the key step of the method in operation data library of the invention；
Fig. 3 is the schematic diagram of the main modular of database intermediate layer device of the invention；
Fig. 4 is the schematic diagram of the main modular of data library device of the invention.
Specific embodiment
Below with reference to attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that institute
The embodiment of description is only a part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention,
Every other embodiment obtained by those of ordinary skill in the art without making creative efforts, belongs to this hair
The range of bright protection.
Fig. 1 is the connection schematic diagram of client, middle layer and database according to prior art, as shown in Figure 1, middle layer
2 build between multiple client (showing the 1st in figure to n-th client) and database 3, i.e. client 1 to client
1N is connected to middle layer 2 simultaneously, and middle layer 2 is connected to database 3, with the flow for facilitating management to come in, plays filtering, High Availabitity
Switching, the effects of across computer room, load balancing, read and write abruption.
Fig. 2 is the schematic diagram of the key step of the method in the operation data library in technical solution of the present invention.Wherein, data
Library intermediate layer device is arranged in middle layer 2, and data library device is arranged in database 3.This method comprises:
Step S1: database intermediate layer device is after receiving the database access request of client, by the IP of client
Location and user name are sent to data library device 20；
Step S2: data library device 20 corresponds to client, records the IP address and user name.
Wherein, database access request can be TCP/IP request, and database can be MySQL database.
Fig. 3 is the schematic diagram of the main modular of the database intermediate layer device 10 in technical solution of the present invention, the data
Library intermediate layer device 10 includes: to accept module 11, for receiving the database access request of client；Sending module 12, is used for
The IP address of client and user name are sent to data library device 20, so that data library device 20 corresponds to client, record
The IP address and user name.
Wherein, database access request can be TCP/IP request, and database can be MySQL database.
Fig. 4 is the schematic diagram of the main modular of the data library device 20 in technical solution of the present invention, the data library device
20 include: receiving module 21, the IP address and user name of the client that library intermediate layer device 10 is sent for receiving data；Record
Module 22 records IP address and user name for corresponding to client.
Wherein, data library device 20, which can be, is arranged in the device of operation MySQL database, and logging modle 22 includes the
One bound cell 221 and the second bound cell 222, the first bound cell 221 are used to the IP address of client being recorded in first
In variable；Second bound cell 222 is for the user name of client to be recorded in the second variable.
Technical solution according to an embodiment of the present invention, for accessing each client of database, IP address and user
Name is provided to database, and database is made also to be able to know that the real IP address and use of client there are middle layer
Name in an account book.
Above-mentioned specific embodiment, does not constitute a limitation on the scope of protection of the present invention.Those skilled in the art should be bright
It is white, design requirement and other factors are depended on, various modifications, combination, sub-portfolio and substitution can occur.It is any
Made modifications, equivalent substitutions and improvements etc. within the spirit and principles in the present invention, should be included in the scope of the present invention
Within.
Claims (9)
1. a kind of method in operation data library characterized by comprising
Database intermediate layer device is after receiving the database access request of client, by the IP address of the client and user
Name is sent to data library device；
The data library device corresponds to the client, records the IP address and user name.
2. the method according to claim 1, wherein the database access request is TCP/IP request.
3. method according to claim 1 or 2, which is characterized in that the database is MySQL database.
4. a kind of database intermediate layer device characterized by comprising
Module is accepted, for receiving the database access request of client；
Sending module, for the IP address of the client and user name to be sent to data library device, for the database
Device corresponds to the client, records the IP address and user name.
5. database intermediate layer device according to claim 4, which is characterized in that the database access request is TCP/
IP request.
6. database intermediate layer device according to claim 4 or 5, which is characterized in that the database is MySQL data
Library.
7. a kind of data library device characterized by comprising
Receiving module, the IP address and user name of the client that library intermediate layer device is sent for receiving data；
Logging modle records the IP address and user name for corresponding to the client.
8. data library device according to claim 7, which is characterized in that the data library device setting is in operation MySQL
In the device of database.
9. data library device according to claim 7 or 8, which is characterized in that the logging modle includes the first plug-in unit list
Member and the second bound cell, in which:
First bound cell is for the IP address of the client to be recorded in the first variable；
Second bound cell is for the user name of the client to be recorded in the second variable.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910383508.7A CN110287165A (en) | 2019-05-09 | 2019-05-09 | Data library device, database intermediate layer device and the method for running the database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910383508.7A CN110287165A (en) | 2019-05-09 | 2019-05-09 | Data library device, database intermediate layer device and the method for running the database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110287165A true CN110287165A (en) | 2019-09-27 |
Family
ID=68001705
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910383508.7A Pending CN110287165A (en) | 2019-05-09 | 2019-05-09 | Data library device, database intermediate layer device and the method for running the database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110287165A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101374047A (en) * | 2007-08-21 | 2009-02-25 | Nhn公司 | User authentication system using IP address and method thereof |
| US20150112948A1 (en) * | 2013-10-18 | 2015-04-23 | New York Air Brake Corporation | Dynamically scalable distributed heterogenous platform relational database |
| CN106293887A (en) * | 2015-05-21 | 2017-01-04 | 中兴通讯股份有限公司 | Data base processing method and device |
| CN106815250A (en) * | 2015-12-01 | 2017-06-09 | 招商局国际信息技术有限公司 | A kind of method for sending data, data server and server |
-
2019
- 2019-05-09 CN CN201910383508.7A patent/CN110287165A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101374047A (en) * | 2007-08-21 | 2009-02-25 | Nhn公司 | User authentication system using IP address and method thereof |
| US20150112948A1 (en) * | 2013-10-18 | 2015-04-23 | New York Air Brake Corporation | Dynamically scalable distributed heterogenous platform relational database |
| CN106293887A (en) * | 2015-05-21 | 2017-01-04 | 中兴通讯股份有限公司 | Data base processing method and device |
| CN106815250A (en) * | 2015-12-01 | 2017-06-09 | 招商局国际信息技术有限公司 | A kind of method for sending data, data server and server |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7350052B2 (en) | Network system and method for setting volume group in the network system | |
| DE112011100822B4 (en) | Maintaining the transmission of a data transmission path in a data storage network | |
| US7925002B2 (en) | Administering multiple target ACD systems | |
| DE112013002542T5 (en) | Cloud-based application resource files | |
| JP4912996B2 (en) | Information processing apparatus and computer system | |
| CN109408523A (en) | Data sharing method, device, data sharing platform, electronic equipment | |
| CN110032886A (en) | The method and apparatus of access authorization for resource management | |
| US20150381747A1 (en) | Global provisioning of millions of users with deployment units | |
| CN106789168A (en) | A kind of data center server manages the dispositions method and frame top formula interchanger of network | |
| CN109271358A (en) | Data summarization method, querying method, device, equipment and storage medium | |
| CN107733882A (en) | SSL certificate automatically dispose method and apparatus | |
| CN105208560A (en) | WiFi certification-free log-in method, device and system | |
| CN111475104A (en) | Storage device data online migration method, system, terminal and storage medium | |
| CN110399309A (en) | A kind of test data generating method and device | |
| CN110851318A (en) | Serial port log collection method, system and equipment under server management system | |
| CN107172061A (en) | It is a kind of to realize shared method and system | |
| CN110287165A (en) | Data library device, database intermediate layer device and the method for running the database | |
| CN109274784A (en) | IP and MAC Address binding method, device, terminal and storage medium based on openstack | |
| CN105978744A (en) | Resource allocation method, device and system | |
| CN115333863B (en) | Internet of things system building method based on dynamic domain name service and related equipment | |
| CN105069719A (en) | Lawyer mandating system and method based on wireless network | |
| CN115640457A (en) | Information management method, apparatus, device, medium, and program product | |
| CN114760134A (en) | Multi-tenant isolation method and related device | |
| CN106201860B (en) | The test method and device of application system | |
| CN103236954A (en) | Web service evaluation system in mobile network |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190927 |