Research on Multi Field Enumeration Algorithm in Distributed Database

Most mainstream distributed database middleware only supports single-field sharding, which cannot meet multi-field sharding needs. To address this and eliminate the problems of high complexity, high overhead and unfavorable maintenance of multi-field sharding, this paper proposes a strategy to combi...

Full description

Saved in:
Bibliographic Details
Published in:2025 IEEE 6th International Seminar on Artificial Intelligence, Networking and Information Technology (AINIT) pp. 1509 - 1514
Main Authors: Chen, Fei, Liu, Bo, Wen, Zhonghua
Format: Conference Proceeding
Language:English
Published: IEEE 11.04.2025
Subjects:
Complexity theory
Containers
Distributed databases
Distributed middleware
Enumeration algorithm
Information technology
Maintenance
Middleware
Multiple fields
Mycat
Partitioning algorithms
Seminars
Servers
Sharding
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Most mainstream distributed database middleware only supports single-field sharding, which cannot meet multi-field sharding needs. To address this and eliminate the problems of high complexity, high overhead and unfavorable maintenance of multi-field sharding, this paper proposes a strategy to combine multiple fields into a composite field and designs a multi-field enumeration sharding algorithm. Using Docker containers, sharding servers are set up, and after updating the Mycat configuration files and starting the service, data is inserted into the MySQL database. Results show that this algorithm effectively shards data based on user-selected composite fields, distributing data across multiple database servers and resolving single server performance bottlenecks.
DOI:10.1109/AINIT65432.2025.11035503