WO2016032803A1 - Dynamic load-based merging - Google Patents

Dynamic load-based merging Download PDF

Info

Publication number
WO2016032803A1
WO2016032803A1 PCT/US2015/045747 US2015045747W WO2016032803A1 WO 2016032803 A1 WO2016032803 A1 WO 2016032803A1 US 2015045747 W US2015045747 W US 2015045747W WO 2016032803 A1 WO2016032803 A1 WO 2016032803A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
server group
merging
server
computing device
Prior art date
Application number
PCT/US2015/045747
Other languages
French (fr)
Inventor
Zhenkun Yang
Zhidong SUN
Hu XU
Original Assignee
Alibaba Group Holding Limited
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Priority claimed from CN201410429616.0A external-priority patent/CN105446653B/en
Application filed by Alibaba Group Holding Limited filed Critical Alibaba Group Holding Limited
Priority to ES15836188T priority Critical patent/ES2845654T3/en
Priority to EP15836188.1A priority patent/EP3186760B8/en
Priority to SG11201700190WA priority patent/SG11201700190WA/en
Priority to JP2017502114A priority patent/JP6412244B2/en
Priority to KR1020177005030A priority patent/KR101938501B1/en
Priority to PL15836188T priority patent/PL3186760T3/en
Publication of WO2016032803A1 publication Critical patent/WO2016032803A1/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0631Resource planning, allocation, distributing or scheduling for enterprises or organisations
    • G06Q10/06314Calendaring for a resource
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/34Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3409Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
    • G06F11/3433Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment for load management

Abstract

One embodiment of the present invention provides a system for facilitating dynamic load-based merging. During operation, the system identifies incremental data in memory of a first computing device. The incremental data comprises update to reference data in a storage device in a second computing device. If the size of the incremental data becomes greater than a threshold, the system selects a first server group from a plurality of server groups. The second computing device belongs to this first server group. The system then migrates data access requests from the first server group to other server groups in the plurality of server groups and merges the incremental data from the memory of the first computing device to the storage device in the second computing device. The merging includes batch sequential disk writes to the storage device of the second computing device.

Description

