Has anyone had any experience with clustering MySQL servers? We're looking into some blade servers for redundancy on the web server side of things, but how would I go about doing the same thing for the database without having syncronization issues?
I noticed that MySQL 5.0 has added this statement: "Reduced hardware costs by incrementally adding several low-cost commodity systems vs. upgrading high-cost mainframe-class systems". I haven't read a whole lot on 5.0, but that makes it sound like I should look into it a little deeper.
Anyone tried this with the 4 line? Downtime is getting to be pretty costly for us, so I need to start looking at something with a safety net. Any suggestions would be appreciated.