CN117785477A

CN117785477A - Distributed database service request execution method, device, electronic equipment and medium

Info

Publication number: CN117785477A
Application number: CN202410064271.7A
Authority: CN
Inventors: 庞艺伟; 陶征霖; 常雷; 姚佳丽; 霍瑞龙; 刘大伟; 宋宜旭
Original assignee: Beijing Even Number Technology Co ltd
Current assignee: Beijing Even Number Technology Co ltd
Priority date: 2024-01-16
Filing date: 2024-01-16
Publication date: 2024-03-29

Abstract

The embodiment of the disclosure discloses a distributed database service request execution method, a distributed database service request execution device, electronic equipment and a distributed database service request execution medium. One embodiment of the method comprises the following steps: in response to determining that the source node has a target service request, determining a target node for executing the target service request in a target subnet according to the target service request; the control source node sends a target service request to the target node; the control target node performs the target service request. According to the embodiment, accuracy, performance and flexibility are comprehensively considered, and according to specific requirements on performance and stability, the proportion and retry mechanism of the corresponding detection seed nodes are configured, so that performance and robustness can be balanced and flexibly adjusted.

Description

Distributed database service request execution method, device, electronic equipment and medium

Technical Field

Embodiments of the present disclosure relate to the field of computer technology, and in particular, to a method, an apparatus, an electronic device, and a computer readable medium for executing a distributed database service request.

Background

Distributed database systems or other distributed applications typically have multiple nodes that are linked together by a network to work cooperatively to handle daily transactions, such as the execution of SQL. The number of these nodes varies from a few to thousands to tens of thousands, often being relatively complex to distribute, possibly across multiple subnets. Because of the need for daily operation, a source node of the system needs to know the reachability and links (directly or indirectly) of the network of some target nodes at any time, and when network interaction with the target nodes is needed, a network request is sent through the already ascertained links. The significance of such reachability link probing is especially important in cases where the system network is not very stable.

However, the network reachability detection mechanism in the prior art is too limited, when the network is directly connected and not connected in a cross-subnet environment, an indirect network reachability link is difficult to find, the performance is poor, multiple attempts are often required to find the reachable link by using an indifferently searching agent mode, a retry mechanism is not provided, the robustness of the scheme is poor, and once the network has short fluctuation, the network detection result is influenced.

Disclosure of Invention

The disclosure is in part intended to introduce concepts in a simplified form that are further described below in the detailed description. The disclosure is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used to limit the scope of the claimed subject matter.

Some embodiments of the present disclosure propose a distributed database service request execution method, apparatus, electronic device, and computer readable medium to solve the technical problems mentioned in the background section above.

In a first aspect, some embodiments of the present disclosure provide a distributed database service request execution method, the method including: in response to determining that a source node has a target service request, determining a target node for executing the target service request in a target subnet according to the target service request; controlling the source node to send the target service request to the target node; and controlling the target node to execute the target service request.

In a second aspect, some embodiments of the present disclosure provide a distributed database service request execution apparatus, the apparatus including: a determining unit configured to determine, in response to determining that a target service request exists for a source node, a target node that performs the target service request in a target subnet according to the target service request; a transmitting unit configured to control the source node to transmit the target service request to the target node; and an execution unit configured to control the target node to execute the target service request.

In a third aspect, an embodiment of the present application provides an electronic device, including: one or more processors; a storage means for storing one or more programs; the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method as described in any of the implementations of the first aspect.

In a fourth aspect, embodiments of the present application provide a computer readable medium having stored thereon a computer program which, when executed by a processor, implements a method as described in any of the implementations of the first aspect.

One of the above embodiments of the present disclosure has the following advantageous effects:

drawings

The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent by reference to the following detailed description when taken in conjunction with the accompanying drawings. The same or similar reference numbers will be used throughout the drawings to refer to the same or like elements. It should be understood that the figures are schematic and that elements and components are not necessarily drawn to scale.

FIG. 1 is a flow chart of some embodiments of a distributed database service request execution method according to the present disclosure;

