HyperDB is a very advanced database class that replaces a few of the WordPress built-in database functions. The main differences of HyperDB are:
- can be connect to an arbitrary number of database servers
- inspects each query to determine the appropriate database.
For some time, I had HyperDB configured for this blog to use two databases, which worked great (write to master, read from slave). Unfortunately I had to replicate the data myself, after each post using a PHP-script. That kind of sucked ;-)
More information about HyperDB
If you'd like more information about WordPress HyperDB and database partitioning and replication, check out the following resources:
- http://codex.wordpress.org/HyperDB
- http://wordpress.org/extend/plugins/hyperdb/
- How to deploy HyperDB
WordPress performance, PHP and IIS
I'd love to hear what plugins or special configurations you use to boost your WordPress' performance. Share your thoughts, knowledge and ideas. How to improve WordPress Performance on IIS is a major subject on this blog.
Did you know: HyperDB supports partition of data as well as replication.