DYNAMIC LOAD-BASED MERGING
Related Application
[0001] Under 35 U.S.C. 119, this application claims the benefit and right of priority of Chinese Patent Application No. 201410429616.0, filed 27 August 2014.
BACKGROUND
Field
[0002] The present application relates to the field of computer technologies, and in particular, to a method and system for data management.
Related Art
[0003] With the advancement of the computer and network technologies, various operations performed by the users from different applications lead to extensive storage allocation. For example, multiple users may concurrently shop on an e-commerce website via different applications, such as mobile applications running on different platforms as well as web- interfaces running on different browsers in different operating systems. The corresponding shopping records are stored in storage devices (e.g., in a database) of a system facilitating the e- commerce service.
[0004] However, different applications concurrently accessing the system can cause an increasing number of user activities, consequently, an increasing amount of user records are being stored in the system. A large number these records can be accessed by users while they are being updated. Hence, the stored data in the system needs to be continuously managed based on the access and update frequencies of the users. This management of stored data includes allocation of write operations to the data storage such a way that its impact is reduced to users' data access.
[0005] Although a number of methods are available for data management in a system, some problems still remain in efficient storage management for concurrent applications.
SUMMARY
[0006] One embodiment of the present invention provides a system for facilitating dynamic load-based merging. During operation, the system identifies incremental data in memory of a first computing device. The incremental data comprises update to reference data in a storage device in a second computing device. If the size of the incremental data becomes greater than a threshold, the system selects a first server group from a plurality of server groups. The second computing device belongs to this first server group. The system then migrates data access requests from the first server group to other server groups in the plurality of server groups and merges the incremental data from the memory of the first computing device to the storage device in the second computing device. The merging includes batch sequential disk writes to the storage device of the second computing device.
[0007] In a variation of this embodiment, the reference data is divided into a plurality of tablets, wherein a tablet is a non- overlapping segment of the reference data.
[0008] In a further variation, a respective server group of the plurality of server groups includes a copy of a respective tablet of the reference data.
[0009] In a variation of this embodiment, selecting the first server group from the plurality of server groups includes identifying the first server group from a sequence of server groups.
[0010] In a further variation, the system determines whether the merging of the incremental data have been performed for a respective server group and selects a server group for which the merging of the incremental data has not been performed.
[0011] In a variation of this embodiment, the system maintains a traffic control table comprising data access request traffic ratio of a respective server group of the plurality of server groups and determines whether the traffic ratio for the first server group has reached a threshold value in the traffic control table. If determined, the system determines the first server group to be ready for the merging.
[0012] In a variation of this embodiment, the system determines whether the merging is complete for the first server group. If determined, the system restores data access requests from the other server groups back to the first server group.
[0013] In a variation of this embodiment, the system determines whether the first server group is needed to serve data access requests during the merging of the incremental data and determines whether resource consumption by computing devices in the first server group satisfies a condition.
[0014] In a further variation, the system determines performance level associated with the data access requests served from the first server group. If the performance level being below a threshold, the system pauses the merging of the incremental data.
[0015] In a further variation, the system releases resources occupied by the merging of the incremental data for serving the data access requests. BRIEF DESCRIPTION OF THE FIGURES
[0016] The accompanying drawings herein, which are incorporated herein and constitute a part of the specification, illustrate several exemplary embodiments of the present application and together with the description, serve to illustrate the present application, construing no limitation to the present application. In the drawings:
[0017] FIG. 1A illustrates exemplary data management based on incremental and reference data, in accordance with an embodiment of the present application.
[0018] FIG. IB illustrates an exemplary data management system based on update and storage servers, in accordance with an embodiment of the present application.
[0019] FIG. 2 illustrates exemplary tablets of the reference data, in accordance with an embodiment of the present application.
[0020] FIG. 3A presents a flowchart illustrating a data management system initiating the merging process, in accordance with an embodiment of the present application.
[0021] FIG. 3B presents a flowchart illustrating the off-peak merging process of a data management system, in accordance with an embodiment of the present application.
[0022] FIG. 3C presents a flowchart illustrating the dynamically-controlled merging process of a data management system, in accordance with an embodiment of the present application.
[0023] FIG. 4 is a schematic structural diagram of an exemplary data management system, in accordance with an embodiment of the present application.
[0024] In the figures, like reference numerals refer to the same figure elements. DETAILED DESCRIPTION
[0025] Embodiments of the present invention solve the problem of efficiently managing data access by diverting data updates from the storage servers being accessed. If data access is unavoidable from those storage servers, data from the storage server is updated when the resources at the storage servers are available.
[0026] With existing technologies, data is typically stored in a Log-Structured Merge-
Tree (an LSM Tree). In an LSM tree, data are generally divided into multiple levels in memory and storage disk of a system. If data are updated (e.g., due to a user operation), that data are written into the memory of the system. However, data in the memory is volatile. Hence, the system writes the updated data of the memory to a disk file via a merging process. This merging process is usually performed in parallel with data access (i.e., data reading). The merging process is batch sequential disk writes. However, such merging process typically consumes a large quantity of input/output (I/O) resources, and directly affects the throughput and response time of the regular operations (e.g., online services) of the storage system. An online service is a service a system keeps operational. For example, availability and accessibility of a user's purchase records.
[0027] To solve this problem, embodiments of the present invention provides a system for dynamic load-based merging process by separating data access and update operations, and automatically diverting data access traffic from storage servers that are being currently updated. The system divides data into two sets of data, reference data and incremental data, for data update (e.g., the write operations) and data access (e.g., the read operations), respectively.
Incremental data reside in the memory of an update server, and update operations are performed on the incremental data. On the other hand, reference data are stored in disks of storage servers. Reference data usually have multiple copies in multiple storage servers to facilitate high availability. When the amount of data written into the memory of the update server reaches a threshold, the merging process is triggered. The incremental data in the memory is merged to the reference data on the disk of a corresponding storage server.
[0028] Furthermore, to ensure separation of data access from the merging process, the system maintains at least two server groups of storage servers, each set maintaining the entire reference data. When the merging process is performed for a first group, the data access requests are served from a second group. Upon completion of the merging process for the first group, the data access requests are diverted to the first group and the merging process is performed for the second group. As a result, during the merging process, the performance of the data access from the storage servers is not hindered. In some circumstances, due to high volume of data access traffic or a timeout event, some data access requests may be served from a group currently being merged. Under such circumstances, to reduce impact of the merging process, the system monitors the load of the storage servers, and allows the merging process to continue only when the load is low. Otherwise, the system initiates an overload prevention mode and pauses the merging process to recover the resources (e.g., network, processing, and I/O resources) allocated for the merging process.
[0029] FIG. 1A illustrates exemplary data management based on incremental and reference data, in accordance with an embodiment of the present application. In this example, a data management system 100 for dynamic load-based data merging is deployed to facilitate separation of data access and update operations. Suppose that the data includes incremental data 122, which resides in memory 112 of an update server 102. In some embodiments, incremental data 122 can be organized in a B-tree. On the other hand, reference data 124 reside on disks 114 and 116 of storage servers 104 and 106, respectively. Reference data is the persistent data stored on the disks and incremental data is the update (e.g., modification, addition, deletion, etc.) to the reference data. Storage servers 104 and 106 can host non-overlapping reference data blocks 126 and 128 of reference data 124, respectively. Data blocks 126 and 128 together represent reference data 124 in their entirety.
[0030] System 100 performs the updates (e.g., write operations) to reference data 124 on memory 112 to generate incremental data 122. As a result, during the update process, the write operations are not directly applied to storage servers 104 and 106. Hence, storage servers 104 and 106 can facilitate data access to a client device while reducing the impact of the write operations associated with the data update. When the amount of data written into memory 112 of update server 102 reaches a threshold, system 100 triggers the merging process. The merging process is batch sequential disk writes to disks 114 and/or 116. Thus, the merging process merges the updated data in memory 112 to reference data blocks 126 and/or 128 in disks 114 and/or 116 of storage servers 104 and/or 106, respectively. After the merging process, the updates in incremental data 122 become part of reference data 124. System 100 performs any subsequent updates on memory 122.
[0031] In some embodiments, to ensure separation of data access from the merging process, system 100 maintains at least two groups of storage servers, each group maintaining reference data 124 in their entirety. FIG. IB illustrates an exemplary data management system based on update and storage servers, in accordance with an embodiment of the present application. System 100 can group storage servers 104 and 106 into server group 142. System 100 can maintain another server group 144 comprising storage servers 134 and 136. Both groups 142 and 144 host reference data 124 in their entirety. This allows load balancing among the groups and separates data access from the merging process. In some embodiments, groups 142 and 144 can be in separate locations, separated by network 150 (e.g., a local or wide area network). Update server 102 can be coupled to groups 142 and 144 via network 150.
[0032] System 100 ensures separation of data access and the merging process between groups 142 and 144. System 100 uses groups 142 and 144 as the control units for the merging process and performs the merging process at different times. In the preparation stage of the merging process, system 100 selects a group for the merging process and migrates data access traffic (e.g., data access requests and/or corresponding data) to the other groups. In this way, the merging process and the online services are isolated from each other. When system 100 performs the merging process for group 142, system 100 diverts the data access traffic to group 144. For example, if client device 160 sends a data access request (e.g., request for a customer record), the data access request is served from group 144 (e.g., a corresponding storage server provides the requested data). After system 100 completes the merging process for group 142, system 100 migrates the data access traffic to group 142 and initiates the merging process for group 144. A subsequent request for data access from client device 160 is served from group 142. This merging process can be referred to as an off-peak merging process. The off-peak merging process reduces the impact of the merging of incremental data on the performance of the online services (e.g., the time taken for a storage server to serve a data access request).
[0033] In some embodiments, system 100 switches between groups 142 and 144 based on a traffic control table, which includes the data access traffic ratio between groups 142 and 144. The requests for data access from client devices (e.g., client device 160) are distributed to groups 142 and 144 based on the ratio. System 100 gradually migrates data access traffic from one group to another. In this way, the traffic ratio continues to increase for one group and decrease in another. For example, at one given time, if the ratio is 50:50, system 100 forwards 50% of the data access request to group 142 and the other 50% to group 144. If the merging process is needed, system 100 starts migrating data access traffic from one group to another based on a sequence (e.g., group 142 first, group 144 second). As a result, the traffic ratio between groups 142 and 144 continues to change. When the traffic ratio becomes zero for a group, that group becomes ready for the merging process. For example, when the traffic ratio for group 142 becomes zero, system 100 is forwarding a respective data access request to group 144. Hence, group 142 becomes ready for the merging process.
[0034] In the same way, when system 100 completes the merging process for group 142, system 100 gradually migrates data access traffic from group 144 to group 144. As a result, the traffic ratio between groups 142 and 144 starts to change in the opposite direction. When traffic ratio for group 144 becomes zero, system 100 is forwarding a respective data access request to group 142. Hence, group 144 becomes ready for the merging process. In some embodiments, update server 102 determines whether incremental data 122 have been merged to reference data 124 in a respective group (groups 142 and 144 in this example). If incremental data 122 have not been merged to reference data 124 in one or more of groups 142 and 144, system 100 selects a group which currently needs a merging. Suppose that the merging process has been completed for group 142 and not for group 144. System 100 then selects group 144 for merging. When incremental data 122 becomes merged to reference data 124 in both groups 142 and 144, system 100 can remove incremental data 122 from memory 112 of update server 102.
[0035] In some scenarios, the off-peak merging process cannot be applicable. In one such scenario, a time out event can occur for the merging process for a group. For example, the allocated time for the merging process for group 142 can pass without completion of the merging process. As a result, system 100 may start diverting traffic from group 144 to group 142. In another such scenario, during the merging process for group 142, group 144 may not be able to serve all the data access requests. Hence, system 100 may forward some data access requests to group 142, even during the merging process, to ensure the maximum availability of the online services (e.g., accessibility of data).
[0036] In these two scenarios, data access and the merging process may not be isolated between groups 142 and 144. In some embodiments, system 100, to effectively reduce the impact of the merging process on the data access, monitors the load of the storage servers of a respective group. If the load reaches a threshold, system initiates an overload prevention mode. In this mode, system 100 pauses the merging process, and frees the resources allocated for the merging process. For example, if a merging process is executed by a merging thread, system 100 pauses the operations of the thread and frees the resources, such as network, processing, and I/O resources, allocated for that thread. When system 100 detects the load to be low, system 100 can resume the merging process. In this way, system 100 provides the online services a higher priority than the merging operations, thereby ensuring quality of service (QoS) for client devices' data access requests.
[0037] FIG. 2 illustrates exemplary tablets of the reference data, in accordance with an embodiment of the present application. In this example, reference data 124 are divided into a plurality of non- overlapping data segments. Such a data segment can be referred to as a tablet. A data block in a storage server can include one or more tablets. For example, tablets 202, 206, and 208 of reference data 124 are in data block 126 hosted in storage server 104, and tablets 204, 210, and 212 of reference data 124 are in data block 128 hosted in storage server 106.
[0038] To ensure high availability and separation of the merging process, these tablets are also hosted in group 144. Tablets 202 and 210 are in data block 222 hosted in storage server 134, and tablets 204, 206, 208, and 212 are in data block 224 hosted in storage server 136. In other words, reference data 124, in its entirety, is divided into non-overlapping tablets 202, 204, 206, 208, 210, and 212, and each of the tablets is stored in a plurality of storage servers in different groups. It should be noted that, though each group includes a respective tablet of reference data 124, a group may host one copy of a tablet. As a result, a group can include one subset of the set of all copies of all tablets.
[0039] In some embodiments, system 100 uses compartmentalization of updated data
(i.e., write operations) to avoid race condition. When the amount of data written in memory 112 of update server 102 reaches a threshold, system 100 isolates that amount of data for a merging process from any subsequent updates. In this way, during the merging process, system 100 ensures that the same set of updates is merged to reference data 124 in each group. System 100 can also use a distributed commit to avoid race condition among the groups. When the merging process is completed, system 100 receives a confirmation from a corresponding storage server that the merging process for that server has completed. Upon receiving confirmations from a respective storage server in both groups 142 and 144, system 100 commits the updates to a respective storage server. Otherwise, system 100 can roll back to the previously committed reference data in a respective storage server. This prevents data mismatch between storage servers and groups due to an unsuccessful merging process.
[0040] FIG. 3A presents a flowchart illustrating a data management system initiating the merging process, in accordance with an embodiment of the present application. During operation, the system monitors the incremental data in the update server (operation S301). The system checks whether the incremental data, which are written in the memory of the update server, is greater than or equal to (or greater than) a threshold (operation S302). The quantity of the incremental data can be based on a number of bytes written in the memory. If the incremental data is not greater than or equal to the threshold, the system continues to monitor the incremental data (operation S301). If the incremental data is greater than or equal to the threshold, the incremental data is ready for a merging process. The system then checks whether an off-peak merging process is allowed (operation S303).
[0041] The system checks the load on the storage servers of a respective group and the timeout events of previous merging operations to determine whether the off-peak merging process is allowed. If off-peak merging process is allowed, the system initiates an off-peak merging process from the update server to the corresponding storage servers (operation S304). Otherwise, the system initiates a dynamically-controlled merging process from the update server to the corresponding storage servers (operation S305). It should be noted that, even though FIG. 3A illustrates only one iteration of the merging process, the system continues to monitor the incremental data (operation S301) in the update server after completion of the merging process. This ensures that whenever the amount of data written the in the memory reaches the threshold, the system initiates the merging process.
[0042] FIG. 3B presents a flowchart illustrating the off-peak merging process of a data management system, in accordance with an embodiment of the present application. During operation, the system determines a merging sequence (or merging order) for the storage server groups (operation S331). In the example in FIG. IB, the merging sequence can be group 142 first and group 144 second, or group 144 first and group 142 second. The system then sequentially selects a group from the sequence (operation S332). For example, if the sequence indicates group 142 first, system 100 selects group 142. The system gradually migrate data access traffic to other group(s) (operation S333) (e.g., to group 144). [0043] The system checks whether the selected group is ready for merging (operation S334). In some embodiments, the system maintains a traffic control table which includes the data access traffic ratio of a respective group. If the traffic ratio for the selected group becomes zero, the system considers the selected group to be ready for the merging process. If the selected group is not ready for merging, the system continues to gradually migrate data access traffic to other group(s) (operation S333). If the selected group is ready for merging, the system identifies the storage servers in the selected group (operation S335). The system merges the incremental data to the corresponding tablets in the identified storage servers (operation S336). For example, if a part of incremental data 122 includes updates to the reference data segment in tablet 202, system 100 merges that part of incremental data 122 with tablet 202 in storage server 104.
[0044] The system checks whether the merging process is complete for the selected group (operation S337). For example, if a part of incremental data 122 includes updates to the reference data segments in tablets 202, 204, 210, and 212, when system 100 completes merging incremental data 122 with tablets 202, 204, 210, and 212 hosted in group 142 (or group 144), the merging process is complete for group 142. If the merging process is not complete, the system continues to merge the current set of incremental data to the corresponding tablets in the identified storage servers (operation S336). This allows compartmentalization of the incremental data during the merging process. Any subsequent incremental data is merged in the next merging process. If the merging process is complete, the system gradually restores data access traffic to the selected group (operation S338). The system then checks whether all groups have been merged (operation S339). If not, the system sequentially selects the next group from the sequence (operation S332).
[0045] FIG. 3C presents a flowchart illustrating the dynamically-controlled merging process of a data management system, in accordance with an embodiment of the present application. During operation, the system identifies the storage servers of a selected group
(operation S351). The system can select the group based on the current traffic load or available resources. The system checks the resource consumption of the storage servers (operation S352) and checks whether the resource consumption meets the initiating condition of a merging process (operation S353). The initiating condition can be whether the resource consumption matches a threshold. Examples of such resources include, but are not limited to, network resources, processing resources (e.g., Central Processing Unit (CPU) cycles), and I/O resources.
[0046] If the resource consumption does not meet the initiating condition, the system continues to check the resource consumption of the storage servers (operation S352). If the resource consumption meets the initiating condition, the system identifies the current set of incremental data to be merged (operation S354). Since the merging process is done only for the current set of incremental data, the resource allocation for the merging process is done for that current set. For example, if the merging process is executed using a merging thread, the merging thread is only issued for the current set of incremental data, and the system allocates resources only for that set. The system issues the next merging thread for the next set of incremental data and, accordingly, allocates the resources for that next thread. This "one-by-one" approach ensures that the next merging thread is only issued if the load on the storage servers is low.
[0047] Upon identifying the current set of incremental data to be merged, the system then initiates the merging process of the current set of incremental data to the identified storage servers (operation S355). The system collects data regarding the performance of the online services (operation S356). Examples of such data include, but are not limited to, request throughput, response latency, and request queuing. The system checks whether the performance level of the online services is below a corresponding threshold level (operation S357). For example, the system can check whether the response latency is greater than a threshold time and/or the length of the request queue is greater than a threshold length.
[0048] If the performance level is below the threshold level, the system initiates an overload prevention mode and pauses the merging process (operation S358) and continues to collect data regarding the performance of the online services (operation S356). In some embodiments, the system terminates the merging process in the overload prevention mode. If the performance level is not below the threshold level, the merging process is not severely hindering the performance level of the online services. The system then completes (e.g., resumes) the merging process for the current set of incremental data (operation S359). However, if the system has terminated the merging process in the overload prevention mode, the system can restart the merging process when the performance level of the online services is no longer below the threshold level.
[0049] FIG. 4 is a schematic structural diagram of an exemplary data management system, in accordance with an embodiment of the present application. A data management system 400 includes a processor 402, a memory 404, and a storage device 420. Storage device 420 typically stores instructions that can be loaded into memory 404 and executed by processor 402 to perform the methods described above. In one embodiment, the instructions in storage 420 can implement a selection module 422, a migration module 424, a merging module 426, and a control module 428, all of which can communication with each other through various means.
[0050] In some embodiments, modules 422, 424, 426, and 428 can be partially or entirely implemented in hardware and can be part of processor 402. Further, in some embodiments, the system may not include a separate processor and memory. Instead, in addition to performing their specific tasks, modules 422, 424, 426, and 428, either separately or in concert, may be part of special-purpose computation engines.
[0051] Storage 420 stores programs to be executed by processor 402. Specifically, storage 420 stores a program that implements a system (application) for efficient data
management using dynamic load-based merging. During operation, the application program can be loaded from storage 420 into memory 404 and executed by processor 402. As a result, system 400 can perform the functions described above. System 400 can be further coupled to an optional display 412, a keyboard 414, and a pointing device 416, and can be coupled via one or more network interfaces to a network 410.
[0052] During operation, selection module 422 maintains the sequence of groups, and selects a group from the sequence. Selection module 422 selects a storage server that needs the merging process. Selection module 422 also determines whether the merging process has been performed for a group or not. Migration module 424 migrates data access traffic from the selected group to other groups. In some embodiments, migration module 424 maintains a traffic control table for the groups. When the traffic ratio for a group becomes zero, migration module 424 determines that the group is ready for the migration process. Upon completion of the merging process, migration module 424 restores the data access traffic back to the group.
[0053] Merging module 426, after the data access traffic is migrated off the selected group, merges the incremental data from updating server to one or more tablets of the reference data in a storage server. Control module 428, during the merging process, determines whether any data access traffic should be processed by the group currently being merged. Control module 428, if the resource consumption condition meets an initiating condition, can initiate the dynamically-controlled merging process for that group, as described in conjunction with FIG. 3C. For example, control module 424 can pause (or terminate), and resume (or restart) the merging process, if needed.
[0054] The data structures and computer instructions described in this detailed description are typically stored on a computer-readable storage medium, which may be any device or medium that can store code and/or data for use by a computer system. The computer- readable storage medium includes, but is not limited to, volatile memory, non- volatile memory, magnetic and optical storage devices such as disk drives, magnetic tape, CDs (compact discs), DVDs (digital versatile discs or digital video discs), or other media capable of storing computer- readable media now known or later developed.
[0055] The methods and processes described in the detailed description section can be embodied as code and/or data, which can be stored in a computer-readable storage medium as described above. When a computer system reads and executes the code and/or data stored on the computer-readable storage medium, the computer system performs the methods and processes embodied as data structures and code and stored within the computer-readable storage medium.
[0056] Furthermore, methods and processes described herein can be included in hardware modules or apparatus. These modules or apparatus may include, but are not limited to, an application-specific integrated circuit (ASIC) chip, a field-programmable gate array (FPGA), a dedicated or shared processor that executes a particular software module or a piece of code at a particular time, and/or other programmable-logic devices now known or later developed. When the hardware modules or apparatus are activated, they perform the methods and processes included within them.
[0057] The above description is presented to enable any person skilled in the art to make and use the embodiments, and is provided in the context of a particular application and its requirements. Various modifications to the disclosed embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be applied to other embodiments and applications without departing from the spirit and scope of the present disclosure. Thus, the present invention is not limited to the embodiments shown, but is to be accorded the widest scope consistent with the principles and features disclosed herein.

