best way to mirror servers or go from one to multiple servers on a mysql/php site

hopefully dual cpu servers will keep getting faster so i will never have to bother with multiple servers. but, i have a question for those people here with php/mysql sites with frequently changing database content... how do you organize things? using common sense, it seems that marking my mysql data and content with a server name/id, so that once i get beyond the traffic of one server i can route traffic to the right server based on the server name/id.

i don't see how mirroring would work because once a database slightly changes (every few seconds) the whole table has to be updated on a mirror.

ideas/suggestions?

 

 

 

 

Top