Title: SharDB Author: Ron Rennick Published: 2009 年 12 月 23 日 Last modified: 2014 年 6 月 29 日 --- 搜尋外掛 這個外掛**並未在最新的 3 個 WordPress 主要版本上進行測試**。開發者可能不再對這個 外掛進行維護或提供技術支援，並可能會與更新版本的 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://tw.wordpress.org/plugins/shardb/#description) * [使用者評論](https://tw.wordpress.org/plugins/shardb/#reviews) * [安裝方式](https://tw.wordpress.org/plugins/shardb/#installation) * [開發資訊](https://tw.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 或更新版本 ** * 已測試相容的 WordPress 版本 **4.8.28** * 語言 * [English (US)](https://wordpress.org/plugins/shardb/) * 標籤: * [database](https://tw.wordpress.org/plugins/tags/database/)[multiple](https://tw.wordpress.org/plugins/tags/multiple/) [multisite](https://tw.wordpress.org/plugins/tags/multisite/) * [進階檢視](https://tw.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/)