Searching mysql tables over differents servers is that possible? if so how?

[jonaofarc]

Iam concerned about scalibity , I want to make sure that if a table has more than 20000000 users then it starts saving to another table on a different server.... also when one logs in it would check multiple servers to find the user , so how does one make it to merge tables in phpmysql for the sake of scalability or is it better to have one giant vritual server chain?

[awpti]

You should look into support for Partitioning.

 

Developing code to figure out which server to look at for users would take a while, unless they are all slaves to a single master DB and you just pick via round-robin.