by Automattic 4.1 (14 reviews)

HyperDB

Name: HyperDB
Rating: 4.1 (14 reviews)
Author: Automattic

HyperDB is an advanced database class that supports replication, failover, load balancing, and partitioning.

HyperDB ranks #31,002 among WordPress.org plugins with 10+ active installations, is #1,545 of 4,482 in the Security category, a 4.1/5 rating from 14 reviews, and was last updated Oct 12, 2022. Data from WordPress.org, refreshed twice daily — see methodology.

Tested up to WP 6 (Current: 7.1)

v1.9 Current Version v1.9

Updated 3 years ago Last Update on 12 Oct, 2022

Refreshed 12 hours ago Last Refreshed on

#1,545 of 4,482 in Security Top 50% by installs Downloads -12.1% this week No update in over a year

View on WordPress.org

Rank

#31,002

+116 this week

Active Installs

10+

-37.5%

KW Avg Position

184

— No change

Downloads

187.4K

+18 today

Support Resolved

— No change

Rating

82%

Review 4.1 out of 5

4.1 (14 reviews)

Next Milestone 20

Total Progress 40%

10+ 20+

17,740

Ranks to Climb

Growth Needed

8,000,000

Active Installs

Pro

Unlock Exact Install Count

See the precise estimated active installs for this plugin, calculated from real-time ranking data.

Exact install estimates within tiers
Track install growth over time
Milestone progress predictions

Upgrade to Pro

Need 6 more installs to reach 20+

Rank Changes

Current #31,002

Change

Best #

Upgrade to Pro

Unlock 30-day and 90-day rank history charts with a Pro subscription.

Upgrade Now

Active Installs Growth

Upgrade to Pro

Active Installs 0,000,000+

Growth +0.0%

Peak 0,000,000

Downloads Growth

Downloads

Growth

Peak

Upgrade to Pro

Unlock 30-day, 90-day, and yearly download history charts with a Pro subscription.

Upgrade Now

Reviews & Ratings

4.1

14 reviews

Overall 82%

11 (79%)

0 (0%)

3 (21%)

Track This Plugin

Get detailed analytics, keyword tracking, and position alerts delivered to your inbox.

Start Tracking Free

Plugin Details

Version: 1.9
Last Updated: Oct 12, 2022
Requires WP: 4.2+
Tested Up To: 6
PHP Version: N/A
Author: Automattic

Support & Rating

Rating: ★ ★ ★ ★ ☆ 4.1
Reviews: 14
Support Threads: 0
Resolved: 0%

Keywords

WordPress.com availability mysql performance scaling

Upgrade to Pro

Unlock keyword rankings, search positions, and detailed analytics with a Pro subscription.

Upgrade Now

Similar Plugins

Adminify – White Label, Admin Menu Editor, Login Customizer

6K+ installs

#2,751

Master Addons for Elementor – Elementor Addons, Widgets, Mega Menu Builder, Popup Builder, Widget Builder & Template Kits

Akismet Anti-spam: Spam Protection

5M+ installs

Wordfence Security - Firewall, Malware Scan, and Login Security

5M+ installs

#11

Really Simple Security - Simple and Performant Security (formerly Really Simple SSL)

Limit Login Attempts Security - Login Security, 2FA, Firewall, Brute Force Prevention

View all Security-and-spam-protection plugins

Frequently Asked Questions

Common questions about HyperDB

WordPress.com, the most complex HyperDB installation, manages millions of tables spanning thousands of databases. Dynamic configuration logic allows HyperDB to compute the location of tables by querying a central database. Custom scripts constantly balance database server resources by migrating tables and updating their locations in the central database. Stretch your imagination. You could create a dynamic configuration using persistent caching to gather intelligence about the state of the network. The only constant is the name of the configuration file. The rest, as they say, is PHP.

HyperDB does not provide replication services. That is done by configuring MySQL servers for replication. HyperDB can then be configured to use these servers appropriately, e.g. by connecting to master servers to perform write queries.

HyperDB randomly selects database connections from priority groups that you configure. The most advantageous connections are tried first. Thus you can optimize your configuration for network topology, hardware capability, or any other scheme you invent.

Failover describes how HyperDB deals with connection failures. When HyperDB fails to connect to one database, it tries to connect to another database that holds the same data. If replication hasn't been set up, HyperDB tries reconnecting a few times before giving up.

HyperDB allows tables to be placed in arbitrary databases. It can use callbacks you write to compute the appropriate database for a given query. Thus you can partition your site's data according to your own scheme and configure HyperDB accordingly.

None that has been measured. HyperDB does at least try again before giving up connecting, so it might help in cases where the web server is momentarily unable to connect to the database server. One way HyperDB differs from WPDB is that HyperDB does not attempt to connect to a database until a query is made. Thus a site with sufficiently aggressive persistent caching could remain read-only accessible despite the database becoming unreachable.

Since HyperDB attempts a connection only when a query is made, your WordPress installation will not kill the site with a database error, but will let the code decide what to do next on an unsuccessful query. If you want to do something different, like setting a custom error page or kill the site, you need to define the 'db_connection_error' callback in your db-config.php.