Database Tuning Using a Federated Machine Learning System of a Centerless Network

A computer system for database configuration tuning, the computer system comprising:

• a bus system;
• a storage device connected to the bus system, wherein the storage device stores program instructions;
• and
• a processor connected to the bus system, wherein the processor executes the program instructions to:
• select a set of database nodes having similar data factors in a centerless network of database nodes;
• train configuration models corresponding to the set of database nodes using data parallelism;
• combine trained configuration models corresponding to the set of database nodes to form a federated configuration model;
• determine whether performance indicators corresponding to the set of database nodes are greater than a performance threshold level;
• recommend a database configuration corresponding to the federated configuration model to a new database node in response to determining that the performance indicators corresponding to the set of database nodes are greater than the performance threshold level;
• and
• join the new database node to the centerless network.

A computer program product for database configuration tuning, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computer to cause the computer to perform a method comprising:

• selecting, by the computer, a set of database nodes having similar data factors in a centerless network of database nodes;
• training, by the computer, configuration models corresponding to the set of database nodes using data parallelism;
• combining, by the computer, trained configuration models corresponding to the set of database nodes to form a federated configuration model;
• determining, by the computer, whether performance indicators corresponding to the set of database nodes are greater than a performance threshold level;
• responsive to the computer determining that the performance indicators corresponding to the set of database nodes are greater than the performance threshold level, recommending, by the computer, a database configuration corresponding to the federated configuration model to a new database node;
• and
• joining, by the computer, the new database node to the centerless network.