Claims

What Is Claimed Is:
1. An computer-implemented method for facilitating dynamic load-based merging, the method comprising:
identifying incremental data in memory of a first computing device, wherein the incremental data comprises update to reference data in a storage device in a second computing device;
in response to size of the incremental data being greater than a threshold, selecting a first server group from a plurality of server groups, wherein the second computing device belongs to the first server group;
migrating data access requests from the first server group to another server group in the plurality of server groups; and
merging the incremental data from the memory of the first computing device to the storage device in the second computing device, wherein the merging includes batch sequential disk writes to the storage device of the second computing device.
2. The method of claim 1, wherein the reference data is divided into a plurality of tablets, wherein a tablet is a non- overlapping segment of the reference data.
3. The method of claim 2, wherein a respective server group of the plurality of server groups includes a copy of a respective tablet of the reference data.
4. The method of claim 1, wherein selecting the first server group from the plurality of server groups includes identifying the first server group from a sequence of server groups.
5. The method of claim 4, further comprising:
determining whether the merging of the incremental data have been performed for a respective server group; and
selecting a server group for which the merging of the incremental data has not been performed.
6. The method of claim 1, further comprising:
maintaining a traffic control table comprising data access request traffic ratio of a respective server group of the plurality of server groups;
determining whether the traffic ratio for the first server group has reached a threshold value in the traffic control table; and
in response to the determination, determining the first server group to be ready for the merging.
7. The method of claim 1, further comprising:
determining whether the merging is complete for the first server group; and
in response to the determination, restoring data access requests from the other server groups back to the first server group.
8. The method of claim 1, further comprising:
determining whether the first server group is needed to serve data access requests during the merging of the incremental data; and
determining whether resource consumption by computing devices in the first server group satisfies a condition.
9. The method of claim 8, further comprising:
determining performance level associated with the data access requests served from the first server group; and
in response to the performance level being below a threshold, pausing the merging of the incremental data.
10. The method of claim 9, further comprising releasing resources occupied by the merging of the incremental data for serving the data access requests.
11. A non-transitory storage medium storing instructions, which when executed by a processor cause the processor to perform a method for facilitating dynamic load-based merging, the method comprising:
identifying incremental data in memory of a first computing device, wherein the incremental data comprises update to reference data in a storage device in a second computing device;
in response to size of the incremental data being greater than a threshold, selecting a first server group from a plurality of server groups, wherein the second computing device belongs to the first server group;
migrating data access requests from the first server group to another server group in the plurality of server groups; and merging the incremental data from the memory of the first computing device to the storage device in the second computing device, wherein the merging includes batch sequential disk writes to the storage device of the second computing device.
12. The non-transitory storage medium of claim 11, wherein the reference data is divided into a plurality of tablets, wherein a tablet is a non-overlapping segment of the reference data.
13. The non-transitory storage medium of claim 12, wherein a respective server group of the plurality of server groups includes a copy of a respective tablet of the reference data.
14. The non-transitory storage medium of claim 11, wherein selecting the first server group from the plurality of server groups includes identifying the first server group from a sequence of server groups.
15. The non-transitory storage medium of claim 14, wherein the method further comprises:
determining whether the merging of the incremental data have been performed for a respective server group; and
selecting a server group for which the merging of the incremental data has not been performed.
16. The non-transitory storage medium of claim 11, wherein the method further comprises:
maintaining a traffic control table comprising data access request traffic ratio of a respective server group of the plurality of server groups;
determining whether the traffic ratio for the first server group has reached a threshold value in the traffic control table; and
in response to the determination, determining the first server group to be ready for the merging.
17. The non-transitory storage medium of claim 11, wherein the method further comprises:
determining whether the merging is complete for the first server group; and in response to the determination, restoring data access requests from the other server groups back to the first server group.
18. The non-transitory storage medium of claim 11, wherein the method further comprises:
determining whether the first server group is needed to serve data access requests during the merging of the incremental data; and
determining whether resource consumption by computing devices in the first server group satisfies a condition.
19. The non-transitory storage medium of claim 18, wherein the method further comprises:
determining performance level associated with the data access requests served from the first server group; and
in response to the performance level being below a threshold, pausing the merging of the incremental data.
20. The non-transitory storage medium of claim 19, wherein the method further comprises releasing resources occupied by the merging of the incremental data for serving the data access requests.
21. A computing system for facilitating dynamic load-based merging, the computing system comprising:
a processor;
a memory coupled to the processor and storing instructions, which when executed by the processor cause the processor to perform a method, the method comprising:
identifying incremental data in memory of a first computing device, wherein the incremental data comprises update to reference data in a storage device in a second computing device;
in response to size of the incremental data being greater than a threshold, selecting a first server group from a plurality of server groups, wherein the second computing device belongs to the first server group;
migrating data access requests from the first server group to another server group in the plurality of server groups; and
merging the incremental data from the memory of the first computing device to the storage device in the second computing device, wherein the merging includes batch sequential disk writes to the storage device of the second computing device.
PCT/US2015/045747 2014-08-27 2015-08-18 Dynamic load-based merging WO2016032803A1 (en)

