What I'd be more curious to hear about, is how they deal with super nodes and if they're storing a map (or any kind of routing table) or simply using generic modulo hashing on a key.
By the way we use & love Sentry!
Or I might be misunderstanding, and you're saying that you're just mapping which physical server has the schemas
user_id % 1000 -> schema ID
schema ID -> database ID
then select FROM schemaID.tablename etc on that particular database.The schemas are definitely a neat way to handle this though so you dont have to worry about table names.