Title: SharDB Author: Ron Rennick Published: 2009 年 12 月 23 日 Last modified: 2014 年 6 月 29 日 --- 搜索插件 **该插件尚未通过WordPress的最新3个主要版本进行测试**。 当与较新版本的WordPress一起 使用时，可能不再受到维护或支持，并且可能会存在兼容性问题。 ![](https://s.w.org/plugins/geopattern-icon/shardb.svg) # SharDB 作者：[Ron Rennick](https://profiles.wordpress.org/wpmuguru/) [下载](https://downloads.wordpress.org/plugin/shardb.2.8.1.zip) * [详情](https://cn.wordpress.org/plugins/shardb/#description) * [评价](https://cn.wordpress.org/plugins/shardb/#reviews) * [安装](https://cn.wordpress.org/plugins/shardb/#installation) * [开发进展](https://cn.wordpress.org/plugins/shardb/#developers) [支持](https://wordpress.org/support/plugin/shardb/) ## 描述 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](http://wpebooks.com/shardb-installation-guide/) can be purchased for a nominal fee. This plugin is based on [HyperDB](https://wordpress.org/extend/plugins/hyperdb) which is the database plugin used by [WordPress.com](http://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. ## 安装 1. The database configuration instructions are at the top of db-settings.php. The configuration instructions assume that: 2. a. your databases all have the same database server, user & password. b. your blog shard databases are named according to the same prefix and a suffix of md5 hash, global, home or vipX. 3. Instructions for adding VIP databases are at the bottom of db-settings.php. 4. Once finished editing db-setting.php upload it to the same folder as wp-config. php for your WordPress install. 5. Edit your wp-config.php and add the following line after the database settings are defined: require_once(‘db-settings.php’); 6. upload shardb-admin.php to /wp-content/plugins/. 7. Network activate the SharDB admin tools in Network Admin -> Plugins. 8. Migrate your data to your DB shards using the SharDB migration screen under Network Admin -> Settings on the main site. 9. upload db.php to /wp-content/. ## 常见问题 Installation Instructions 1. The database configuration instructions are at the top of db-settings.php. The configuration instructions assume that: 2. a. your databases all have the same database server, user & password. b. your blog shard databases are named according to the same prefix and a suffix of md5 hash, global, home or vipX. 3. Instructions for adding VIP databases are at the bottom of db-settings.php. 4. Once finished editing db-setting.php upload it to the same folder as wp-config. php for your WordPress install. 5. Edit your wp-config.php and add the following line after the database settings are defined: require_once(‘db-settings.php’); 6. upload shardb-admin.php to /wp-content/plugins/. 7. Network activate the SharDB admin tools in Network Admin -> Plugins. 8. Migrate your data to your DB shards using the SharDB migration screen under Network Admin -> Settings on the main site. 9. upload db.php to /wp-content/. ## 评价 ![](https://secure.gravatar.com/avatar/5782e9fb9c475f12a096aa48af746905ae55fef9026664b01e08f62b7d4bbe27? s=60&d=retro&r=g) ### 󠀁[This Plugin still worked on wordpress 5.1.1 & PHP7.1 & Mysql 8](https://wordpress.org/support/topic/this-plugin-still-worked-on-wordpress-5-1-1-php7-1-mysql-8/)󠁿 [KAZUKI KIKUCHI](https://profiles.wordpress.org/kkikuchi1220/) 2019 年 4 月 30 日 This plugin was so great, I was using multi-db developed by wpmudev before, but it wasn’t working after php7. So I moved multi-db to shardb. I want to say big thanks to the developer and let wordpress users to know that this plugin is still working following environment. WordPress: 5.1.1 PHP: 7.1.X MySQL: 8.X ![](https://secure.gravatar.com/avatar/cc16ffb593690511d3559842f2a3ba9b0d430aca75e6d494aa56ff391b017141? s=60&d=retro&r=g) ### 󠀁[no compatible](https://wordpress.org/support/topic/no-compatible-2/)󠁿 [Gronix](https://profiles.wordpress.org/gronix/) 2017 年 1 月 21 日 1 回复 This plugin is not compatible with current version of WordPress. Error: SharDB must set a database connection for use with escaping. ![](https://secure.gravatar.com/avatar/b360a836bfe1338269ab5802c9cdbe24feb6c507296c02cf3a6075afec0ad476? s=60&d=retro&r=g) ### 󠀁[Does exactly what it is supposed to do](https://wordpress.org/support/topic/does-exactly-what-it-is-supposed-to-do/)󠁿 [Robert](https://profiles.wordpress.org/robertgrinde/) 2016 年 9 月 3 日 2 回复 I moved from wpmudev’s multi-db plugin to this one and it worked right out of the box! [ 阅读所有4条评价 ](https://wordpress.org/support/plugin/shardb/reviews/) ## 贡献者及开发者 「SharDB」是开源软件。 以下人员对此插件做出了贡献。 贡献者 * [ Ron Rennick ](https://profiles.wordpress.org/wpmuguru/) [帮助将「SharDB」翻译成简体中文。](https://translate.wordpress.org/projects/wp-plugins/shardb) ### 对开发感兴趣吗? 您可以[浏览代码](https://plugins.trac.wordpress.org/browser/shardb/)，查看[SVN仓库](https://plugins.svn.wordpress.org/shardb/)， 或通过[RSS](https://plugins.trac.wordpress.org/log/shardb/?limit=100&mode=stop_on_copy&format=rss) 订阅[开发日志](https://plugins.trac.wordpress.org/log/shardb/)。 ## 更新日志 #### 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. ## 额外信息 * 版本 **2.7.7** * 最后更新：**12 年前** * 活跃安装数量 **10+** * WordPress 版本 ** 4.7 或更高版本 ** * 已测试的最高版本为 **4.8.28** * 语言 * [English (US)](https://wordpress.org/plugins/shardb/) * 标签 * [database](https://cn.wordpress.org/plugins/tags/database/)[multiple](https://cn.wordpress.org/plugins/tags/multiple/) [multisite](https://cn.wordpress.org/plugins/tags/multisite/) * [高级视图](https://cn.wordpress.org/plugins/shardb/advanced/) ## 评级 4 星（最高 5 星）。 * [ 3 条 5 星评价 ](https://wordpress.org/support/plugin/shardb/reviews/?filter=5) * [ 0 条 4 星评价 ](https://wordpress.org/support/plugin/shardb/reviews/?filter=4) * [ 0 条 3 星评价 ](https://wordpress.org/support/plugin/shardb/reviews/?filter=3) * [ 0 条 2 星评价 ](https://wordpress.org/support/plugin/shardb/reviews/?filter=2) * [ 1 条 1 星评价 ](https://wordpress.org/support/plugin/shardb/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/shardb/reviews/#new-post) [查看全部评论](https://wordpress.org/support/plugin/shardb/reviews/) ## 贡献者 * [ Ron Rennick ](https://profiles.wordpress.org/wpmuguru/) ## 支持 有话要说吗？是否需要帮助？ [查看支持论坛](https://wordpress.org/support/plugin/shardb/)