Title: HyperDB Author: Automattic Published: 7 mei 2016 Last modified: 12 oktober 2022 --- Plugins zoeken ![](https://ps.w.org/hyperdb/assets/banner-772x250.jpg?rev=478989) Deze plugin **is niet getest met de laatste 3 grotere versies van WordPress**. Mogelijk wordt het niet meer onderhouden of ondersteund. Ook kunnen er compatibiliteitsproblemen ontstaan wanneer het wordt gebruikt met recentere versies van WordPress. ![](https://s.w.org/plugins/geopattern-icon/hyperdb_33353d.svg) # HyperDB Door [Automattic](https://profiles.wordpress.org/automattic/) [Download](https://downloads.wordpress.org/plugin/hyperdb.1.9.zip) * [Details](https://nl.wordpress.org/plugins/hyperdb/#description) * [Beoordelingen](https://nl.wordpress.org/plugins/hyperdb/#reviews) * [Installatie](https://nl.wordpress.org/plugins/hyperdb/#installation) * [Ontwikkeling](https://nl.wordpress.org/plugins/hyperdb/#developers) [Ondersteuning](https://wordpress.org/support/plugin/hyperdb/) ## Beschrijving 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. Het ondersteunt: * Lezen en schrijven van servers (replicatie) * Configureerbare prioriteit voor lezen en schrijven * Lokale en externe datacenters * Privé en openbare netwerken * Verschillende tabellen op verschillende databases/hosts * Smart post-write master reads * Failover for downed host * Geavanceerde statistieken voor profilering * WordPress multisite Het is gebaseerd op de code die momenteel wordt gebruikt in de productie op WordPress. com met veel MySQL servers die meerdere datacenters omvatten. ## Installatie Er gaat niets in de plugins folder. 1. Voer een configuratie in `db-config.php`. 2. Deploy `db-config.php` in the directory that holds `wp-config.php`. This may be the WordPress root or one level above. It may also be anywhere else the web server can see it; in this case, define `DB_CONFIG_FILE` in `wp-config.php`. 3. Deploy `db.php` to the `/wp-content/` directory. Simply placing this file activates it. To deactivate it, move it from that location or move the config file. Elke waarde van `WP_USE_MULTIPLE_DB` zal worden genegeerd door HyperDB. ## FAQ ### Wat kan ik met HyperDB doen dat ik niet met WPDB kan doen? 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. ### Hoe ondersteunt HyperDB replicatie? HyperDB biedt geen replicatiediensten. Dat gebeurt door het configureren van MySQL- servers voor replicatie. HyperDB kan vervolgens worden geconfigureerd om deze servers op de juiste manier te gebruiken, bijvoorbeeld door verbinding te maken met masterservers om schrijfquery’s uit te voeren. ### Hoe ondersteunt HyperDB load balancing? HyperDB selecteert willekeurig databaseverbindingen van prioriteitsgroepen die je configureert. De meest voordelige verbindingen worden als eerste geprobeerd. Zo kun je je configuratie optimaliseren voor netwerktopologie, hardwarecapaciteiten of elk ander schema dat je verzint. ### How does HyperDB support failover? 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. ### Hoe ondersteunt HyperDB partitionering? 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. ### Is er een voordeel aan het gebruik van HyperDB met slechts één databaseserver ? Geen die is gemeten. HyperDB probeert het op zijn minst opnieuw voordat hij de verbinding verbreekt, dus het kan helpen in gevallen waarin de webserver tijdelijk geen verbinding kan maken met de databaseserver . Eén manier waarop HyperDB verschilt van WPDB is dat HyperDB niet probeert verbinding te maken met een database totdat er een query is gemaakt. Zo kan een site met voldoende agressieve persistente caching alleen-leesbaar blijven, ondanks dat de database onbereikbaar wordt. ### What if all database servers for a dataset go down? 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. ## Beoordelingen ![](https://secure.gravatar.com/avatar/5976c93a3179c9906b451d24fd977e8b53a1c3664f1ec8b3feaa044fb56fc435? s=60&d=retro&r=g) ### 󠀁[Perfectly does the job with php 8.1](https://wordpress.org/support/topic/excellent-12198/)󠁿 [fidji](https://profiles.wordpress.org/fidjius/) 30 september 2022 HyperDB is a must-have plugin for those with heavy database loads. Thanks for the php 8.1 update. It is installed on all my WP websites. I use AWS RDS MySQL databases with 1 writer and 2 readers for all my websites. This plugin perfectly does the job! Thank you ![](https://secure.gravatar.com/avatar/0ce739df567bef88be92b80191bb6d7311c4633ba9bf7b68330c27210d07713f? s=60&d=retro&r=g) ### 󠀁[Excellent](https://wordpress.org/support/topic/excellent-9793/)󠁿 [Shane](https://profiles.wordpress.org/shanemarsh28/) 5 oktober 2020 We use this with AWS RDS and read replicas. Please keep maintaining and keep up the great work. ![](https://secure.gravatar.com/avatar/4e22fde5b20ce70334982fecbb571b1aa231d69681597b37b40ecd325236146c? s=60&d=retro&r=g) ### 󠀁[A hidden gem](https://wordpress.org/support/topic/a-hidden-gem-5/)󠁿 [Haris](https://profiles.wordpress.org/harisrozak/) 2 oktober 2020 Maybe this plugin is not so popular because many WordPress users are just not technical users, but I truly glad the plugin is here, and hopefully the WordPress team still always have a time to maintenance this 🙂 Kudos! ![](https://secure.gravatar.com/avatar/f39dc86d143ce16ef52009438c0bf2983a393e390fe465fa5894143e26bfc214? s=60&d=retro&r=g) ### 󠀁[I had high hopes](https://wordpress.org/support/topic/i-had-high-hopes-2/)󠁿 [pipermp3](https://profiles.wordpress.org/pipermp3/) 10 juni 2020 1 reactie Plugin seems outdated. And before anyone goes “Can you even read? You didnt follow the readme” yes I did. So to recap – Downloaded the .zip on separate machine – Unpacked– Opened Readme – Opened db-config and according to the db-config itself, it uses the definitions from wp-config.php, so actually according to the file no changes is technically required. – moved db.config.php into root web directory next to wp- config. – moved db.php into wp-content. — Attempted first-time install (page appeared) On step=2 there are tons of Wordpress Database errors indicating “bad default value” for pretty much everything. Therefore unable to first-time login as Admin, as the admin user was not successfully put into the DB by HyperDB itself. The db.config contained a singular configured DB (localhost) and yes, both read/write as 1. Wordpress works excellently when the plugin is taken out and these insert errors only appears when db.php and db.config is present in their corresponding folders. Somewhat likely the plugin here is outdated for the newer versions of Wordpress/Mysql. ![](https://secure.gravatar.com/avatar/518cc8b557d6219a85f4e7cb856d049d5ebd1fd99d3d7ec112dabba33f78d9f8? s=60&d=retro&r=g) ### 󠀁[Works very well with RDS and read Replica](https://wordpress.org/support/topic/works-very-well-with-rds-and-read-replica/)󠁿 [rafasashi](https://profiles.wordpress.org/rafasashi/) 11 november 2019 This plugin works very well with AWS RDS and read replica. ![](https://secure.gravatar.com/avatar/5663014b76b796e987e70d9628d1adbb791cbb44b9c5a9f4d800920c0d676701? s=60&d=retro&r=g) ### 󠀁[Works perfectly](https://wordpress.org/support/topic/works-perfectly-1487/)󠁿 [SoN9ne](https://profiles.wordpress.org/son9ne/) 13 augustus 2018 This plugin works as described and perfectly for my AWS Aurora Writer/Reader setup. [ Lees alle 14 beoordelingen ](https://wordpress.org/support/plugin/hyperdb/reviews/) ## Bijdragers & ontwikkelaars “HyperDB” is open source software. De volgende personen hebben bijgedragen aan deze plugin. Bijdragers * [ Automattic ](https://profiles.wordpress.org/automattic/) * [ Matt Mullenweg ](https://profiles.wordpress.org/matt/) * [ Andy Skelton ](https://profiles.wordpress.org/andy/) * [ Ryan Boren ](https://profiles.wordpress.org/ryan/) * [ Michael Adams (mdawaffe) ](https://profiles.wordpress.org/mdawaffe/) * [ vnsavage ](https://profiles.wordpress.org/vnsavage/) * [ Barry ](https://profiles.wordpress.org/barry/) * [ Peter Westwood ](https://profiles.wordpress.org/westi/) * [ WordPress VIP ](https://profiles.wordpress.org/wpcomvip/) [Vertaal “HyperDB” in je eigen taal.](https://translate.wordpress.org/projects/wp-plugins/hyperdb) ### Interesse in ontwikkeling? [Bekijk de code](https://plugins.trac.wordpress.org/browser/hyperdb/), haal de [SVN repository](https://plugins.svn.wordpress.org/hyperdb/) op, of abonneer je op het [ontwikkellog](https://plugins.trac.wordpress.org/log/hyperdb/) via [RSS](https://plugins.trac.wordpress.org/log/hyperdb/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 1.9 * Restore the behavior where we retry failed connection attempts to masters; * Unbreak the logic for marking servers as down – in r2625068 the key for marking server as down was mistakenly changed to “server_readonly_$host$port” instead of “server_state_$host$port” * If all masters are marked as read-only, ignore the read-only flag and still try to connect; otherwise we might end up incorrectly breaking the master connections for 2 minutes (APCu cache time) if we had temporarily set read-only on them; * Fix a bug where having $dbhname in the server state keys can delay marking server as down or read_only by doing it once for all possible datasets and operations instead of once for the host+port; * Fix a bug where we could mark server as read-only even though the ER_OPTION_PREVENTS_STATEMENT error was returned for a different reason; now we match to make sure we actually have ‘read-only’ in the returned error; * Fix a bug where the correct tracking of the unique read-only servers or lagged slaves might fail if we have duplicate servers for the same dataset; * Fix a bug where we would not mark masters as read-only in HyperDB if they were set read-only on the server side after we already opened a connection; * Fix a bug where we might stop respecting the minimum configured amount of retries per dataset; * Revert the persistent unused_servers logic which was added in HyperDB 1.8 because: it can cause connection failures when the available servers are exhausted, we might use servers with wrong priorities, and not see newly added servers to HyperDB. Some examples of conditions which would trigger these behaviors include: server- side disconnects on timeout; when we manually disconnect open connections in long-running scripts; when we switch between different datasets on the same remote MySQL server; we’ve gone over the configured max_connections and started disconnecting existing connections to accomodate new ones; * Make sure the read_only and the downed logic still works in environments which don’t have APCu or APCu is badly fragmented by adding local caching * Correct the dbh property type * PHP 8.0 compatibility for call_user_func_array() and db_connections attribute #### 1.8 * Support for fallback master connections * Add support for marking servers read-only * Fix the issue when `do_action()` is not available * Use APCu to cache the results of server responsiveness * Add support for the `utf8mb4` server capability #### 1.7 * Add support for information_schema and transactions * Requires WordPress 4.2 for wpdb::get_table_from_query() #### 1.6 * Add support for MYSQL_CLIENT_FLAGS which was added to wpdb in [21609] * Fix PHP 7.3 Notice #### 1.5 * Fix WordPress 4.8.3 SQLi vulnerability * Add action for SQL logging * Nooit db_connect voor SELECT FOUND_ROWS() * Betere opschoning bij het verbreken van db-verbindingen #### 1.4 * Additional logging for HyperDB failures and do not save “null” queries. #### 1.3 * Improved failed query tracking #### 1.2 * PHP7 compatibiliteit * MySQLi ondersteuning * utf8mb4 tekenset toestaan #### 1.1 * Callbacks functionaliteit uitgebreid * Toegevoegd verbinding fout callback * Added replication lag detection support #### 1.0 * Ondersteuning voor WPMU en BackPress verwijderd. * New class with inheritance: hyperdb extends wpdb. * Nieuw schema voor instantiatie: $wpdb = new hyperdb(); sluit dan config in. Geen $db_* globals meer. * Nieuwe configuratie bestandsnaam (db-config.php) en logica voor het lokaliseren ervan. (ABSPATH, dirname(ABSPATH) of vooraf gedefinieerd) * Added fallback to wpdb in case database config not found. * Renamed servers to databases in config in an attempt to reduce ambiguity. * Added config interface functions to hyperdb: add_database, add_table, add_callback. * Refactored db_server array to simplify finding a server. * Removed native support for datacenters and partitions. The same effects are accomplished by read/write parameters and dataset names. * Removed preg pattern support from $db_tables. Use callbacks instead. * Removed delay between connection retries and avoid immediate retry of same server when others are available to try. * Added connection stats. * Added save_query_callback for custom debug logging. * Refined SRTM granularity. Now only send reads to masters when the written table is involved. * Improved connection reuse logic and added mysql_ping to recover from “server has gone away”. * Added min_tries to configure the minimum number of connection attempts before bailing. * Added WPDB_PATH constant. Define this if you’d rather not use ABSPATH . WPINC.‘/ wp-db.php’. ## Meta * Versie **1.8** * Laatst geüpdatet **4 jaar geleden** * Actieve installaties **10+** * WordPress versie ** 4.2 of nieuwer ** * Getest t/m **6.0.12** * Taal * [English (US)](https://wordpress.org/plugins/hyperdb/) * Tags * [availability](https://nl.wordpress.org/plugins/tags/availability/)[mysql](https://nl.wordpress.org/plugins/tags/mysql/) [performance](https://nl.wordpress.org/plugins/tags/performance/)[scaling](https://nl.wordpress.org/plugins/tags/scaling/) [WordPress.com](https://nl.wordpress.org/plugins/tags/wordpress-com/) * [Geavanceerde weergave](https://nl.wordpress.org/plugins/hyperdb/advanced/) ## Waarderingen 4.1 van 5 sterren. * [ 11 5 sterren beoordelingen ](https://wordpress.org/support/plugin/hyperdb/reviews/?filter=5) * [ 0 4 sterren beoordelingen ](https://wordpress.org/support/plugin/hyperdb/reviews/?filter=4) * [ 0 3 sterren beoordelingen ](https://wordpress.org/support/plugin/hyperdb/reviews/?filter=3) * [ 0 2 sterren beoordelingen ](https://wordpress.org/support/plugin/hyperdb/reviews/?filter=2) * [ 3 1 sterren beoordelingen ](https://wordpress.org/support/plugin/hyperdb/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/hyperdb/reviews/#new-post) [Bekijk alle beoordelingen](https://wordpress.org/support/plugin/hyperdb/reviews/) ## Bijdragers * [ Automattic ](https://profiles.wordpress.org/automattic/) * [ Matt Mullenweg ](https://profiles.wordpress.org/matt/) * [ Andy Skelton ](https://profiles.wordpress.org/andy/) * [ Ryan Boren ](https://profiles.wordpress.org/ryan/) * [ Michael Adams (mdawaffe) ](https://profiles.wordpress.org/mdawaffe/) * [ vnsavage ](https://profiles.wordpress.org/vnsavage/) * [ Barry ](https://profiles.wordpress.org/barry/) * [ Peter Westwood ](https://profiles.wordpress.org/westi/) * [ WordPress VIP ](https://profiles.wordpress.org/wpcomvip/) ## Ondersteuning Iets te melden? Hulp nodig? [Het supportforum bekijken](https://wordpress.org/support/plugin/hyperdb/)