Priority Applications (6)

Application Number Priority Date Filing Date Title
ES15836188T ES2845654T3 (en) 2014-08-27 2015-08-18 Joining based on dynamic load
EP15836188.1A EP3186760B8 (en) 2014-08-27 2015-08-18 Dynamic load-based merging
SG11201700190WA SG11201700190WA (en) 2014-08-27 2015-08-18 Dynamic load-based merging
JP2017502114A JP6412244B2 (en) 2014-08-27 2015-08-18 Dynamic integration based on load
KR1020177005030A KR101938501B1 (en) 2014-08-27 2015-08-18 Dynamic load-based merging
PL15836188T PL3186760T3 (en) 2014-08-27 2015-08-18 Dynamic load-based merging

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
CN201410429616.0 2014-08-27
CN201410429616.0A CN105446653B (en) 2014-08-27 2014-08-27 A kind of data merging method and equipment
US14/829,132 US10523743B2 (en) 2014-08-27 2015-08-18 Dynamic load-based merging
US14/829,132 2015-08-18

Publications (1)

Publication Number Publication Date
WO2016032803A1 true WO2016032803A1 (en) 2016-03-03

Family

ID=55400343

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2015/045747 WO2016032803A1 (en) 2014-08-27 2015-08-18 Dynamic load-based merging

