Intermediate management method and device capable of selecting management strategy, equipment and product

Abstract

The invention discloses an intermediate management method, device, equipment and product capable of selecting a management strategy, which can select a matched strategy back-end object from a stored strategy back-end object set to connect to a server side according to the connection requirement of a user side, realize the connection between the user side capable of selecting the management strategy and the server side, and improve the user experience. Moreover, a new strategy back end can be established and strategy back end objects which are not used for a long time can be deleted according to the connection requirements of the user side, the diversified requirements of the user side can be met through personalized and controllable strategy setting, and the user experience is improved. The method has the characteristics of high transparency degree of connection between the user side and the server side, high adaptability of the management strategy and small redundant occupied space.

Description

Technical Field

[0001] The present invention belongs to the field of database management, and in particular relates to an intermediate management method, device, equipment and product capable of selecting a management strategy. Background Art

[0002] When using database products, the management strategies for different users to connect to database instances are also different. However, under existing technical conditions, when users connect to data nodes and perform operations on database instances, the settings of management strategies are usually relatively simple. Often, only a relatively unified connection management strategy from user to data server can be set according to needs, and the management effect is very limited. At the same time, when it is necessary to change the connection management strategy between the user and the data server, there are also problems such as high maintenance cost, slow update speed and impact on the actual use effect of the database. Summary of the invention

[0003] In view of this, the present invention aims to overcome the defects in the prior art and proposes an intermediate management method, device, equipment and product capable of selecting a management strategy.

[0004] To achieve the above object, the technical solution of the present invention is achieved as follows: In a first aspect, the present invention discloses an intermediate management method capable of selecting a management strategy, comprising: According to the connection requirements of the user end, a matching policy backend object is selected from the set of stored policy backend objects to connect to the server end; wherein the policy backend object can connect the user end with the corresponding server end according to the set management policy; If no policy backend object is matched in the set of stored policy backend objects, a new policy backend object is created according to the connection requirements of the user end and the new policy backend object is used to connect to the server end; Add the new policy backend object to the existing policy backend object collection; Deletes policy backend objects in the policy backend object collection that have been unused for longer than the threshold.

[0005] In another embodiment of the present invention, according to the connection requirement of the user end, a matching policy backend object is selected from a set of stored policy backend objects to connect to the server end, including: the connection requirement of the user end matches the policy backend object with the same connection requirement.

[0006] In another embodiment of the present invention, according to the connection requirements of the user side, a matching policy backend object is selected from a set of stored policy backend objects to connect to the server side, including: the connection requirements of the user side are matched according to a snapshot of the policy backend object, wherein the snapshot includes: connection requirement attribute information, time attribute information and usage attribute information of the policy backend object, wherein the connection requirement attribute information is used to record the connection requirements of the policy backend object, the usage attribute information is used to record whether the policy backend object is being used, and the time attribute information is used to record the time when the policy backend object was last stopped being used.

[0007] In another embodiment of the present invention, deleting policy backend objects in a policy backend object set that exceed an unused time threshold includes: screening out policy backend objects that are not in use, and deleting policy backend objects that exceed an unused time threshold among the policy backend objects that are not in use based on time attribute information.

[0008] In another embodiment of the present invention, according to the connection requirement of the user end, a matching policy backend object is selected from a set of stored policy backend objects to connect to the server end, including: setting a monitoring module, which can obtain the connection requirement of the user end.

[0009] In another embodiment of the present invention, the method further includes: setting a status query module, the status query module being able to query the policy backend objects in the set of stored policy backend objects.

[0010] In another embodiment of the present invention, a new policy backend object is established according to the connection requirements of the user end and is used to connect to the server end, including: selecting a corresponding management policy according to the connection requirements of the user end and generating a new policy backend object.

[0011] In a second aspect, the present invention discloses an intermediate management device capable of selecting a management strategy, the device comprising: A selection module is used to select a matching policy backend object from a set of stored policy backend objects to connect to the server according to the connection requirements of the user end; wherein the policy backend object can connect the user end with the corresponding server end according to the set management policy; A creation module, used for creating a new policy backend object and connecting to the server end using the new policy backend object according to the connection requirements of the user end if no policy backend object is matched in the set of stored policy backend objects; A supplement module, used to add a new policy backend object to the set of existing policy backend objects; The deletion module is used to delete the policy backend objects in the policy backend object collection that have exceeded the unused time threshold.

[0012] In a third aspect, the present invention discloses an electronic device, comprising: one or more processors; a storage device for storing one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors execute the above method.

[0013] In a fourth aspect, the present invention discloses a computer program product, including a computer program, which implements the above method when executed by a processor.

