HyperDB
HyperDB is an advanced database class that supports replication, failover, load balancing, and partitioning.
The facts
- Rating
- 4.1★ from 14
- Active installs
- 10+
- Price
- Free
- Last updated
- 12 Oct 2022
- Added
- May 2016
- Requires WP
- 4.2
- Tested up to
- WP 6.0.14
- Downloads
- 192,991
Our analysis
AI-assistedHyperDB is a WordPress plugin designed to enhance database management by replacing some of the built-in database functions. It allows you to connect to multiple database servers and intelligently routes queries to the appropriate database based on their type.
This plugin is suitable for advanced users or developers managing WordPress Multisite installations or those requiring complex database configurations, such as read/write replication and failover setups.
Best for: This plugin suits advanced WordPress users and developers managing complex database environments.
What it does well
- ✓Connects to multiple database servers
- ✓Supports read and write server replication
- ✓Offers configurable priority for database operations
- ✓Includes advanced statistics for profiling
- ✓Compatible with WordPress Multisite
Where it falls short
- •Limited user base with only 10 active installs
- •Directory score of 42/100 indicates potential issues
- •Requires advanced knowledge for effective use
Verdict
HyperDB provides advanced database functionalities for those with specific needs, but it may not be suitable for casual users due to its complexity and limited support.
From the developer
Automattic's own description of HyperDB, lightly tidied.
HyperDB is a very advanced database class that replaces a few of the WordPress built-in database functions. The main differences are:
* HyperDB can be connect to an arbitrary number of database servers,
* HyperDB inspects each query to determine the appropriate database.
It supports:
- Read and write servers (replication)
- Configurable priority for reading and writing
- Local and remote datacenters
- Private and public networks
- Different tables on different databases/hosts
- Smart post-write master reads
- Failover for downed host
- Advanced statistics for profiling
- WordPress Multisite
It is based on the code currently used in production on WordPress.com with many MySQL servers spanning multiple datacenters.