FIG. 2 is a schematic diagram of the architecture of some embodiments of a distributed database service request execution apparatus according to the present disclosure;

fig. 3 is a schematic structural diagram of an electronic device suitable for use in implementing some embodiments of the present disclosure.

Detailed Description

Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete. It should be understood that the drawings and embodiments of the present disclosure are for illustration purposes only and are not intended to limit the scope of the present disclosure.

It should be noted that, for convenience of description, only the portions related to the present invention are shown in the drawings. Embodiments of the present disclosure and features of embodiments may be combined with each other without conflict.

It should be noted that the terms "first," "second," and the like in this disclosure are merely used to distinguish between different devices, modules, or units and are not used to define an order or interdependence of functions performed by the devices, modules, or units.

It should be noted that references to "one", "a plurality" and "a plurality" in this disclosure are intended to be illustrative rather than limiting, and those of ordinary skill in the art will appreciate that "one or more" is intended to be understood as "one or more" unless the context clearly indicates otherwise.

The names of messages or information interacted between the various devices in the embodiments of the present disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.

The present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.

Referring to fig. 1, a flow 100 of some embodiments of a distributed database service request execution method according to the present disclosure is shown. The method for executing the distributed database service request comprises the following steps:

in step 101, in response to determining that a source node has a target service request, determining a target node executing the target service request in a target subnet according to the target service request.

In some embodiments, in response to determining that a source node has a target service request, an execution body (e.g., a server) of a distributed database service request execution method may determine, in a target subnet, a target node that executes the target service request according to the target service request.

Here, the source node generally refers to a node that does not belong to the target subnet. The target subnetwork generally refers to a subnetwork comprising target nodes for executing service requests. The target node generally refers to a node capable of executing the target service request.

It is to be understood that the method for executing the distributed database service request may be executed by a terminal device, or may be executed by a server, and the execution body of the method may also include a device formed by integrating the terminal device and the server through a network, or may also be executed by various software programs. The terminal device may be, among other things, various electronic devices with information processing capabilities including, but not limited to, smartphones, tablet computers, electronic book readers, laptop and desktop computers, and the like. The execution body may also be embodied as a server, software, or the like. When the execution subject is software, the execution subject can be installed in the electronic device enumerated above. It may be implemented as a plurality of software or software modules, for example, for providing distributed services, or as a single software or software module. The present invention is not particularly limited herein.

Step 102, controlling the source node to send the target service request to the target node.

In some embodiments, the executing entity (e.g., a server) may control the source node to send the target service request to the target node.

In some optional implementations of some embodiments, the executing body may determine whether a link connection exists between the source node and the target subnet; determining a proxy node of the source node in the target subnet in response to determining that a link connection exists between the source node and the target subnet; and controlling the source node to send the target service request to the target node through the proxy node.

Here, the above-mentioned link connection generally means that there is a connection relationship. The proxy node is generally a node connected to the target node and having a data transmission/reception function.

In some optional implementations of some embodiments, the executing body may determine whether a link connection exists between the source node and the target subnet; determining whether the target node is a seed node in response to determining that the source node and the target subnet are not in link connection; and in response to determining that the target node is a seed node, controlling the source node to send the target service request to the target node.

Here, the seed node generally refers to a node having communication capability outside the communication range of the target subnet.

In some optional implementations of some embodiments, the executing body may determine whether a link connection exists between the source node and the target subnet; determining whether the target node is a seed node in response to determining that the source node and the target subnet are not in link connection; determining a set of seed nodes in the target subnet in response to determining that the target node is not a seed node; for each seed node in the seed node set, controlling the seed node to be in link connection with the source node until the seed node set has a seed node which establishes link connection with the source node; and taking the seed nodes which are in the set of the child nodes and establish link connection with the source node as proxy nodes, and controlling the source node to send the target service request to the target node through the proxy nodes.

As an example, the above-described execution subject may implement a distributed database service request execution method by:

