multi mySQL driven web site

I have database driven web site that needs more than one MySQL Sever to handle the expected demand

I also need to implement back up system (of some type) to keep data safe.

I'm using java but that that’s not critical

What options are available to me from projects out their

I'm thinking of daisy chaining project with the MYSQL server's somehow and then when one is busy go to the next and they all be written data to. I know they开发者_Python百科 can measure time used they must be able to measure when they are in use.

---

You might want to look into clustering.

http://www.mysql.com/products/cluster/

---

How about deploying a Cluster in the cloud?

http://www.mysqlconf.com/mysql2009/public/schedule/detail/6912