Abstract:On-line Transaction Processing (OLTP) applications often rely on shared-nothing distributed databases that can sustain rapid growth in data volume. Distributed transactions (DTs) that involve data tuples from multiple geo-distributed servers can adversely impact the performance of such databases, especially when the transactions are short-lived and these require immediate responses. The k-way min-cut graph clustering based database repartitioning algorithms can be used to reduce the number of DTs with acceptable level of load balancing. Web applications, where DT profile changes over time due to dynamically varying workload patterns, frequent database repartitioning is needed to keep up with the change. This paper addresses this emerging challenge by introducing incremental repartitioning. In each repartitioning cycle, DT profile is learnt online and k-way min-cut clustering algorithm is applied on a special sub-graph representing all DTs as well as those non-DTs that have at least one tuple in a DT. The latter ensures that the min-cut algorithm minimally reintroduces new DTs from the non-DTs while maximally transforming existing DTs into non-DTs in the new partitioning. Potential load imbalance risk is mitigated by applying the graph clustering algorithm on the finer logical partitions instead of the servers and relying on random one-to-one cluster-to-partition mapping that naturally balances out loads. Inter-server data-migration due to repartitioning is kept in check with two special mappings favouring the current partition of majority tuples in a cluster—the many-to-one version minimising data migrations alone and the one-to-one version reducing data migration without affecting load balancing. A distributed data lookup process, inspired by the roaming protocol in mobile networks, is introduced to efficiently handle data migration without affecting scalability. The effectiveness of the proposed framework is evaluated on realistic TPC-C workloads comprehensively using graph, hypergraph, and compressed hypergraph representations used in the literature. To compare the performance of any incremental repartitioning framework without any bias of the external min-cut algorithm due to graph size variations, a transaction generation model is developed that can maintain a target number of unique transactions in any arbitrary observation window, irrespective of new transaction arrival rate. The overall impact of DTs at any instance is estimated from the exponential moving average of the recurrence period of unique transactions to avoid transient fluctuations. The effectiveness and adaptability of the proposed incremental repartitioning framework for transactional workloads have been established with extensive simulations on both range partitioned and consistent hash partitioned databases.

A High-Level Tool for Enhancing the Performance and Scalability of Open-Source Relational Databases

Data Based Application Partitioning and Workload Balance in Distributed Environment

Time-Based Trajectory Data Partitioning for Efficient Range Query.

Enhancing Storage Efficiency and Performance: A Survey of Data Partitioning Techniques

Speed Partitioning for Indexing Moving Objects.

Effective Spatial Data Partitioning for Scalable Query Processing

Workload-aware incremental repartitioning of shared-nothing distributed databases for scalable OLTP applications

An Adaptive Model For Building Service-Partition System

A Parallel Varied Density-Based Clustering Algorithm with Optimized Data Partition

A Study of Performance Optimization Method for Massive Spaito-temporal Data Based on Spatio-temporal Partition Clustering

An Adaptive Data Partitioning Scheme For Accelerating Exploratory Spark Sql Queries

Fine-Grained Data Partitioning Framework For Distributed Database Systems

Coexistence of Multiple Partition Plan Based Physical Database Design.

Optimizing Data Partition for Scaling out Nosql Cluster

A grid-aided and STR-Tree-based algorithm for partitioning vector data

Optimizing Data Partition For Nosql Cluster

The performance of MapReduce: an in-depth study

Deriving Application Level Relationships by Analysing the Run Time Behaviour of Simple and Complex SQL Queries

A study of data partitioning on OpenCL-based FPGAs

Unlocking the Power of Diversity in Index Tuning for Cluster Databases