1. firstly, configuring seed nodes of each subnet, and configuring the ratio of the retry times to the seed nodes to be used.

2. Attempts to directly link the target node from the source node (e.g., attempts to establish a TCP link).

If successful, the link is recorded and ended. The link is then prioritized if a network request needs to be sent from the source node to the target node.

If the number of retries fails, the step 2 is retried according to the configured number of retries until the number of retries reaches the configured maximum number of retries.

3. If the retry number is used up or fails, an attempt is made to select a seed node that has not been used as an agent from the seed nodes.

4. The target node is de-linked by the seed node acting as a proxy.

If successful, the link is recorded and ended.

If the test fails, the step 4 is retried until the number of retries reaches the configured maximum number of retries.

5. If the number of retries still fails after the maximum number of retries is reached, repeating the steps 3 and 4 until the number of the used seed nodes reaches the configured use proportion.

6. If no reachable link is found finally, the target node is recorded as in the "unreachable" state and ends.

Step 103, controlling the target node to execute the target service request.

In some embodiments, the executing entity may control the target node to execute the target service request.

One of the above embodiments of the present disclosure has the following advantageous effects: in the sub-network where the target node is located, some nodes are designated as seed nodes of the network proxy manually or through automatic rules, the seed nodes generally have the characteristics of management network cards and the like, the possibility of being communicated by other sub-networks is higher, and according to specific requirements on performance and stability, the proportion and retry mechanism of the corresponding detection seed nodes are configured, so that the performance and the robustness can be balanced and flexibly adjusted.

With further reference to fig. 2, as an implementation of the method shown in the foregoing figures, the present disclosure provides some embodiments of a distributed database service request execution apparatus, which correspond to those method embodiments shown in fig. 2, and which are particularly applicable to various electronic devices.

As shown in fig. 2, the distributed database service request execution apparatus 200 of some embodiments includes: a determining unit 201, a transmitting unit 202, and an executing unit 203. Wherein, the determining unit 201 is configured to determine, in response to determining that the source node has a target service request, a target node performing the target service request in a target subnet according to the target service request; a transmitting unit 202 configured to control the source node to transmit the target service request to the target node; an execution unit 203 configured to control the target node to execute the target service request.

It will be appreciated that the elements described in the apparatus 200 correspond to the various steps in the method described with reference to fig. 2. Thus, the operations, features and resulting benefits described above for the method are equally applicable to the apparatus 200 and the units contained therein, and are not described in detail herein.

Referring now to fig. 3, a schematic diagram of an architecture of an electronic device (e.g., an execution body server of a distributed database service request execution method) 300 suitable for use in implementing some embodiments of the present disclosure is shown. The electronic device shown in fig. 3 is merely an example and should not impose any limitations on the functionality and scope of use of embodiments of the present disclosure.

As shown in fig. 3, the electronic device 300 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 301 that may perform various suitable actions and processes in accordance with a program stored in a Read Only Memory (ROM) 302 or a program loaded from a storage means 308 into a Random Access Memory (RAM) 303. In the RAM 303, various programs and data required for the operation of the electronic apparatus 300 are also stored. The processing device 301, the ROM 302, and the RAM 303 are connected to each other via a bus 304. An input/output (I/O) interface 305 is also connected to bus 304.

In general, the following devices may be connected to the I/O interface 305: input devices 306 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; an output device 307 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 308 including, for example, magnetic tape, hard disk, etc.; and communication means 309. The communication means 309 may allow the electronic device 300 to communicate with other devices wirelessly or by wire to exchange data. While fig. 3 shows an electronic device 300 having various means, it is to be understood that not all of the illustrated means are required to be implemented or provided. More or fewer devices may be implemented or provided instead. Each block shown in fig. 3 may represent one device or a plurality of devices as needed.

In particular, according to some embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, some embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flow chart. In such embodiments, the computer program may be downloaded and installed from a network via communications device 309, or from storage device 308, or from ROM 302. The above-described functions defined in the methods of some embodiments of the present disclosure are performed when the computer program is executed by the processing means 301.

