説明
This is intended for larger WordPress Network installs using an existing 1-3 character MD5 hash (by blog id) based multi-DB sharding structure. It supports 16, 256 or 4096 database shards. It also supports a separate database for blog id 1 and multiple VIP databases (home & VIP code contribution by Luke Poland).
It should support any plugin that works with (and accesses all data via) the regular WordPress database code.
It has been used to power MU version 2.7.1 through WordPress 4.8 sites and upgrade sites from 2.7.1 through to the WordPress 4.8.
A detailed installation guide can be purchased for a nominal fee.
This plugin is based on HyperDB which is the database plugin used by WordPress.com. Like HyperDB, this plugin autodetects whether a query is requesting a global or blog table.
スクリーンショット
Site admin blogs screen showing dataset / partition for each blog.
インストール
- The database configuration instructions are at the top of db-settings.php. The configuration instructions assume that:
- your databases all have the same database server, user & password.
- your blog shard databases are named according to the same prefix and a suffix of md5 hash, global, home or vipX.
- Instructions for adding VIP databases are at the bottom of db-settings.php.
- Once finished editing db-setting.php upload it to the same folder as wp-config.php for your WordPress install.
- Edit your wp-config.php and add the following line after the database settings are defined:
require_once(‘db-settings.php’); - upload shardb-admin.php to /wp-content/plugins/.
- Network activate the SharDB admin tools in Network Admin -> Plugins.
- Migrate your data to your DB shards using the SharDB migration screen under Network Admin -> Settings on the main site.
- upload db.php to /wp-content/.
FAQ
- Installation Instructions
-
- The database configuration instructions are at the top of db-settings.php. The configuration instructions assume that:
- your databases all have the same database server, user & password.
- your blog shard databases are named according to the same prefix and a suffix of md5 hash, global, home or vipX.
- Instructions for adding VIP databases are at the bottom of db-settings.php.
- Once finished editing db-setting.php upload it to the same folder as wp-config.php for your WordPress install.
- Edit your wp-config.php and add the following line after the database settings are defined:
require_once(‘db-settings.php’); - upload shardb-admin.php to /wp-content/plugins/.
- Network activate the SharDB admin tools in Network Admin -> Plugins.
- Migrate your data to your DB shards using the SharDB migration screen under Network Admin -> Settings on the main site.
- upload db.php to /wp-content/.
- The database configuration instructions are at the top of db-settings.php. The configuration instructions assume that:
評価
貢献者と開発者
変更履歴
2.8.1
- Fix MySQL FOUND_ROWS() support used for pagination.
- Fix warnings.
2.8
- Add PHP7 support.
- Fix warnings.
- Test with WP 4.8
2.7.7
- Fixed button URLs in the migration screen.
- Test with WP 3.6
2.7.6
- Fixed notices issued by PHP 5.4.
- Added 3.3.X support.
- Added support for BuddyPress 1.5 forums.
- Dropped support for pre 3.2 WordPress.
2.7.5
- Added 3.1.X support.
- Migration script.
2.7.4
- Added 3.0.X support.
- Fixed warning.
2.7.3
- Added 2.9.1.1 comment meta support.
2.7.2
- Added dataset / partition to site admin blogs screen.
2.7.1
- Original version.