*High Availibility, Distribute On Demand*

[brandon kruz]

hey guys, i need a way to develope
a high availibility(no single point of failure, dual point of failure, would probably be okay, as the hardware can be switched quickly, beacuse all servers will have backup servers, eventually)

but im using mysql as a place to get querys for my search engine

my question is
is there a way, (between, 1 server now, but it will be 100+ servers eventually)
to distribute the mysql data on different servers in teh cluster depending on how many times its searched?? or a "cache" if you will


im just really confused on the way to do this, and where to start

any information and input, or other methods on the fastest, more uptime way to do this(isnt that what we all want?)



Thank You
`KrUZ~