I would like to know if there is some way I can distribute a 'select' across
multiple servers. That is, I have a query: 'select * from table where
parent_name = 'parent' order by name limit 10'. I need this query to be executed
in say 10 servers, (that will be 100 results), and then it should sort the these
100 results again, discard the 90 and only return the 10.

There is no need to do database synchronization or anything. It is almost like
a client that will do reordering on its own. Is there some way I can achieve
this using mysql? I don't think this actually falls in the category of database
clustering, but I thought I will start here.

Thanks a lot in advance.