[0014] Compared with the prior art, the present invention has the following advantages: The present invention discloses an intermediate management method, device, equipment and product capable of selecting management policies. According to the connection requirements of the user side, a matching policy backend object can be selected from a set of stored policy backend objects to connect to the server side, thereby realizing the connection between the user side capable of selecting the management policy and the server side. In addition, according to the connection requirements of the user side, a new policy backend can be established and policy backend objects that have not been used for a long time can be deleted. The diversified needs of the user side can be met through personalized and controllable policy settings. The method has the characteristics of high transparency of the connection between the user side and the server side, strong adaptability of the management policy and small redundant space occupation. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] The accompanying drawings, which constitute a part of the present invention, are used to provide a further understanding of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute improper limitations on the present invention.

[0016] In the attached picture: Figure 1 A schematic diagram of an application scenario of an intermediate management method capable of selecting a management strategy according to an embodiment of the present invention; Figure 2 A schematic diagram of an intermediate management method capable of selecting a management strategy according to an embodiment of the present invention; Figure 3 A snapshot diagram of a strategy backend object of an intermediate management method capable of selecting a management strategy according to an embodiment of the present invention; Figure 4 A schematic diagram of an intermediate management device capable of selecting a management strategy according to an embodiment of the present invention; Figure 5 The figure is a schematic diagram of an intermediate management electronic device capable of selecting a management strategy according to an embodiment of the present invention. DETAILED DESCRIPTION

[0017] It should be noted that, in the absence of conflict, the embodiments of the present invention and the features in the embodiments may be combined with each other.

[0018] In the description of the present invention, it should be noted that, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium, or it can be the internal communication of two components. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood by specific circumstances.

[0019] In the description of the present invention, it should be further explained that the terms "first", "second", etc. are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, a feature defined as "first", "second", etc. may explicitly or implicitly include one or more of the features. In the description of the present invention, unless otherwise specified, "plurality" means two or more.

[0020] The present invention discloses an intermediate management method, device, equipment and product application scenarios capable of selecting a management strategy. Figure 1 As shown, under the existing technical conditions, when the user end connects to the server end as needed, the connection is generally made through an intermediate management tool set with a management strategy, but the existing intermediate management methods generally have the problem of only being able to set a relatively unified connection management strategy according to the needs, and the management effect is very limited, and the maintenance cost is high and the update speed is slow. The present invention discloses an intermediate management method, device, equipment and product capable of selecting a management strategy, which can select a matching policy backend object from a set of stored policy backend objects to connect to the server end according to the connection requirements of the user end, realize the connection between the user end capable of selecting the management strategy and the server end, and can establish a new policy backend and delete policy backend objects that have not been used for a long time according to the connection requirements of the user end, and has the characteristics of high transparency of the connection between the user end and the server end, strong adaptability of the management strategy and small redundant space occupation.

[0021] The present invention will be described in detail below with reference to the accompanying drawings and in conjunction with embodiments.

[0022] In one embodiment disclosed in the present invention, Figure 2 As shown, an intermediate management method capable of selecting a management strategy includes: Step S201, according to the connection requirements of the user end, select a matching policy backend object from the set of stored policy backend objects to connect to the server end; wherein the policy backend object can connect the user end and the corresponding server end according to the set management policy; In this embodiment, the connection requirement of the user end matches the policy backend object with the same connection requirement. Exemplarily, the user end uses the policy backend object with the same connection requirement to connect to the server end, and this policy backend object connects the user end and the corresponding server end according to the set management policy for intermediate management.

[0023] The policy backend object is an intermediate management object that can connect the client side with the corresponding server side according to the set management policy.

[0024] In this embodiment, a monitoring module is provided, and the monitoring module can obtain the connection demand of the user end.

[0025] Further, according to the connection requirement of the user side, a matching policy backend object is selected from the set of stored policy backend objects to connect to the server side, that is, a policy backend object with the same connection requirement is selected to connect to the server side.

[0026] In this embodiment, a status query module is set, which can query the policy backend objects in the stored policy backend object set, including how many policy backend objects are in the current stored policy backend object set, whether they are in use, and the user end and server end bound to each policy backend object.

[0027] Exemplarily, the set of stored policy backend objects is used as a policy backend object pool to facilitate selection and matching of connection requirements of the user end.

[0028] Step S202: if no policy backend object is matched in the set of stored policy backend objects, a new policy backend object is created according to the connection requirement of the user end and the new policy backend object is used to connect to the server end; In this embodiment, according to the connection requirements of the user end, a corresponding management policy is selected to generate a new policy backend object.

