WordPress HyperDB is an advanced database class that supports replication

HyperDB database class. HyperDB: an advanced database class for WordPress, that supports replication and partition of data. HyperDB is a replacement for the standard wpdb class, which adds the ability to use multiple databases. HyperDB supports partition of data as well as replication.

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:

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.

Jan Reilink

Hi, my name is Jan. I am not a hacker, coder, developer or guru. I am merely an application manager / systems administrator, doing my daily thing at Embrace - The Human Cloud. In the past I worked for clidn and Vevida. With over 20 years of experience, my specialties include Windows Server, IIS, Linux (CentOS, Debian), security, PHP, websites & optimization. I blog at https://www.saotn.org.