CN110677353A - Data access method and system - Google Patents
Data access method and system Download PDFInfo
- Publication number
- CN110677353A CN110677353A CN201910843629.5A CN201910843629A CN110677353A CN 110677353 A CN110677353 A CN 110677353A CN 201910843629 A CN201910843629 A CN 201910843629A CN 110677353 A CN110677353 A CN 110677353A
- Authority
- CN
- China
- Prior art keywords
- application request
- service line
- user
- deployment unit
- information
- 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
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L47/00—Traffic control in data switching networks
- H04L47/10—Flow control; Congestion control
- H04L47/12—Avoiding congestion; Recovering from congestion
- H04L47/122—Avoiding congestion; Recovering from congestion by diverting traffic away from congested entities
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/08—Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters
Abstract
An embodiment of the present invention provides a data access method, including: detecting whether a user logs in a target system or not; when login is detected, determining a deployment unit corresponding to login information according to the login information of a user; when a plurality of application requests initiated by a plurality of users are acquired from a plurality of user terminals and a target application request in the plurality of application requests is determined to be a first deployment unit in a plurality of deployment units, performing F5 load balancing processing on the target application request; according to the equalization processing result, a first application request in the target application request is distributed to a first instance, so that the first instance processes the first application request and obtains a processing result; and sending the processing result to a first monitoring port of the server so as to access the database through the first monitoring port. By the embodiment of the invention, the service processing capacity of the database monitoring port can be improved, the processing pressure during the service peak is relieved, and the loss rate of the application request during the service peak is reduced.
Description
Technical Field
The embodiment of the invention relates to the field of big data, in particular to a data access method, a data access system, computer equipment and a readable storage medium.
Background
With the development of network technology, it is often the case that multiple users initiate requests to the same application at the same time, for example: when a hot topic appears, the number of users searching the hot topic at the same time is tens of thousands. The application request information initiated by the user needs to pass through the monitoring port, and the size of the monitoring port limits the number of the application requests. When the network is in a traffic peak period, the processing capacity of the monitoring port is far lower than the number of application requests, so that a large number of application requests are lost, and the network is paralyzed.
Therefore, the invention aims to solve the problem that a large number of application requests are lost during the peak period of the service, so that the network is paralyzed.
Disclosure of Invention
In view of this, it is necessary to provide a data access method, a data access system, a computer device, and a readable storage medium, which can greatly improve the service processing capability of a database monitor port, effectively relieve the processing pressure during a service peak, and reduce the loss rate of application requests during the service peak.
In order to achieve the above object, an embodiment of the present invention provides a data access method, where the method includes:
detecting whether a user logs in a target system or not;
when the user is detected to log in the target system, determining a deployment unit corresponding to login information according to the login information of the user, wherein the login information at least comprises account information and terminal information for logging in the account information;
when a plurality of application requests initiated by a plurality of users are acquired from a plurality of user terminals, and a target application request in the plurality of application requests is determined to be a first deployment unit in a plurality of deployment units, performing F5 load balancing processing on the target application request, wherein the first deployment unit comprises a plurality of instances, and the plurality of instances comprise a first instance;
according to the equalization processing result, a first application request in the target application request is distributed to the first instance, so that the first instance processes the first application request and obtains a processing result;
and sending the processing result to a first monitoring port of a server so as to access a database through the first monitoring port.
Optionally, the step of determining, when it is detected that the user logs in the target system, a deployment unit corresponding to the login information according to the login information of the user further includes:
acquiring the account information from the terminal of the user;
determining service line attribute information of the account information according to the account information and an account attribute table stored in a database, wherein the service line attribute information comprises a domain name address, and the account attribute table comprises corresponding relation between preset account information and preset service line attribute information;
determining a service line corresponding to the service line attribute information according to the service line attribute information; and
and matching the service line with a preset service line stored in a database and a preset service line in a deployment unit corresponding table to determine a deployment unit corresponding to the application request sent by the terminal.
Optionally, before the step of performing F5 load balancing processing on the target application request when multiple application requests initiated by multiple users are obtained from multiple user terminals and the target application request in the multiple application requests is determined to be the first deployment unit in the multiple deployment units, the method further includes:
creating F5Pool so that the F5Pool performs load balancing processing on the target application request, wherein the F5Pool comprises a plurality of load balancing devices.
Optionally, the method further comprises:
before creating the F5Pool, setting the plurality of deployment units, wherein the plurality of deployment units are deployed according to a preset mode.
Optionally, before the step of sending the processing result to a first listening port of a server to access a database through the first listening port, the method further includes:
and setting the first monitoring port at the server side.
Optionally, after the step of sending the processing result to a first listening port of a server to access a database through the first listening port, the method further includes:
acquiring a link in the first application request;
matching the link with a preset link in a link table stored in a database of the server, wherein the link table comprises the preset link and data corresponding to the preset link; and
and sending the data corresponding to the link to the user terminal corresponding to the first application request according to the matching result.
In order to achieve the above object, an embodiment of the present invention further provides a data access system, including:
the detection module is used for detecting whether a user logs in a target system or not;
the determining module is used for determining a deployment unit corresponding to login information according to the login information of the user when the user is detected to log in the target system, wherein the login information at least comprises account information and terminal information for logging in the account information;
the balancing module is used for carrying out F5 load balancing processing on a target application request when the plurality of application requests initiated by a plurality of users are obtained from a plurality of user terminals and the target application request in the plurality of application requests is determined to be a first deployment unit in a plurality of deployment units, wherein the first deployment unit comprises a plurality of instances, and the plurality of instances comprise a first instance;
the allocation module is used for allocating a first application request in the target application request to the first instance according to a balanced processing result so that the first instance processes the first application request and obtains a processing result;
and the sending module is used for sending the processing result to a first monitoring port of the server so as to access the database through the first monitoring port.
Optionally, the determining module is further configured to:
acquiring the account information from the terminal of the user;
determining service line attribute information of the account information according to the account information and an account attribute table stored in a database, wherein the service line attribute information comprises a domain name address, and the account attribute table comprises corresponding relation between preset account information and preset service line attribute information;
determining a service line corresponding to the service line attribute information according to the service line attribute information; and
and matching the service line with a preset service line stored in a database and a preset service line in a deployment unit corresponding table to determine a deployment unit corresponding to the application request sent by the terminal.
Optionally, the data access system further includes a creating module, configured to create F5Pool, so that the F5Pool performs load balancing processing on the target application request, where the F5Pool includes a plurality of load balancing devices.
Optionally, the data access system further includes a setting module, configured to set the multiple deployment units before creating the F5Pool, where the multiple deployment units are deployed according to a preset manner.
Optionally, the setting module is further configured to set the first listening port at the server side.
Optionally, the data access system further comprises:
an obtaining module, configured to obtain a link in the first application request;
the matching module is used for matching the link with a preset link in a link table stored in a database of the server, wherein the link table comprises the preset link and data corresponding to the preset link; and
and the sending module is further used for sending the data corresponding to the link to the user terminal corresponding to the first application request according to the matching result.
To achieve the above object, an embodiment of the present invention further provides a computer device, a memory of the computer device, a processor, and a computer program stored on the memory and executable on the processor, where the computer program, when executed by the processor, implements the steps of the data access method as described above.
To achieve the above object, an embodiment of the present invention further provides a computer-readable storage medium, in which a computer program is stored, where the computer program is executable by at least one processor to cause the at least one processor to execute the steps of the data access method described above.
According to the data access method, the data access system, the computer device and the readable storage medium, the deployment unit allocated by the application request sent by the terminal is determined according to the account information of the user terminal logging in the target system, when a plurality of application requests initiated by a plurality of user terminals are received and the target application request in the plurality of application requests is determined to be the first deployment unit in the plurality of deployment units, the target application request is subjected to load balancing so as to be allocated to different instances, the instances process the target application request, and then the processing result is sent to the corresponding monitoring port so as to access the database through the monitoring port. By the embodiment of the invention, the service processing capacity of the database monitoring port is greatly improved, the processing pressure during the service peak is effectively relieved, and the loss rate of the application request during the service peak is reduced.
Drawings
FIG. 1 is an environmental architecture diagram of an embodiment of the present invention.
Fig. 2 is a flowchart illustrating steps of a data access method according to a first embodiment of the present invention.
Fig. 3 is a schematic hardware architecture of a computer device according to a second embodiment of the present invention.
Fig. 4 is a schematic diagram of program modules of a data access system according to a third embodiment of the present invention.
Reference numerals:
| |
2 |
| Memory device | 21 |
| Processor with a memory having a plurality of memory cells | 22 |
| Network interface | 23 |
| |
20 |
| Detection module | 201 |
| Determining module | 202 |
| Equalization module | 203 |
| Dispensing module | 204 |
| Transmission module | 205 |
| Creation module | 206 |
| Setting module | 207 |
| Acquisition module | 208 |
| Matching module | 209 |
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the description relating to "first", "second", etc. in the present invention is for descriptive purposes only and is not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In addition, technical solutions between various embodiments may be combined with each other, but must be realized by a person skilled in the art, and when the technical solutions are contradictory or cannot be realized, such a combination should not be considered to exist, and is not within the protection scope of the present invention.
Referring to fig. 1, an environment architecture diagram according to an embodiment of the present invention is shown. Fig. 1 shows that a terminal a and a terminal B … send application requests to an F5Pool, and then the F5Pool distributes the application requests to distribute the application requests to corresponding first deployment unit and second deployment unit … kth deployment unit. The first deployment unit, the second deployment unit …, and the kth deployment unit are respectively connected to the first monitor port, the second monitor port …, and the mth monitor port, so as to process the corresponding application request and send the processing result to the server through different monitor ports to access the database. The first deployment unit, the second deployment unit …, and the kth deployment unit are respectively provided with a plurality of instances, for example, instance 1, instance 2 …, instance n, and the F5Pool is provided with a plurality of F5 to load balance the application requests to different instances of the first deployment unit, the second deployment unit …, and the kth deployment unit.
Example one
Referring to fig. 2, a flowchart illustrating steps of a data access method according to a first embodiment of the present invention is shown. It is to be understood that the flow charts in the embodiments of the present method are not intended to limit the order in which the steps are performed. It should be noted that the present embodiment is exemplarily described with the computer device 2 as an execution subject. The method comprises the following specific steps:
step S100, detecting whether the user logs in the target system.
Illustratively, whether the user logs in a target system or not is detected by detecting information sent by a port of a user terminal. When the information of logging in the target system sent by the port is detected, detecting that a user logs in the target system; and when the information of logging in the target system sent by the port is not detected, detecting that the user does not log in the target system.
Step S102, when it is detected that the user logs in the target system, determining a deployment unit corresponding to login information according to the login information of the user, wherein the login information at least comprises account information and terminal information for logging in the account information.
It should be noted that the deployment unit in this embodiment includes multiple instances, where each instance is used to process an application request initiated by the user to implement analysis of the application request, for example, when the application request is a search request, an analysis result of the application request is data in a search database.
In a preferred embodiment, when it is detected that the user logs in the target system, the account information is first acquired from the terminal of the user. And then, determining service line attribute information of the account information according to the account information and an account attribute table stored in a database, wherein the service line attribute information comprises a domain name address, the account attribute table comprises corresponding relations of preset account information and preset service line attribute information, and determining a service line corresponding to the service line attribute information according to the service line attribute information. And finally, matching the service line with a preset service line stored in a database and a preset service line in a deployment unit corresponding table to determine a deployment unit corresponding to the application request sent by the terminal.
For example, first, since account information logged into the target system is provided with a service line attribute tag, the account information is obtained from a terminal of a user and the service line attribute tag is determined, for example: a sina tag. Then, determining a corresponding service line according to the service line attribute tag, such as: and (4) a Xinlang website. Finally, determining a corresponding deployment unit according to the determined service line, for example: a first deployment unit.
Step S104, when a plurality of application requests initiated by a plurality of users are obtained from a plurality of user terminals and a target application request in the plurality of application requests is determined to be a first deployment unit in a plurality of deployment units, performing F5 load balancing processing on the target application request, wherein the first deployment unit comprises a plurality of instances, and the plurality of instances comprise the first instance.
Exemplarily, referring to fig. 1, when a user a and a user B respectively input information for searching for page three from a terminal a and a terminal B simultaneously or sequentially within a preset time, an application request for searching for page three is acquired from the terminal a and the terminal B, respectively. After acquiring the application request of the search zhang from the terminal a and the terminal B, the deployment units determined by the terminal a and the terminal B are both first deployment units, and the application request of the terminal a and the application request of the terminal B are allocated to different instances of the first deployment units through equalization processing, for example: example 1 and example 2. Of course, according to a specific F5 load balancing scenario, the application request of terminal a and the application request of terminal B may also be allocated to the same instance, for example: example 1, the embodiment of the present invention is exemplarily illustrated only by different examples in which the application request of the terminal a and the application request of the terminal B are allocated to the same deployment unit. When a user A inputs information for searching for Zhang III from a terminal A and a user B inputs information for saving Zhang III from a terminal B, acquiring an application request for searching for Zhang III from the terminal A and acquiring an application request for saving Zhang III from the terminal B, wherein the terminal A is inconsistent with a deployment unit determined by the terminal B, for example: the deployment unit determined by the terminal A is a first deployment unit, and the deployment unit determined by the terminal B is a second deployment unit.
In a preferred embodiment, when a plurality of application requests initiated by a plurality of users are obtained from a plurality of user terminals, and a target application request in the plurality of application requests is determined to be a first deployment unit in a plurality of deployment units, before F5 load balancing processing is performed on the target application request, F5Pool is created, so that the F5Pool performs load balancing processing on the target application request, where the F5Pool includes a plurality of load balancing devices.
Specifically, the load balancing device balances the application request according to a preset algorithm. The preset algorithm is usually a polling method, but in the embodiment of the present invention, the preset algorithm may also be a weighted polling method or a minimum connection number method. It should be noted that the multiple load balancing devices may be F5 load balancing, and certainly, other load balancing products may be selected to distribute the multiple application requests, and in the embodiment of the present invention, F5 load balancing is described.
It should be noted that, by performing F5 load balancing on multiple application requests of the same deployment unit, the multiple application requests are distributed to different instances in the same deployment unit in a load balancing manner.
Step S106, according to the equalization processing result, a first application request in the target application request is distributed to the first instance, so that the first instance processes the first application request, and a processing result is obtained.
Referring to fig. 1, if the application requests a, b, c and d are determined as the first deployment units, F5 load balances the application requests a, b, c and d, and distributes the application requests a and b to instance 1 and the application requests c and d to instance 2 as a result of the load balancing. Then, the example 1 performs parsing on the application requests a and b, and the example 2 performs parsing on the application requests c and d.
In a preferred embodiment, with reference to fig. 1, if the application requests a, b, c and d are determined to be the first deployment unit, F5 load balances the application requests a, b, c and d, and distributes the application requests a and b to instance 1 and the application requests c and d to instance 2 as a result. If the instance 1 fails, the application requests a and b are distributed to other instances, such as instance 3.
Step S108, the processing result is sent to a first monitoring port of the server, so that the database is accessed through the first monitoring port.
Illustratively, when an application request for searching for information of zhang san is received by the example 1, the application request is processed by the example 1, and a processing result of zhang san is sent to a first listening port of the server, and then the database is accessed through the first listening port.
In a preferred embodiment, the data access method further includes: before creating the F5Pool, setting the plurality of deployment units, wherein the plurality of deployment units are deployed according to a preset mode.
In another preferred embodiment, before the step of sending the processing result to a first listening port of a server to access a database through the first listening port, the method further includes: and setting the first monitoring port at the server side.
Illustratively, in conjunction with fig. 1, the server side is provided with a single first snoop port, and the processing capability of the snoop port to the application request is improved by adding the second snoop port …, the mth snoop port.
In a preferred embodiment, after the step of sending the processing result to a first monitoring port of a server to pass through the first monitoring port, a link in the first application request is obtained, and then the link is matched with a preset link in a link table stored in a database of the server, wherein the link table includes the preset link and data corresponding to the preset link, and the data corresponding to the link is sent to a user terminal corresponding to the first application request according to a matching result.
Illustratively, if the application request includes a link 1, matching the link 1 with a preset link in a link table stored in a database, and if the link 1 exists in the link table stored in the database, matching successfully, and sending data corresponding to the link 1 in the database to a user terminal corresponding to the application request.
By the embodiment of the invention, the service processing capacity of the database monitoring port is greatly improved, the processing pressure during the service peak is effectively relieved, and the loss rate of the application request during the service peak is reduced.
Example two
Referring to fig. 3, a hardware architecture diagram of a computer device according to a second embodiment of the invention is shown. The computer device 2 includes, but is not limited to, a memory 21, a processor 22, and a network interface 23 communicatively coupled to each other via a system bus, and fig. 2 illustrates only the computer device 2 having components 21-23, but it is to be understood that not all of the illustrated components are required and that more or fewer components may alternatively be implemented.
The memory 21 includes at least one type of readable storage medium including a flash memory, a hard disk, a multimedia card, a card type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a Programmable Read Only Memory (PROM), a magnetic memory, a magnetic disk, an optical disk, etc. In some embodiments, the memory 21 may be an internal storage unit of the computer device 2, such as a hard disk or a memory of the computer device 2. In other embodiments, the memory may also be an external storage device of the computer device 2, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a flash Card (FlashCard), and the like, provided on the computer device 2. Of course, the memory 21 may also comprise both an internal storage unit of the computer device 2 and an external storage device thereof. In this embodiment, the memory 21 is generally used for storing an operating system installed in the computer device 2 and various application software, such as program codes of the data access system 20. Further, the memory 21 may also be used to temporarily store various types of data that have been output or are to be output.
The processor 22 may be a Central Processing Unit (CPU), controller, microcontroller, microprocessor, or other data Processing chip in some embodiments. The processor 22 is typically used to control the overall operation of the computer device 2. In this embodiment, the processor 22 is configured to execute the program code stored in the memory 21 or process data, for example, execute the data access system 20.
The network interface 23 may comprise a wireless network interface or a wired network interface, and the network interface 23 is generally used for establishing communication connection between the computer device 2 and other electronic devices. For example, the network interface 23 is used to connect the computer device 2 to an external terminal through a network, establish a data transmission channel and a communication connection between the computer device 2 and the external terminal, and the like. The network may be a wireless or wired network such as an Intranet (Intranet), the Internet (Internet), a Global System of Mobile communication (GSM), Wideband Code Division Multiple Access (WCDMA), a 4G network, a 5G network, Bluetooth (Bluetooth), Wi-Fi, and the like.
EXAMPLE III
Referring to fig. 4, a schematic diagram of program modules of a data access system according to a third embodiment of the present invention is shown. In this embodiment, the data access system 20 may include or be divided into one or more program modules, which are stored in a storage medium and executed by one or more processors to implement the present invention and implement the data access methods described above. The program modules referred to in the embodiments of the present invention are a series of computer program instruction segments that can perform specific functions, and are more suitable than the program itself for describing the execution process of the data access system 20 in the storage medium. The following description will specifically describe the functions of the program modules of the present embodiment:
the detecting module 201 is configured to detect whether a user logs in a target system.
Illustratively, the detection module 201 detects whether the user logs in the target system by detecting information sent by a port of the user terminal. When the detection module 201 detects the information for logging in the target system sent by the port, it is determined that the user logs in the target system; when the detection module 201 does not detect the information for logging in the target system sent by the port, it is determined that the user does not log in the target system.
A determining module 202, configured to determine, when it is detected that the user logs in the target system, a deployment unit corresponding to login information according to the login information of the user, where the login information at least includes account information and terminal information for logging in the account information.
It should be noted that the deployment unit in this embodiment includes multiple instances, where each instance is used to process an application request initiated by the user to implement analysis of the application request, for example, when the application request is a search request, an analysis result of the application request is data in a search database.
In a preferred embodiment, the determining module 202 is further configured to obtain the account information from the terminal of the user; determining service line attribute information of the account information according to the account information and an account attribute table stored in a database, wherein the service line attribute information comprises a domain name address, and the account attribute table comprises corresponding relation between preset account information and preset service line attribute information; determining a service line corresponding to the service line attribute information according to the service line attribute information; and matching the service line with a preset service line stored in a database and a preset service line in a deployment unit corresponding table to determine a deployment unit corresponding to the application request sent by the terminal.
For example, first, since the account information logged into the target system is provided with a service line attribute tag, the determining module 202 first obtains the account information from the terminal of the user and determines the service line attribute tag, for example: a sina tag. Then, determining a corresponding service line according to the service line attribute tag, such as: and (4) a Xinlang website. Finally, determining a corresponding deployment unit according to the determined service line, for example: a first deployment unit.
A balancing module 203, configured to perform F5 load balancing on a target application request when multiple application requests initiated by multiple users are obtained from multiple user terminals and the target application request in the multiple application requests is determined to be a first deployment unit in multiple deployment units, where the first deployment unit includes multiple instances, and the multiple instances include the first instance.
Exemplarily, referring to fig. 1, when a user a and a user B respectively input information for searching for page three from a terminal a and a terminal B simultaneously or sequentially within a preset time, an application request for searching for page three is acquired from the terminal a and the terminal B, respectively. After acquiring the application request of the search zhang from the terminal a and the terminal B, the deployment units determined by the terminal a and the terminal B are both first deployment units, and after equalization processing, the equalization module 203 allocates the application request of the terminal a and the application request of the terminal B to different instances of the first deployment units, for example: example 1 and example 2. Of course, according to a specific F5 load balancing scenario, the application request of terminal a and the application request of terminal B may also be allocated to the same instance, for example: example 1, the embodiment of the present invention is exemplarily illustrated only by different examples in which the application request of the terminal a and the application request of the terminal B are allocated to the same deployment unit. When a user A inputs information for searching for Zhang III from a terminal A and a user B inputs information for saving Zhang III from a terminal B, acquiring an application request for searching for Zhang III from the terminal A and acquiring an application request for saving Zhang III from the terminal B, wherein the terminal A is inconsistent with a deployment unit determined by the terminal B, for example: the deployment unit determined by the terminal A is a first deployment unit, and the deployment unit determined by the terminal B is a second deployment unit.
In a preferred embodiment, the data access system 20 further includes a creating module 206, configured to create F5Pool, so that the F5Pool performs load balancing processing on the target application request, where the F5Pool includes a plurality of load balancing devices.
Specifically, the load balancing device balances the application request according to a preset algorithm. The preset algorithm is usually a polling method, but in the embodiment of the present invention, the preset algorithm may also be a weighted polling method or a minimum connection number method. It should be noted that the multiple load balancing devices may be F5 load balancing, and certainly, other load balancing products may be selected to distribute the multiple application requests, and in the embodiment of the present invention, F5 load balancing is described.
It should be noted that, by performing F5 load balancing on multiple application requests of the same deployment unit, the multiple application requests are distributed to different instances in the same deployment unit in a load balancing manner.
The allocating module 204 is configured to allocate, according to a balancing processing result, a first application request in the target application request to the first instance, so that the first instance processes the first application request and obtains a processing result.
Referring to fig. 1, if the application requests a, b, c and d are determined as the first deployment units, F5 load balances the application requests a, b, c and d, and the distribution module 204 distributes the application requests a and b to instance 1 and distributes the application requests c and d to instance 2. Then, the example 1 performs parsing on the application requests a and b, and the example 2 performs parsing on the application requests c and d.
In a preferred embodiment, with reference to fig. 1, if the application requests a, b, c and d are determined to be the first deployment unit, F5 load balances the application requests a, b, c and d, and the distribution module 204 distributes the application requests a and b to instance 1 and the application requests c and d to instance 2. If the instance 1 fails, the allocation module 204 allocates the application requests a and b to other instances, such as instance 3.
A sending module 205, configured to send the processing result to a first listening port of a server, so as to access a database through the first listening port.
Illustratively, when the example 1 receives an application request for searching information of zhang san, the example 1 processes the application request, and the sending module 205 sends a processing result of zhang san to a first listening port of the server, and then accesses the database through the first listening port.
In a preferred embodiment, the data access system 20 further includes a setting module 207, configured to set a plurality of deployment units before creating the F5Pool, where the deployment units are deployed according to a preset manner.
Illustratively, the preset manner at least includes a function requested by the first application. For example: the first deployment unit functions to search for information.
In another preferred embodiment, the setting module 207 is further configured to set the first listening port at the server side.
Illustratively, in conjunction with fig. 1, the server side is provided with a single first snoop port, and the processing capability of the snoop port to the application request is improved by adding the second snoop port …, the mth snoop port.
In a preferred embodiment, the data access system 20 further comprises an obtaining module 208 and a matching module 209. The obtaining module 208 is configured to obtain the link in the first application request. The matching module 209 is configured to match the link with a preset link in a link table stored in a database of the server, where the link table includes the preset link and data corresponding to the preset link. The sending module 205 is further configured to send the data corresponding to the link to the user terminal corresponding to the first application request according to the matching result.
For example, if the application request includes link 1, the matching module 209 matches the link 1 with a preset link in a link table stored in a database. If there is link 1 in the link table stored in the database, the matching is successful, and the sending module 205 sends the data corresponding to the link 1 in the database to the user terminal corresponding to the first application request.
By the embodiment of the invention, the service processing capacity of the database monitoring port is greatly improved, the processing pressure during the service peak is effectively relieved, and the loss rate of the application request during the service peak is reduced.
The present invention also provides a computer device, such as a smart phone, a tablet computer, a notebook computer, a desktop computer, a rack server, a blade server, a tower server or a rack server (including an independent server or a server cluster composed of a plurality of servers) capable of executing programs, and the like. The computer device of the embodiment at least includes but is not limited to: memory, processor, etc. communicatively coupled to each other via a system bus.
The present embodiment also provides a computer-readable storage medium, such as a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a read-only memory (ROM), an electrically erasable programmable read-only memory (EEPROM), a programmable read-only memory (PROM), a magnetic memory, a magnetic disk, an optical disk, a server, an App application mall, etc., on which a computer program is stored, which when executed by a processor implements corresponding functions. The computer-readable storage medium of the embodiment is used for storing the data access system 20, and when being executed by a processor, the data access method of the first embodiment is implemented.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A method of data access, comprising:
detecting whether a user logs in a target system or not;
when the user is detected to log in the target system, determining a deployment unit corresponding to login information according to the login information of the user, wherein the login information at least comprises account information and terminal information for logging in the account information;
when a plurality of application requests initiated by a plurality of users are acquired from a plurality of user terminals, and a target application request in the plurality of application requests is determined to be a first deployment unit in a plurality of deployment units, performing F5 load balancing processing on the target application request, wherein the first deployment unit comprises a plurality of instances, and the plurality of instances comprise a first instance;
according to the equalization processing result, a first application request in the target application request is distributed to the first instance, so that the first instance processes the first application request and obtains a processing result;
and sending the processing result to a first monitoring port of a server so as to access a database through the first monitoring port.
2. The data access method of claim 1, wherein the step of determining the deployment unit corresponding to the login information according to the login information of the user when the user is detected to log in the target system further comprises:
acquiring the account information from the terminal of the user;
determining service line attribute information of the account information according to the account information and an account attribute table stored in a database, wherein the service line attribute information comprises a domain name address, and the account attribute table comprises corresponding relation between preset account information and preset service line attribute information;
determining a service line corresponding to the service line attribute information according to the service line attribute information; and
and matching the service line with a preset service line stored in a database and a preset service line in a deployment unit corresponding table to determine a deployment unit corresponding to the application request sent by the terminal.
3. The data access method according to claim 1, wherein before the step of performing F5 load balancing processing on the target application request when the plurality of application requests originated by the plurality of users are obtained from the plurality of user terminals and the target application request in the plurality of application requests is determined to be the first deployment unit in the plurality of deployment units, the method further comprises:
creating F5Pool to make the F5Pool perform load balancing processing on the target application request, wherein the F5Pool comprises a plurality of load balancing devices.
4. The data access method of claim 3, wherein the method further comprises:
before creating the F5Pool, setting the plurality of deployment units, wherein the plurality of deployment units are deployed according to a preset mode.
5. The data access method of claim 1, wherein prior to the step of sending the processing result to a first listening port of a server for accessing a database through the first listening port, further comprising:
and setting the first monitoring port at the server side.
6. The data access method of claim 1, wherein after the step of sending the processing result to a first listening port of a server for accessing a database through the first listening port, further comprising:
acquiring a link in the first application request;
matching the link with a preset link in a link table stored in a database of the server, wherein the link table comprises the preset link and data corresponding to the preset link; and
and sending the data corresponding to the link to the user terminal corresponding to the first application request according to the matching result.
7. A data access system, comprising:
the detection module is used for detecting whether a user logs in a target system or not;
the determining module is used for determining a deployment unit corresponding to login information according to the login information of the user when the user is detected to log in the target system, wherein the login information at least comprises account information and terminal information for logging in the account information;
the balancing module is used for carrying out F5 load balancing processing on a target application request when the plurality of application requests initiated by a plurality of users are obtained from a plurality of user terminals and the target application request in the plurality of application requests is determined to be a first deployment unit in a plurality of deployment units, wherein the first deployment unit comprises a plurality of instances, and the plurality of instances comprise a first instance;
the allocating module 204 is configured to allocate, according to a balancing processing result, a first application request in the target application requests to the first instance, so that the first instance processes the first application request and obtains a processing result;
and the sending module is used for sending the processing result to a first monitoring port of the server so as to access the database through the first monitoring port.
8. The data access system of claim 7, wherein the determination module is further to:
acquiring the account information from the terminal of the user;
determining service line attribute information of the account information according to the account information and an account attribute table stored in a database, wherein the service line attribute information comprises a domain name address, and the account attribute table comprises corresponding relation between preset account information and preset service line attribute information;
determining a service line corresponding to the service line attribute information according to the service line attribute information; and
and matching the service line with a preset service line stored in a database and a preset service line in a deployment unit corresponding table to determine a deployment unit corresponding to the application request sent by the terminal.
9. A computer device, characterized by a computer device memory, a processor and a computer program stored on the memory and executable on the processor, which computer program, when executed by the processor, carries out the steps of the data access method according to any one of claims 1-6.
10. A computer-readable storage medium, in which a computer program is stored which is executable by at least one processor to cause the at least one processor to perform the steps of the data access method according to any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910843629.5A CN110677353B (en) | 2019-09-06 | 2019-09-06 | Data access method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910843629.5A CN110677353B (en) | 2019-09-06 | 2019-09-06 | Data access method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110677353A true CN110677353A (en) | 2020-01-10 |
| CN110677353B CN110677353B (en) | 2022-11-22 |
Family
ID=69076146
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910843629.5A Active CN110677353B (en) | 2019-09-06 | 2019-09-06 | Data access method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110677353B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112698838A (en) * | 2020-12-29 | 2021-04-23 | 广州三七互娱科技有限公司 | Multi-cloud container deployment system and container deployment method thereof |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103595570A (en) * | 2013-11-20 | 2014-02-19 | 中国农业银行股份有限公司广东省分行 | Multi-operation framework front-mounted system, server and service processing method |
| CN104079630A (en) * | 2014-06-09 | 2014-10-01 | 中国建设银行股份有限公司 | Business server side load balancing method, client side, server side and system |
| US20160188427A1 (en) * | 2014-12-31 | 2016-06-30 | Servicenow, Inc. | Failure resistant distributed computing system |
| CN107426341A (en) * | 2017-09-13 | 2017-12-01 | 北京智芯微电子科技有限公司 | The system and method that APP interacts with service end |
| CN108762917A (en) * | 2018-05-04 | 2018-11-06 | 平安科技（深圳）有限公司 | Access request processing method, device, system, computer equipment and storage medium |
-
2019
- 2019-09-06 CN CN201910843629.5A patent/CN110677353B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103595570A (en) * | 2013-11-20 | 2014-02-19 | 中国农业银行股份有限公司广东省分行 | Multi-operation framework front-mounted system, server and service processing method |
| CN104079630A (en) * | 2014-06-09 | 2014-10-01 | 中国建设银行股份有限公司 | Business server side load balancing method, client side, server side and system |
| US20160188427A1 (en) * | 2014-12-31 | 2016-06-30 | Servicenow, Inc. | Failure resistant distributed computing system |
| CN107426341A (en) * | 2017-09-13 | 2017-12-01 | 北京智芯微电子科技有限公司 | The system and method that APP interacts with service end |
| CN108762917A (en) * | 2018-05-04 | 2018-11-06 | 平安科技（深圳）有限公司 | Access request processing method, device, system, computer equipment and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112698838A (en) * | 2020-12-29 | 2021-04-23 | 广州三七互娱科技有限公司 | Multi-cloud container deployment system and container deployment method thereof |
| CN112698838B (en) * | 2020-12-29 | 2023-09-08 | 广州三七互娱科技有限公司 | Multi-cloud container deployment system and container deployment method thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110677353B (en) | 2022-11-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109918205B (en) | Edge equipment scheduling method, system, device and computer storage medium | |
| CN109995866B (en) | Distributed file verification method and device, computer device and storage medium | |
| CN107239701B (en) | Method and device for identifying malicious website | |
| CN113542384B (en) | Access request access control method, device, computer equipment and storage medium | |
| CN114095567B (en) | Data access request processing method and device, computer equipment and medium | |
| CN111752770A (en) | Service request processing method, system, computer device and storage medium | |
| CN115277566B (en) | Load balancing method and device for data access, computer equipment and medium | |
| CN109819023B (en) | Distributed transaction processing method and related product | |
| CN108170551B (en) | Crawler system based front-end and back-end error processing method, server and storage medium | |
| CN104902033B (en) | Log in address recording method and device | |
| CN110677353B (en) | Data access method and system | |
| CN109905407B (en) | Management method, system, equipment and medium for accessing intranet based on VPN server | |
| CN104021324A (en) | Method and device for writing safety verification | |
| CN109711193B (en) | Storage space sharing method and device | |
| CN111885184A (en) | Method and device for processing hot spot access keywords in high concurrency scene | |
| CN109697166B (en) | Test data preparation method and related device | |
| CN108647139B (en) | System test method, device, storage medium and electronic device | |
| WO2022143758A1 (en) | Data desensitization method and apparatus, and storage system | |
| CN107798250B (en) | Sensitive information shielding rule issuing method, application server and computer readable storage medium | |
| CN115454896A (en) | SMBUS-based SSD MCTP control message verification method and device, computer equipment and storage medium | |
| CN113746918A (en) | Hypertext transfer protocol proxy method and system | |
| CN107704557B (en) | Processing method and device for operating mutually exclusive data, computer equipment and storage medium | |
| CN115038089B (en) | Multi-terminal data monitoring and collecting method based on information extraction | |
| CN110704498A (en) | Data extraction method, device, equipment and computer readable storage medium | |
| CN113891385B (en) | Method, device and equipment for detecting link state of network 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |