Techniques for deterministically routing database requests to database servers

A non-transitory computer readable storage medium configured to store instructions that, when executed by at least one processor included in a routing server, cause the routing server to select database servers to process input/output (I/O) requests, by carrying out steps that include:

• receiving, from a client device, a request to perform an I/O operation to a database file that corresponds to a user account;
• referencing a configuration file to identify a group of database servers through which access to the database file can be achieved;
• providing, to a hash function, (i) the user account, and (ii) a count of the group of database servers, to produce a hash value that corresponds to a particular database server within the group of database servers;
• and
• in response to determining that the particular database server is accessible:
• providing the request to the particular database server.

A routing server configured to select database servers to process input/output (110) requests, the routing server comprising:

• at least one processor;
• and
• at least one memory storing instructions that, when executed by the at least one processor, cause the routing server to carry out steps that include:
• receiving, from a client device, a request to perform an I/O operation to a database file that corresponds to a user account;
• referencing a configuration file to identify a group of database servers through which access to the database file can be achieved;
• providing, to a hash function, (i) the user account, and (ii) a count of the group of database servers, to produce a hash value that corresponds to a particular database server within the group of database servers;
• and
• in response to determining that the particular database server is accessible:
• providing the request to the particular database server.