Invention Grant
US08832273B1 Automated optimal workload balancing during failover in share-nothing database systems
有权
在无共享数据库系统中的故障转移期间自动优化工作负载平衡
- Patent Title: Automated optimal workload balancing during failover in share-nothing database systems
- Patent Title (中): 在无共享数据库系统中的故障转移期间自动优化工作负载平衡
-
Application No.: US13352919Application Date: 2012-01-18
-
Publication No.: US08832273B1Publication Date: 2014-09-09
- Inventor: Qiang Li , Ron-Chung Hu , HanCheng Hsiung
- Applicant: Qiang Li , Ron-Chung Hu , HanCheng Hsiung
- Applicant Address: US CA Mountain View
- Assignee: Symantec Operating Corporation
- Current Assignee: Symantec Operating Corporation
- Current Assignee Address: US CA Mountain View
- Agency: Campbell Stephenson LLP
- Main IPC: G06F15/173
- IPC: G06F15/173 ; G06F15/167

Abstract:
Procedures and systems may be used for assigning data partitions to data-processing host computers, for example, to initially assign data partitions at the outset of a large data-processing job or during failover measures taken in response to a failed host in a share-nothing database management system (SN-DBMS). In one implementation, a method of managing exclusive access to a data partition within a database system assesses a first host and a second host that have exclusive access to a first and second data partition, respectively, within a database system. The method assigns exclusive access of the data partition to one of the first and second hosts based on factors that may include the processing powers of first and second the hosts, and on processing requirements (such as data quantity and data criticalness) for data on the first and second data partitions.
Information query