[0029] In this embodiment, a server-side status module is provided to monitor the status of the cluster server and provide support for generating a new policy backend object.

[0030] Exemplarily, a corresponding management policy may be selected according to the connection requirements of the user end, and a policy backend object suitable for the connection requirements of the user end may be generated.

[0031] Step S203, adding the new policy object to the existing policy backend object set; Step S204: deleting the policy backend objects in the policy backend object set whose unused time exceeds the threshold.

[0032] In this embodiment, this method can select a matching policy backend object from a set of stored policy backend objects to connect to the server side according to the connection requirements of the user side, thereby realizing the connection between the user side and the server side that can select the management policy, and can establish a new policy backend and delete policy backend objects that have not been used for a long time according to the connection requirements of the user side, effectively reducing redundancy, and has the characteristics of high transparency of the connection between the user side and the server side and flexible matching of management policies.

[0033] Based on the previous embodiment, in another embodiment of the present invention, Figure 2 and Figure 3 As shown, step S201 also includes: the connection requirements of the user side are matched according to the snapshot of the policy backend object, wherein the snapshot includes: connection requirement attribute information, time attribute information and usage attribute information of the policy backend object, wherein the connection requirement attribute information is used to record the connection requirements of the policy backend object, the usage attribute information is used to record whether the policy backend object is being used, and the time attribute information is used to record the time when the policy backend object was last stopped being used.

[0034] In this embodiment, when the policy backend object has not been used for a period of time, the time attribute information and usage attribute information corresponding to the policy backend object are updated.

[0035] In this embodiment, if the connection requirement of the user end is the same as the connection requirement recorded in the connection requirement attribute information of the policy backend object, the two are matched successfully.

[0036] In this embodiment, matching is performed based on the snapshot of the policy backend object, which can effectively improve the matching efficiency between the connection requirements of the user end and the policy backend object.

[0037] Based on the previous embodiment, in another embodiment of the present invention, policy backend objects in a policy backend object set that exceed an unused time threshold are deleted, including: screening out policy backend objects that are not in use, and based on time attribute information, deleting policy backend objects that exceed an unused time threshold among the policy backend objects that are not in use.

[0038] In this embodiment, the policy backend objects that are not in use are screened out and the policy backend objects that exceed the unused time threshold are deleted, which can effectively reduce the redundancy of the policy backend object set while avoiding the impact on the policy backend objects in use.

[0039] In this embodiment, the policy backend objects in the policy backend object set are managed hierarchically. The first level screening is performed first, and then the second level screening is performed on the first level screening results. The first level is the screening of usage attributes to screen out unused policy backend objects; the second level is the screening of time attributes to continue screening out policy backend objects that have not been used for a long time, and finally the screened policy backend objects are deleted to achieve the effect of removing redundancy.

[0040] Exemplarily, the management policy of the policy backend object may be one or more of the following policies: 1. Session persistence strategy: Under the session persistence strategy, when an exception occurs on the server side, it can be transparently shielded on the user side. The user side only perceives a short period of lag and can continue to perform subsequent operations after the server side recovers. This strategy improves the user experience in the event of an exception on the server side, such as a database exception.

[0041] 2. Read-write separation strategy: Under the read-write separation strategy, the performance and scalability of the database are effectively improved by distributing the read and write operations of the database to different servers. Write operations are usually processed by the master database to ensure data consistency and integrity, while read operations can be distributed to multiple slave databases to achieve load balancing and improve the system's reading ability and response speed. The read-write separation strategy not only reduces the burden on the master database, but also significantly improves the overall performance of the system by processing read requests in parallel. It is particularly suitable for application scenarios with more reads and less writes, such as online trading systems and content management systems.

[0042] 3. Load balancing strategy: Under the load balancing strategy, by dynamically monitoring the load of each server, requests are routed to servers with lower current loads to avoid overloading of a single server, thereby improving the system throughput and enhancing the system availability and reliability. Especially in high-concurrency scenarios, it can effectively prevent service degradation or failure caused by overloading of a single server.

[0043] 4. Circuit breaker strategy: Under the circuit breaker strategy, when a server, such as a server carrying a database, is overloaded or takes too long to respond, the circuit breaker will automatically trigger, temporarily cutting off certain operations or requests to the server to protect the stable operation of the database.

[0044] 5. Combined strategy: Under the combined strategy, each tenant can have its own independent data and business logic. Multiple tenants can share an application instance, but the data and operations are completely isolated. When each request is processed, the context information of the current tenant is set to ensure that all database operations contain the correct tenant ID. In the case of multiple database instances, the data source is dynamically selected based on the tenant ID. When a tenant's data needs to be queried, the query statement will add the tenant identifier tenant_id in the WHERE clause.

