CN113032487A - Database access system, method, electronic device and medium - Google Patents
Database access system, method, electronic device and medium Download PDFInfo
- Publication number
- CN113032487A CN113032487A CN202110301864.7A CN202110301864A CN113032487A CN 113032487 A CN113032487 A CN 113032487A CN 202110301864 A CN202110301864 A CN 202110301864A CN 113032487 A CN113032487 A CN 113032487A
- Authority
- CN
- China
- Prior art keywords
- database
- access point
- database access
- point server
- access request
- 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
- 238000000034 method Methods 0.000 title claims abstract description 45
- 230000002159 abnormal effect Effects 0.000 claims description 19
- 238000012544 monitoring process Methods 0.000 claims description 11
- 238000011084 recovery Methods 0.000 claims description 5
- 238000004590 computer program Methods 0.000 claims description 3
- 230000001360 synchronised effect Effects 0.000 claims description 2
- 238000005192 partition Methods 0.000 abstract description 9
- 241000700605 Viruses Species 0.000 abstract description 6
- 238000010586 diagram Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 6
- 238000012545 processing Methods 0.000 description 5
- 238000001514 detection method Methods 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 3
- 239000000284 extract Substances 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
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/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)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention discloses a database access system, a database access method, electronic equipment and a storage medium, which relate to the technical field of big data and comprise the following steps: the receiving server is used for receiving the database access request input by the user and sending the database access request to the repeater; the repeater is used for sending the acquired database access request to the data access point server; and the data access point server is used for selecting the specified application service according to the service name contained in the database access request and sending the database access request to the database cluster based on the specified application service so as to access the database cluster. Each data access point server is used as a small cluster unit containing multiple services to independently realize the access of a database cluster, and the network partition does not influence the normal work of other access points in the system even if one access point server is infected by viruses, so that the safe and stable operation of the database access system is ensured when the database access is carried out under the condition that nodes are not communicated.
Description
Technical Field
The embodiment of the invention relates to the technical field of big data, in particular to a database access system, a database access method, electronic equipment and a medium.
Background
At present, when a database is accessed, a cluster system including multiple nodes is usually adopted, networks among all nodes in the cluster system are communicated, each node can register service resources of all nodes in the cluster system, and when any node in the cluster system receives a database access request, the access request can be sent to an access node with sufficient service resources according to registration information, and the access request is sent to the database through the access node.
However, the database access system can only adapt to the access of a multi-node connected database, when the nodes are isolated due to a fault in a network and cannot communicate with each other, the database access fails, and when one node is infected by a virus, other nodes connected to the network can be quickly infected, so that the safe and stable operation of the database access system cannot be guaranteed.
Disclosure of Invention
The embodiment of the invention provides a database access system, a database access method, electronic equipment and a storage medium, which are used for ensuring the safe and stable operation of the database access system when a database is accessed under the condition that nodes are not communicated.
In a first aspect, an embodiment of the present invention provides a database access system, including: the repeater comprises a receiving server and at least two data access point servers which are respectively connected with each repeater, wherein each data access point server is isolated from each other through a network;
the receiving server is used for receiving the database access request input by the user and sending the database access request to the repeater;
the repeater is used for sending the acquired database access request to the data access point server;
and the data access point server is used for selecting the specified application service according to the service name contained in the database access request and sending the database access request to the database cluster based on the specified application service so as to access the database cluster.
In a second aspect, an embodiment of the present invention provides a database access method, which is applied to a database access system, and includes: receiving a database access request input by a user through a receiving server, and sending the database access request to a repeater;
sending the acquired database access request to a data access point server through a repeater;
and selecting the specified application service according to the service name contained in the database access request through the data access point server, and sending the database access request to the database cluster based on the specified application service so as to access the database cluster.
In a third aspect, an embodiment of the present invention further provides an electronic device, where the electronic device includes:
one or more processors;
storage means for storing one or more programs;
when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the methods of any of the embodiments of the present invention.
In a fourth aspect, the embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, implements the method according to any embodiment of the present invention.
In the embodiment of the invention, the data access point server comprising the receiving server, the repeater and the plurality of network partitions is deployed in the database access system, each data access point server is taken as a small cluster unit comprising a plurality of services, the access of the database cluster can be independently realized, and the normal work of other access points in the system can not be influenced even if one access point server is infected by virus due to the network partitions, so that the safe and stable operation of the database access system is ensured when the database access is carried out under the condition that nodes are not communicated.
Drawings
FIG. 1 is a schematic structural diagram of a database access system according to an embodiment of the present invention;
FIG. 2 is a schematic structural diagram of a database access system according to a second embodiment of the present invention;
FIG. 3 is a flowchart of a database access method provided by a third embodiment of the present invention;
fig. 4 is a block diagram of an electronic device according to a fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a schematic structural diagram of a database access system according to an embodiment of the present invention, where the embodiment may be applied to implement access to a database cluster in a multi-node non-cluster scenario.
Wherein, the database access system includes: the repeater 12, the receiving server 11 and at least two data access point servers 13 connected with each repeater 12 respectively, wherein, each data access point server 13 is isolated by the network; the receiving server 11 is used for receiving a database access request input by a user and sending the database access request to the repeater; the repeater 12 is used for sending the acquired database access request to the data access point server; and the data access point server 13 is configured to select a specified application service according to the service name included in the database access request, and send the database access request to the database cluster based on the specified application service, so as to access the database cluster. As shown in fig. 1, in the present embodiment, it is described by taking an example that the number of the repeaters and the number of the data access point servers are three, respectively, but in practical applications, it is within the scope of the present application that the number of the repeaters and the number of the data access point servers are greater than two.
Optionally, the receiving server is configured to averagely send the database access request to the repeater; and the repeater is used for averagely sending the acquired database access requests to the data access point server.
Specifically, in the embodiment, the receiving server receives the database access request input by the user, and the database access request is specifically transmitted in a flow form, in order to relieve the forwarding pressure of the repeater and the processing pressure of each data access point server, the receiving server sends the acquired database access request to the repeater on average, and at the same time, the repeater also sends the acquired database access request to the data access point server connected to the repeater on average.
Optionally, the data access point server includes: a gateway service, two registration services and at least two application services; the data access point server is further configured to perform synchronous registration of the resource information of the gateway service and the at least two application services in the two registration services.
Optionally, each application service includes at least two microservice service blocks.
Specifically, in this embodiment, each data access point server may include a plurality of application services, each application service includes at least two microservice service blocks, and each microservice service block may correspond to a plurality of functions, so that each data access point server may be regarded as a unit cluster. And the forwarding function is realized in the data access point server through gateway service, and the forwarder jumps to the application service and only corresponds to one port.
The data access point server, which is a unit cluster, first registers resource information of a plurality of application services included in the data access point server with a registration service before processing a database access request. For example, as shown in table 1, the data access point server 1 includes four application services, the registration service 1 registers the resource information of the gateway service and the four application services, and the registration service 1 synchronizes the registration content with the registration service 2. Since the registration information in registration service 1 and registration service 2 is the same, even when one registration service fails, the normal operation of the system is not affected, as indicated by the dashed line in fig. 1 indicating the registration process. And when the application service changes the resource information subsequently, the registration service 1 and the registration service 2 synchronously update the registration information.
The data access point server transmits the database access request to the registration service 1 through the gateway server after completing registration through the registration service, the registration service 1 extracts a service name from the database access request, selects a specified application service required to be used by the database access request according to the server, selects a specified application service corresponding to a micro-service block with sufficient resources from the four contained application services according to the registration information, and sends the database access request to the database cluster by adopting the resources of the specified application service, wherein the indicated solid lines in fig. 1 indicate a service request route.
Optionally, the data access point server is configured to perform total traffic control and access frequency control of the same user on the database access request based on the gateway service.
Optionally, the data access point server is configured to receive the database access request when it is determined that the total access traffic in unit time does not exceed the first preset threshold based on the token bucket algorithm.
Optionally, the data access point server is configured to determine, based on a token bucket algorithm, that the number of times of access by the specified user in the unit time does not exceed a second preset threshold, and receive the database access request when the database access request is sent by the specified user.
Specifically, in order to prevent a large number of requests from overloading the server, which results in unavailable services, or avoid network malicious attacks, in the embodiment, the data access point server performs total traffic control and the same user access time control on the database access requests based on the gateway service. For example, for total traffic control, it may be required to receive only access requests of 600qps traffic per second, for example, when the gateway service in the data access point server 1 determines, based on the token bucket algorithm, that the total traffic corresponding to all received requests within one second has reached 600qps, even if the repeater 1 has sent a new database access request to the data node server 1, the gateway service directly rejects the transmitted database access request, that is, does not allocate resources of the application service to the database access request, so that it can effectively prevent a large number of requests from entering and causing server overload. For the same user access frequency control, it may be required that the specified user access frequency cannot exceed 10 times per second, for example, when the gateway service in the data access point server 1 determines, based on the token bucket algorithm, that an access request sent by a user whose IP is 001 in one second is already 10 times, even if the repeater 1 has sent a new database access request of a user whose IP is 001 to the data node server 1, the gateway service directly rejects the database access request corresponding to the transmitted user whose IP is 001, that is, resources of the application service are not allocated to the database access request, so that an attack of a malicious user on the system can be effectively avoided.
In the embodiment of the invention, the data access point server comprising the receiving server, the repeater and the plurality of network partitions is deployed in the database access system, each data access point server is taken as a small cluster unit comprising a plurality of services, the access of the database cluster can be independently realized, and the normal work of other access points in the system can not be influenced because the network partitions and one access point server are infected by viruses, so that the safe and stable operation of the database access system is ensured when the database access is carried out under the condition that the nodes are not communicated.
Example two
Fig. 2 is a schematic structural diagram of a database access system according to a second embodiment of the present invention, and in this embodiment, an application process monitoring server 13 is further added on the basis of the first embodiment.
Wherein, the application process monitoring server 13 is connected with each data access point server; the application process monitoring server is used for acquiring the state information of the application service contained in each data access point server; and determining that the application service is abnormal according to the state information, and indicating the abnormal application service to perform self-recovery when the data access point server where the abnormal application service is positioned is not down.
Specifically, in the embodiment, by adding the application process detection server, the application process of each data access point server in the database access system can be monitored in real time. On one hand, the state information of the application service contained in each access point server can be obtained through real-time monitoring, so that system maintenance personnel can obtain the current running state of the database access system in real time; on the other hand, when the application service is determined to be abnormal according to the state information, but the data access point server where the abnormal application service is located is not down, the abnormal application service is indicated to be self-recovered, so that the normal work of the system can be quickly recovered.
In the embodiment of the invention, the data access point server comprising the receiving server, the repeater and the plurality of network partitions is deployed in the database access system, each data access point server is taken as a small cluster unit comprising a plurality of services, the access of the database cluster can be independently realized, and the normal work of other access points in the system can not be influenced because the network partitions and one access point server are infected by viruses, so that the safe and stable operation of the database access system is ensured when the database access is carried out under the condition that the nodes are not communicated. And the application process detection server is used for carrying out process detection on the application service of the database access system, so that maintenance personnel can know the running state of the application service in real time, and self-recovery of the application service is realized under the condition that the application service is abnormal but the data access point server is not down, so that the safety of the system is further improved.
EXAMPLE III
Fig. 3 is a flowchart of a database access method provided in the third embodiment of the present invention, where this embodiment may be applied to implement access to a database cluster in a multi-node non-cluster scenario, and the method in the third embodiment of the present invention specifically includes the following steps:
and step S101, receiving a database access request input by a user through a receiving server, and sending the database access request to a repeater.
Specifically, the receiving server receives a database access request input by a user, and the database access request is transmitted in a flow form. In this embodiment, the number of the repeaters connected to the receiving server may be at least two, and in order to relieve the forwarding pressure of the repeaters, the receiving server may send the acquired database access request to the repeaters on average downward.
And step S102, sending the acquired database access request to a data access point server through a repeater.
In this embodiment, the number of the data access point servers is at least two, and each data access point server is isolated from the other data access point servers. Each data access point server includes: a gateway service, two registration services and at least two application services; before sending the obtained database access request to the data access point server through the repeater, the method further includes: and synchronously registering the resource information of the gateway service and at least two application services in the two registration services.
Specifically, in this embodiment, each data access point server may include a plurality of application services, each application service includes at least two microservice service blocks, and each microservice service block may correspond to a plurality of functions, so that each data access point server may be regarded as a unit cluster. And the forwarding function is realized in the data access point server through gateway service, and the forwarder jumps to the application service and only corresponds to one port.
The data access point server, which is a unit cluster, first registers resource information of a plurality of application services included in the data access point server with a registration service before processing a database access request. For example, as shown in table 1, the data access point server 1 includes four application services, the registration service 1 registers the resource information of the gateway service and the four application services, and the registration service 1 synchronizes the registration content with the registration service 2. Since the registration information in registration service 1 and registration service 2 is the same, even when one registration service fails, the normal operation of the system is not affected, as indicated by the dashed line in fig. 1 indicating the registration process. And when the application service changes the resource information subsequently, the registration service 1 and the registration service 2 synchronously update the registration information.
And step S103, selecting a specified application service according to the service name contained in the database access request through the data access point server, and sending the database access request to the database cluster based on the specified application service so as to access the database cluster.
The data access point server transmits the database access request to the registration service 1 through the gateway server after completing registration through the registration service, the registration service 1 extracts a service name from the database access request, selects a specified application service required to be used by the database access request according to the server, selects a specified application service corresponding to a micro service block with sufficient resources from the four contained application services according to the registration information, and sends the database access request to the database cluster based on the specified application service.
Optionally, before selecting the specified application service according to the service name included in the database access request by the data access point server, the method further includes: and the data access point server performs total traffic control and same user access frequency control on the database access requests based on the gateway service.
Optionally, the data access point server performs total traffic control and the same user access frequency control on the database access request based on the gateway service, including: receiving a database access request when determining that the total access flow in unit time does not exceed a first preset threshold value based on a token bucket algorithm; and when the access times of the appointed user in unit time do not exceed the second preset threshold value and the database access request is sent out by the appointed user based on the token bucket algorithm, receiving the database access request.
Specifically, in order to prevent a large number of requests from overloading the server, which results in unavailable services, or avoid network malicious attacks, in the embodiment, the data access point server performs total traffic control and the same user access time control on the database access requests based on the gateway service. For example, for total traffic control, it may be required to receive only access requests of 600qps traffic per second, for example, when the gateway service in the data access point server 1 determines, based on the token bucket algorithm, that the total traffic corresponding to all received requests within one second has reached 600qps, even if the repeater 1 has sent a new database access request to the data node server 1, the gateway service directly rejects the transmitted database access request, that is, does not allocate resources of the application service thereto, so that it can effectively prevent a large number of requests from overloading the server. For the same user access frequency control, it may be required that the specified user access frequency cannot exceed 10 times per second, for example, when the gateway service in the data access point server 1 determines, based on the token bucket algorithm, that an access request sent by a user whose IP is 001 in one second is already 10 times, even if the repeater 1 has sent a new database access request of a user whose IP is 001 to the data node server 1, the gateway service directly rejects the database access request corresponding to the transmitted user whose IP is 001, that is, resources of the application service are not allocated to the database access request, so that an attack of a malicious user on the system can be effectively avoided.
Optionally, the system further includes an application process monitoring server, and the application process monitoring server acquires state information of the application service included in each access point server; and determining that the application service is abnormal according to the state information, and indicating the abnormal application service to perform self-recovery when the access point server where the abnormal application service is positioned is not down.
In this embodiment, the application process detection server can monitor the application process of each data access point server in the database access system in real time. On one hand, the state information of the application service contained in each access point server can be obtained through real-time monitoring, so that maintenance personnel can obtain the current running state of the database access system in real time; on the other hand, when the application service is determined to be abnormal according to the state information, but the data access point server where the abnormal application service is located is not down, the abnormal application service is indicated to be self-recovered, so that the normal work of the system can be quickly recovered.
In the embodiment of the invention, the data access point server comprising the receiving server, the repeater and a plurality of network partitions is deployed in the database access system, each data access point server is taken as a small cluster unit comprising a plurality of services, the access of the database cluster can be independently realized, and the network partitions can not influence the normal work of other access points in the system even if one access point server is infected by viruses, so that the safe and stable operation of the database access system is ensured when the database access is carried out under the condition that nodes are not communicated.
Example four
Fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention. FIG. 4 illustrates a block diagram of an exemplary electronic device 412 suitable for use in implementing embodiments of the present invention. The electronic device 412 shown in fig. 4 is only an example and should not bring any limitations to the functionality and scope of use of the embodiments of the present invention.
As shown in fig. 4, the electronic device 412 is in the form of a general purpose computing device. The components of the electronic device 412 may include, but are not limited to: one or more processors 416, a memory 428, and a bus 418 that couples the various system components (including the memory 428 and the processors 416).
The memory 428 is used to store instructions. Memory 428 can include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM)430 and/or cache memory 432. The electronic device 412 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 434 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 4, commonly referred to as a "hard drive"). Although not shown in FIG. 4, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 418 by one or more data media interfaces. Memory 428 can include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 440 having a set (at least one) of program modules 442 may be stored, for instance, in memory 428, such program modules 442 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. The program modules 442 generally perform the functions and/or methodologies of the described embodiments of the invention.
The electronic device 412 may also communicate with one or more external devices 414 (e.g., keyboard, pointing device, display 424, etc.), with one or more devices that enable a user to interact with the electronic device 412, and/or with any devices (e.g., network card, modem, etc.) that enable the electronic device 412 to communicate with one or more other computing devices. Such communication may occur via input/output (I/O) interfaces 422. Also, the electronic device 412 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the internet) through the network adapter 420. As shown, network adapter 420 communicates with the other modules of electronic device 412 over bus 418. It should be appreciated that although not shown in FIG. 4, other hardware and/or software modules may be used in conjunction with the electronic device 412, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.
The processor 416 performs various functional applications and data processing by executing instructions stored in the memory 428, such as performing the following:
receiving a database access request input by a user through a receiving server, and sending the database access request to a repeater; sending the acquired database access request to a data access point server through a repeater; and selecting the specified application service according to the service name contained in the database access request through the data access point server, and sending the database access request to the database cluster based on the specified application service so as to access the database cluster.
EXAMPLE five
An embodiment of the present invention further provides a storage medium containing computer-executable instructions, where the computer-executable instructions are executed by a computer processor to perform a database access method, and the method includes:
receiving a database access request input by a user through a receiving server, and sending the database access request to a repeater; sending the acquired database access request to a data access point server through a repeater; and selecting the specified application service according to the service name contained in the database access request through the data access point server, and sending the database access request to the database cluster based on the specified application service so as to access the database cluster.
Of course, the storage medium provided by the embodiment of the present invention contains computer-executable instructions, and the computer-executable instructions are not limited to the operations of the method described above, and may also perform related operations in the database access method provided by any embodiment of the present invention.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling an electronic device (which may be a personal computer, a server, or a network device) to execute the database Access method according to the embodiments of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (15)
1. A database access system, comprising: the repeater comprises a receiving server and at least two data access point servers which are respectively connected with each repeater, wherein each data access point server is isolated from each other through a network;
the receiving server is used for receiving a database access request input by a user and sending the database access request to the transponder;
the repeater is used for sending the acquired database access request to the data access point server;
and the data access point server is used for selecting a specified application service according to the service name contained in the database access request and sending the database access request to the database cluster based on the specified application service so as to access the database cluster.
2. The system of claim 1, wherein the data access point server comprises: a gateway service, two registration services and at least two application services;
the data access point server is further configured to perform synchronous registration on the resource information of the gateway service and the at least two application services in two registration services.
3. The system of claim 2, wherein each of the application services includes at least two microservice service blocks therein.
4. The system of claim 2, wherein the data access point server is configured to perform total traffic control and same user access number control on the database access requests based on the gateway service.
5. The system of claim 4, wherein the data access point server is configured to receive the database access request when it is determined that the total access traffic per unit time does not exceed a first preset threshold based on a token bucket algorithm.
6. The system of claim 4, wherein the data access point server is configured to receive the database access request when determining that the number of accesses of a given user per unit time does not exceed a second preset threshold based on a token bucket algorithm and the database access request is issued by the given user.
7. The system of claim 2, further comprising an application process monitoring server, said application process monitoring server being connected to each of said data access point servers;
the application process monitoring server is used for acquiring the state information of the application service contained in each data access point server;
and determining that the application service is abnormal according to the state information, and indicating the abnormal application service to perform self-recovery when the data access point server where the abnormal application service is positioned is not down.
8. The system of claim 1, wherein the receiving server is configured to send the database access request to the forwarder on average;
and the repeater is used for averagely sending the acquired database access requests to the data access point server.
9. A database access method is applied to a database access system and is characterized by comprising the following steps:
receiving a database access request input by a user through a receiving server, and sending the database access request to a repeater;
sending the acquired database access request to the data access point server through a repeater;
and selecting a specified application service according to the service name contained in the database access request through the data access point server, and sending the database access request to the database cluster based on the specified application service so as to access the database cluster.
10. The method of claim 9, wherein before the selecting the specific application service according to the service name included in the database access request by the data access point server, the method further comprises:
and the data access point server performs total traffic control and same user access frequency control on the database access request based on gateway service.
11. The method of claim 10, wherein the data access point server performs total traffic control and same user access number control on the database access requests based on a gateway service, comprising:
receiving the database access request when determining that the total access flow in unit time does not exceed a first preset threshold value based on a token bucket algorithm;
and when determining that the access times of the appointed user in unit time do not exceed a second preset threshold value based on a token bucket algorithm and the database access request is sent by the appointed user, receiving the database access request.
12. The method of claim 9, further comprising:
acquiring state information of application services contained in each access point server through an application process monitoring server;
and determining that the application service is abnormal according to the state information, and indicating the abnormal application service to perform self-recovery when the access point server where the abnormal application service is positioned is not down.
13. The method according to any of claims 9 to 12, wherein the data access point server comprises: a gateway service, two registration services and at least two application services;
before the sending, by the forwarder, the obtained database access request to the data access point server, the method further includes:
and synchronously registering the resource information of the gateway service and at least two application services in two registration services.
14. An electronic device, characterized in that the device comprises:
one or more processors;
storage means for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 9-13.
15. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 9-13.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110301864.7A CN113032487A (en) | 2021-03-22 | 2021-03-22 | Database access system, method, electronic device and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110301864.7A CN113032487A (en) | 2021-03-22 | 2021-03-22 | Database access system, method, electronic device and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113032487A true CN113032487A (en) | 2021-06-25 |
Family
ID=76472216
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110301864.7A Pending CN113032487A (en) | 2021-03-22 | 2021-03-22 | Database access system, method, electronic device and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113032487A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101458808A (en) * | 2008-12-31 | 2009-06-17 | 中国建设银行股份有限公司 | Bank management system, server cluster and correlation method |
| CN106131233A (en) * | 2016-06-20 | 2016-11-16 | 腾讯科技（深圳）有限公司 | Realize method, Apparatus and system that data base's multipath accesses |
| CN106998370A (en) * | 2017-06-15 | 2017-08-01 | 北京微影时代科技有限公司 | Access control method, device and system |
| US20170353456A1 (en) * | 2016-06-07 | 2017-12-07 | International Business Machines Corporation | Controlling access to a vault server in a multitenant environment |
| CN109729050A (en) * | 2017-10-31 | 2019-05-07 | 北京国双科技有限公司 | A kind of network access monitoring method and device |
-
2021
- 2021-03-22 CN CN202110301864.7A patent/CN113032487A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101458808A (en) * | 2008-12-31 | 2009-06-17 | 中国建设银行股份有限公司 | Bank management system, server cluster and correlation method |
| US20170353456A1 (en) * | 2016-06-07 | 2017-12-07 | International Business Machines Corporation | Controlling access to a vault server in a multitenant environment |
| CN106131233A (en) * | 2016-06-20 | 2016-11-16 | 腾讯科技（深圳）有限公司 | Realize method, Apparatus and system that data base's multipath accesses |
| CN106998370A (en) * | 2017-06-15 | 2017-08-01 | 北京微影时代科技有限公司 | Access control method, device and system |
| CN109729050A (en) * | 2017-10-31 | 2019-05-07 | 北京国双科技有限公司 | A kind of network access monitoring method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP5458308B2 (en) | Virtual computer system, virtual computer system monitoring method, and network device | |
| EP3281360B1 (en) | Virtualized network function monitoring | |
| CN106533890B (en) | Message processing method, device and system | |
| EP3806395B1 (en) | Virtual network function (vnf) deployment method and apparatus | |
| US10530634B1 (en) | Two-channel-based high-availability | |
| CN113489691A (en) | Network access method, device, computer readable medium and electronic equipment | |
| EP3044906A1 (en) | Apparatus and method for monitoring network performance | |
| KR100951131B1 (en) | Method and apparatus for supporting transactions | |
| US11153173B1 (en) | Dynamically updating compute node location information in a distributed computing environment | |
| JP6604336B2 (en) | Information processing apparatus, information processing method, and program | |
| CN113242299A (en) | Disaster recovery system, method, computer device and medium for multiple data centers | |
| CN113032487A (en) | Database access system, method, electronic device and medium | |
| CN113114588B (en) | Data processing method and device, electronic equipment and storage medium | |
| CN106453118B (en) | Flow control method and flow control system | |
| CN113672416B (en) | Method and device for positioning cause of hard buffer leakage | |
| CN115225634A (en) | Data forwarding method and device under virtual network and computer program product | |
| CN113238893A (en) | Disaster recovery system, method, computer device and medium for multiple data centers | |
| CN112637340B (en) | Domain name resolution system, monitoring method, cache cleaning method, device and medium | |
| JP2013206074A (en) | Network management system, network management method, network monitoring system, and network management program | |
| US10417093B2 (en) | Methods for providing global spare data storage device management and devices thereof | |
| US20150381449A1 (en) | Apparatus and method for suppressing a delay in monitoring communication | |
| CN117768291A (en) | Service providing method, device, equipment and storage medium | |
| CN116488917A (en) | Multi-tenant service access method, device, node and storage medium | |
| CN115277474A (en) | Health index obtaining method and device of business system on cloud platform and electronic equipment | |
| CN113098728A (en) | Health check method of load balancing system and related equipment |
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 |