WordPress sharding: which multi-DB plugin to use?

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.)

Leave a Comment