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ženo v:
Podrobná bibliografie
Vydáno v:2025 IEEE 6th International Seminar on Artificial Intelligence, Networking and Information Technology (AINIT) s. 1509 - 1514
Hlavní autoři: Chen, Fei, Liu, Bo, Wen, Zhonghua
Médium: Konferenční příspěvek
Jazyk:angličtina
Vydáno: IEEE 11.04.2025
Témata:
Complexity theory
Containers
Distributed databases
Distributed middleware
Enumeration algorithm
Information technology
Maintenance
Middleware
Multiple fields
Mycat
Partitioning algorithms
Seminars
Servers
Sharding
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
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