MySQL clustering is great if you configure it correctly at the start.
Another option is to separate out your selects from your updates and inserts in your code and have a number of slaves which you query, and updates only go to the master (this is how I used to deal with it before MySQL had clustering ability!)
|