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...

Celý popis

Uložené v:
Podrobná bibliografia
Vydané v:2025 IEEE 6th International Seminar on Artificial Intelligence, Networking and Information Technology (AINIT) s. 1509 - 1514
Hlavní autori: Chen, Fei, Liu, Bo, Wen, Zhonghua
Médium: Konferenčný príspevok..
Jazyk:English
Vydavateľské údaje: IEEE 11.04.2025
Predmet:
Complexity theory
Containers
Distributed databases
Distributed middleware
Enumeration algorithm
Information technology
Maintenance
Middleware
Multiple fields
Mycat
Partitioning algorithms
Seminars
Servers
Sharding
On-line prístup:Získať plný text
Tagy: Pridať tag
Žiadne tagy, Buďte prvý, kto otaguje tento záznam!
Popis
Shrnutí: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