H
by Automattic
4.1 (14 reviews)
HyperDB
HyperDB is an advanced database class that supports replication, failover, load balancing, and partitioning.
Tested up to WP 6 (Current: 6.9)
v1.9
Current Version v1.9
Updated 3 years ago
Last Update on 12 Oct, 2022
Synced 12 hours ago
Last Synced on
Rank
#30,688
-848 this week
Active Installs
10+
-37.5%
KW Avg Position
N/A
—
No change
Downloads
185.4K
+41 today
Support Resolved
0%
—
No change
Rating
82%
Review 4.1 out of 5
4.1
(14 reviews)
Next Milestone 20
10+
20+
5,519
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
Need 2 more installs to reach 20+
Rank Changes
Current
#30,688
Change
Best
#
Downloads Growth
Downloads
Growth
Peak
Upgrade to Pro
Unlock 30-day, 90-day, and yearly download history charts with a Pro subscription.
Upgrade NowReviews & Ratings
4.1
14 reviews
Overall
82%
5
11
(79%)
4
0
(0%)
3
0
(0%)
2
0
(0%)
1
3
(21%)
Tracked Keywords
Showing 0 of 0| Keyword | Position | Change | Type | Updated |
|---|---|---|---|---|
| No keyword data available yet. | ||||
Unlock Keyword Analytics
Track keyword rankings, search positions, and discover new ranking opportunities with a Pro subscription.
- Full keyword position tracking
- Historical ranking data
- Competitor keyword analysis
Track This Plugin
Get detailed analytics, keyword tracking, and position alerts delivered to your inbox.
Start Tracking FreePlugin 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
Upgrade to Pro
Unlock keyword rankings, search positions, and detailed analytics with a Pro subscription.
Upgrade NowSimilar Plugins
WP Adminify – White Label WordPress, Admin Menu Editor, Login Customizer
7K+ installs
#2,736
Master Addons For Elementor - White Label, Free Widgets, Hover Effects, Conditions, & Animations
40K+ installs
#929
Query Monitor - The developer tools panel for WordPress
200K+ installs
#255
MalCare WordPress Security Plugin - Malware Scanner, Cleaner, Security Firewall
200K+ installs
#258
iubenda | All-in-one Compliance for GDPR / CCPA Cookie Consent + more
200K+ installs
#261
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.