[0045] 6. Co-tenancy strategy: Under the co-tenancy strategy, each tenant can have its own independent data part or a common data part, so that multiple tenants can share an application instance, but data and operations can be isolated and shared according to needs. When you need to query a tenant's unique data, the query statement will add the tenant identifier tenant_id in the WHERE clause. When you need to query the common data part, you do not need to add the tenant identifier.

[0046] like Figure 4 As shown, the present invention also discloses an intermediate management device capable of selecting a management strategy, the device comprising: The selection module 401 is used to select a matching policy backend object from the set of stored policy backend objects to connect to the server according to the connection requirements of the user end; wherein the policy backend object can connect the user end with the corresponding server end according to the set management policy; Establishing module 402, for establishing a new policy backend object and connecting to the server end using the new policy backend object according to the connection requirements of the user end if no policy backend object is matched in the set of stored policy backend objects; A supplement module 403 is used to supplement the new policy backend object into the set of existing policy backend objects; The deleting module 404 is used to delete the policy backend objects in the policy backend object set that have exceeded the unused time threshold.

[0047] The present invention also discloses an electronic device, such as Figure 5 As shown, an embodiment is disclosed, which is a block diagram of an intermediate management electronic device capable of selecting a management policy.

[0048] The electronic device 50 of this embodiment includes a processor 501, which can perform various appropriate actions and processes according to the program stored in the ROM 502 or the program loaded from the storage part 508 to the RAM 503. The processor 501 may include, for example, a general-purpose microprocessor, an instruction set processor and / or a related chipset and / or a dedicated microprocessor, etc. The processor 501 may also include an onboard memory for caching purposes. The processor 501 may include a single processing unit or multiple processing units for performing different actions of the method flow according to the embodiment of the present invention.

[0049] In RAM503, various programs and data required for the operation of electronic device 50 are stored. Processor 501, ROM502 and RAM503 are connected to each other via bus 504, and processor 501 performs various operations of the method flow according to the embodiment of the present invention by executing the program in ROM502 and / or RAM503. It should be noted that the program can also be stored in one or more memories other than ROM502 and RAM503, and processor 501 can also perform various operations of the method flow according to the embodiment of the present invention by executing the program stored in one or more memories.

[0050] According to an embodiment of the present invention, the electronic device 50 may further include an I / O interface 505, which is also connected to the bus 504. The electronic device 50 may further include one or more of the following components connected to the I / O interface 505: an input portion 506 including a keyboard, a mouse, etc.; an output portion 507 including a cathode ray tube, a liquid crystal display, and a speaker; a storage portion 508 including a hard disk, etc.; and a communication portion 509 including a network interface card such as a LAN card, a modem, etc. The communication portion 509 performs communication processing via a network such as the Internet. A drive 5010 is also connected to the I / O interface 505 as needed. A removable medium 5011, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 5010 as needed, so that a computer program read therefrom is installed into the storage portion 508 as needed.

[0051] The present invention also provides a computer-readable storage medium.

[0052] The computer-readable storage medium may be included in the electronic device / device system described in the above embodiment; or it may exist independently without being assembled into the electronic device / device. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed, the method according to the embodiment of the present invention is implemented.

[0053] According to an embodiment of the present invention, the computer-readable storage medium may be a non-volatile computer-readable storage medium. For example, it may include but is not limited to: a portable computer disk, a hard disk, a random access memory RAM, a read-only memory ROM, an erasable programmable read-only memory EPROM or a flash memory, a portable compact disk read-only memory CD ROM, an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present invention, the computer-readable storage medium may be any tangible medium containing or storing a program, which may be used by or in combination with an instruction execution system, an apparatus, or a device.

[0054] Embodiments of the present invention also include a computer program product.

[0055] The computer program product includes a computer program, which contains program codes for executing the method provided by the embodiment of the present invention. When the computer program product runs on an electronic device, the program codes are used to enable the electronic device to implement the method provided by the embodiment of the present invention.

[0056] In one embodiment, the computer program may rely on a tangible storage medium such as an optical storage device or a magnetic storage device. In another embodiment, the computer program may also be transmitted and distributed in the form of a signal on a network medium. The program code included in the computer program may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the above.

[0057] According to an embodiment of the present invention, the program code for executing the computer program provided by the embodiment of the present invention can be written by any combination of one or more programming languages, and specifically, these computing programs can be implemented using high-level process and / or object-oriented programming languages. Programming languages ​​include but are not limited to programming languages ​​such as Java, C++, python, C language or similar. The program code can be executed completely on the user computing device, partially on the user device, partially on the remote computing device, or completely on the remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the user computing device through any type of network, including a local area network or a wide area network, or can be connected to an external computing device.

