As I am new to this "Data Base" configuring , I guess I will have to try the easiest one first, because I will be the only one working on all 24 sites and speed is an issue. I thank you all so much ! I truly didn't think I would get any answers, let alone so fast Thanks. I hope this works wish me luck :) Faith
–
Faith McNultyJan 10 '11 at 8:33

@Faith: Are you the same person as "Bee", who asked the question? Is there a reason you can't use that login anymore? This is not the same system as a forum, so you should not write a thank you note in an answer, but use the voting system (once you have enough "reputation" to do that).
–
Jan FabryJan 10 '11 at 10:45

3 Answers
3

Matt spoke at our company a few months ago. He recommended a master-slave DB setup with many R/O slaves. His rationale was that writes were expensive and reads—much higher in volume!—were not, so it was better to have more read capacity. Ditto for app servers: throw cheap hardware at the issue and forget about supercache.

Personally, I use none of them. And an NDB cluster instead. NDB is MySQL's built-in master-master replication engine.

The only limitation of NDB in practice is the lack of full text index. But you can always use yahoo or google's API for searches within your site. I found it worth the extra redundancy, especially when considering that no server ends up being a db write bottle neck.

If master-slave replication with a write bottle neck is what you need, hyperdb is developed by automattic, so it's the safer bet among the plugins you highlighted. That said, note that part of the hyperdb code is actually back ported into wp since 3.0 and the wpmu merge. (See the wp-db.php file in wp-includes, you'll notice a lot of it can handle multiple db servers out of the box.)

To add to this approach (to solve the problem on the database layer): You can proxy MySQL servers as well. And there is more benefit to replace the WPDB class with one that is making use of mysqli or even mysqlnd for more performance on the PHP side.
–
hakreJan 10 '11 at 12:32