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