[0058] The flowcharts and block diagrams in the accompanying drawings illustrate the possible architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present invention. In this regard, each box in the flowchart or block diagram may represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of the code contains one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box may also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flowchart, and the combination of boxes in the block diagram or flowchart, can be implemented with a dedicated hardware-based system that performs the specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions. It can be understood by those skilled in the art that the features recorded in the various embodiments and / or claims of the present invention can be combined and / or combined in various ways, even if such a combination or combination is not explicitly recorded in the present invention. In particular, without departing from the spirit and teachings of the present invention, the features described in the various embodiments and / or claims of the present invention may be combined and / or combined in a variety of ways. All of these combinations and / or combinations fall within the scope of the present invention.

[0059] The embodiments of the present invention are described above. However, these embodiments are only for the purpose of illustration, and are not intended to limit the scope of the present invention. Although the embodiments are described above, this does not mean that the measures in the various embodiments cannot be used in combination. The scope of the present invention is limited by the attached claims and their equivalents. Without departing from the scope of the present invention, those skilled in the art may make various substitutions and modifications, which should all fall within the scope of the present invention.

Claims

1. An intermediate management method capable of selecting a management strategy, characterized in that: include: According to the connection requirements of the user end, a matching policy backend object is selected from the set of stored policy backend objects to connect to the server end; wherein the policy backend object can connect the user end with the corresponding server end according to the set management policy; If the policy backend object is not matched in the set of stored policy backend objects, a new policy backend object is created according to the connection requirement of the user end and the new policy backend object is used to connect to the server end; Adding the new policy backend object to the set of existing policy backend objects; The policy backend objects in the policy backend object set that have exceeded an unused time threshold are deleted.

2. The intermediate management method capable of selecting a management strategy according to claim 1, characterized in that: The selecting, according to the connection requirement of the user end, the matching policy backend object from the stored policy backend object set to connect to the server end includes: the connection requirement of the user end matches the policy backend object with the same connection requirement.

3. The intermediate management method capable of selecting a management strategy according to claim 2, characterized in that: The method of selecting a matching policy backend object from a set of stored policy backend objects to connect to a server side based on the connection requirements of the user side includes: matching the connection requirements of the user side based on a snapshot of the policy backend object, wherein the snapshot includes: connection requirement attribute information, time attribute information and usage attribute information of the policy backend object, wherein the connection requirement attribute information is used to record the connection requirement of the policy backend object, the usage attribute information is used to record whether the policy backend object is being used, and the time attribute information is used to record the time when the policy backend object was last stopped being used.

4. The intermediate management method capable of selecting a management strategy according to claim 3, characterized in that: The deleting the policy backend objects in the policy backend object set that exceed the unused time threshold includes: screening out the policy backend objects that are not in use, and based on the time attribute information, deleting the policy backend objects that exceed the unused time threshold among the policy backend objects that are not in use.

5. The intermediate management method capable of selecting a management strategy according to claim 1, characterized in that: The method of selecting a matching policy backend object from a set of stored policy backend objects to connect to a server according to a connection requirement of the user end includes: setting a monitoring module, wherein the monitoring module can obtain the connection requirement of the user end.

6. The intermediate management method capable of selecting a management strategy according to claim 1, characterized in that: The method further includes: setting a status query module, wherein the status query module can query the policy backend object in the set of stored policy backend objects.

7. The intermediate management method capable of selecting a management strategy according to claim 1, characterized in that: The step of establishing a new policy backend object according to the connection requirements of the user end and connecting to the server end using the new policy backend object comprises: selecting a corresponding management policy according to the connection requirements of the user end and generating the new policy backend object.

8. An intermediate management device capable of selecting a management strategy, characterized in that: The device comprises: A selection module, used to select a matching policy backend object from a set of stored policy backend objects to connect to a server according to a connection requirement of a user end; wherein the policy backend object can connect the user end with the corresponding server end according to a set management policy; An establishing module, used for establishing a new policy backend object according to the connection requirement of the user end and connecting to the server end by using the new policy backend object if the policy backend object is not matched in the set of stored policy backend objects; A supplement module, used to supplement the new policy backend object into the set of existing policy backend objects; The deleting module is used to delete the policy backend objects in the policy backend object set that have exceeded an unused time threshold.

9. An electronic device, characterized in that: include: one or more processors; A storage device for storing one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors are caused to perform the method according to any one of claims 1 to 7.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the method according to any one of claims 1 to 7 is implemented.

Images