It should be noted that, in some embodiments of the present disclosure, the computer readable medium may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

In some embodiments of the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In some embodiments of the present disclosure, however, the computer-readable signal medium may comprise a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing.

A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.

In some implementations, the clients, servers may communicate using any currently known or future developed network protocol, such as HTTP (HyperText Transfer Protocol ), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the internet (e.g., the internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed networks.

The computer readable medium may be contained in the electronic device; or may exist alone without being incorporated into the electronic device. The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: in response to determining that a source node has a target service request, determining a target node for executing the target service request in a target subnet according to the target service request; controlling the source node to send the target service request to the target node; and controlling the target node to execute the target service request.

Computer program code for carrying out operations for some embodiments of the present disclosure may be written in one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).

The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The units described in some embodiments of the present disclosure may be implemented by means of software, or may be implemented by means of hardware. The described units may also be provided in a processor, for example, described as: a processor includes a determination unit, a transmission unit, and an execution unit. Wherein the names of the units do not constitute a limitation of the unit itself in some cases, for example, the determining unit may also be described as "in response to determining that the source node has a target service request, determining a target node executing the target service request in the target subnet according to the target service request".

The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: a Field Programmable Gate Array (FPGA), an Application Specific Integrated Circuit (ASIC), an Application Specific Standard Product (ASSP), a system on a chip (SOC), a Complex Programmable Logic Device (CPLD), and the like.

The foregoing description is only of the preferred embodiments of the present disclosure and description of the principles of the technology being employed. It will be appreciated by those skilled in the art that the scope of the invention in the embodiments of the present disclosure is not limited to the specific combination of the above technical features, but encompasses other technical features formed by any combination of the above technical features or their equivalents without departing from the spirit of the invention. Such as the above-described features, are mutually substituted with (but not limited to) the features having similar functions disclosed in the embodiments of the present disclosure.

Claims

1. A distributed database service request execution method, comprising:

in response to determining that a source node has a target service request, determining a target node for executing the target service request in a target subnet according to the target service request;

controlling the source node to send the target service request to the target node;

and controlling the target node to execute the target service request.

2. The method of claim 1, wherein the controlling the source node to send the target service request to the target node comprises:

determining whether a link connection exists between the source node and the target subnet;

determining a proxy node of the source node in the target subnet in response to determining that a link connection exists between the source node and the target subnet;

and controlling the source node to send the target service request to the target node through the proxy node.

3. The method of claim 2, wherein the controlling the source node to send the target service request to the target node comprises:

determining whether the target node is a seed node in response to determining that no link connection exists between the source node and the target subnet;

and in response to determining that the target node is a seed node, controlling the source node to send the target service request to the target node.

4. The method of claim 3, wherein the controlling the source node to send the target service request to the target node comprises:

in response to determining that the target node is not a seed node, determining a set of seed nodes in the target subnet;

for each seed node in the seed node set, controlling the seed node to be in link connection with the source node until the seed node set has the seed node for establishing link connection with the source node;

and taking the seed node which establishes link connection with the source node in the sub-node set as a proxy node, and controlling the source node to send the target service request to the target node through the proxy node.

5. An apparatus for distributed database service request execution, comprising:

a determining unit configured to determine, in response to determining that a source node has a target service request, a target node that performs the target service request in a target subnet according to the target service request;

a transmitting unit configured to control the source node to transmit the target service request to the target node;

an execution unit configured to control the target node to execute the target service request.

6. The apparatus of claim 5, wherein the transmitting means is further configured to:

7. The apparatus of claim 6, wherein the transmitting means is further configured to:

8. The apparatus of claim 7, wherein the transmitting means is further configured to:

9. An electronic device, comprising:

one or more processors;

a storage device having one or more programs stored thereon,

when executed by the one or more processors, causes the one or more processors to implement the method of any of claims 1-4.

10. A computer readable medium having stored thereon a computer program, wherein the program when executed by a processor implements the method of any of claims 1-4.