Country Status (1)

Country Link
WO (1) WO2016032803A1 (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113407108A (en) * 2020-03-16 2021-09-17 北京沃东天骏信息技术有限公司 Data storage method and system
JP7309005B2 (en) 2017-06-27 2023-07-14 セールスフォース インコーポレイテッド Database tenant migration system and method

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1994018634A1 (en) * 1993-02-01 1994-08-18 Lsc, Inc. Archiving file system for data servers in a distributed network environment
US6226650B1 (en) * 1998-09-17 2001-05-01 Synchrologic, Inc. Database synchronization and organization system and method
US8452819B1 (en) * 2011-03-22 2013-05-28 Amazon Technologies, Inc. Methods and apparatus for optimizing resource utilization in distributed storage systems

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1994018634A1 (en) * 1993-02-01 1994-08-18 Lsc, Inc. Archiving file system for data servers in a distributed network environment
US6226650B1 (en) * 1998-09-17 2001-05-01 Synchrologic, Inc. Database synchronization and organization system and method
US8452819B1 (en) * 2011-03-22 2013-05-28 Amazon Technologies, Inc. Methods and apparatus for optimizing resource utilization in distributed storage systems

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
See also references of EP3186760A4 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP7309005B2 (en) 2017-06-27 2023-07-14 セールスフォース インコーポレイテッド Database tenant migration system and method
CN113407108A (en) * 2020-03-16 2021-09-17 北京沃东天骏信息技术有限公司 Data storage method and system

Similar Documents

Publication Publication Date Title
EP3186760B1 (en) Dynamic load-based merging
US11620313B2 (en) Multi-cluster warehouse
KR102441299B1 (en) Batch data collection into database system
US10592165B1 (en) Method, apparatus and computer program product for queueing I/O requests on mapped RAID
US20150237140A1 (en) Data storage systems and methods
US9948743B2 (en) Managing memory usage in server systems
US9792050B2 (en) Distributed caching systems and methods
TW201738781A (en) Method and device for joining tables
US20200285510A1 (en) High precision load distribution among processors
US11481140B1 (en) Dynamic base disk mirroring for linked clones
JP2007328711A (en) Method of changing configuration of unshared database system, management server and unshared database system
WO2016032803A1 (en) Dynamic load-based merging
US10824640B1 (en) Framework for scheduling concurrent replication cycles
US9619153B2 (en) Increase memory scalability using table-specific memory cleanup
US11126371B2 (en) Caching file data within a clustered computing system
JP7104327B2 (en) Information processing device, virtual machine management program and virtual machine management method
KR101754713B1 (en) Asymmetric distributed file system, apparatus and method for distribution of computation
CN111475279A (en) System and method for intelligent data load balancing for backup

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 15836188

Country of ref document: EP

Kind code of ref document: A1

ENP Entry into the national phase

Ref document number: 2017502114

Country of ref document: JP

Kind code of ref document: A

REEP Request for entry into the european phase

Ref document number: 2015836188

Country of ref document: EP

WWE Wipo information: entry into national phase

Ref document number: 2015836188

Country of ref document: EP

ENP Entry into the national phase

Ref document number: 20177005030

Country of ref document: KR

Kind code of ref document: A

NENP Non-entry into the national phase

Ref country code: DE