Purdue Research Foundation

Ashraf Mahgoub

Saurabh Bagchi

Somali Chaterji

Paul Curtis Wood

A system may forecast a workload for a cluster of nodes in a database management system. The system may generate a reconfiguration plan based on the forecasted workload. The system may obtain a heterogenous configuration set. The heterogenous configuration set may include respective configuration sets for the complete sets of nodes. The system may forecast, based on a first machine learning model, respective performance metrics for nodes in each of the complete sets. The system may forecast a cluster performance metric for the entire cluster of nodes based on a second machine learning model. The system may include, in response to satisfaction of an acceptance criterion, the heterogenous configuration set in the reconfiguration plan. The system may cause the cluster of nodes to be reconfigured based on the reconfiguration plan.

System and methods for heterogeneous configuration optimization for distributed servers in the cloud

A system may forecast a plurality of workload measurements for a database management system (DBMS) at respective times based on a workload model. The system may determine, based on the forecasted workload measurements, configuration parameter sets optimized for the DBMS at the respective times. The system may generate a reconfiguration plan. The system may determine performance that would result from reconfiguring nodes of the DBMS with the configurations parameter sets. The system may select a reconfiguration plan in response to the performance satisfying a fitness criterion. The system may cause, at the reconfiguration times, the nodes to begin reconfiguration with the configuration parameter sets included in the selected reconfiguration plan.

Clustered database reconfiguration system for time-varying workloads

A system may forecast a plurality of workload measurements for a database management system (DBMS) at respective times based on a workload model. The system may determine, based on the forecasted workload measurements, configuration parameter sets optimized for the DBMS at the respective times. The system may generate a reconfiguration plan. The system may determine a performance gain that would result from reconfiguring nodes of the DBMS with the configurations parameter sets. In addition, the system may determine a performance loss that would result from the respective databases of the nodes being inaccessible during reconfiguration with the configuration parameter sets. The system may select a reconfiguration plan in response to the performance gain and the performance loss satisfying a fitness criterion. The system may cause, at the reconfiguration times, the nodes to begin reconfiguration with the configuration parameter sets included in the selected reconfiguration plan.

Growing community of inventors

West Lafayette, IN, United States of America

Ashraf Mahgoub