Title: SharDB
Author: Ron Rennick
Published: <strong>23 دسامبر 2009</strong>
Last modified: 29 ژوئن 2014

---

جستجوی افزونه‌ها

این افزونه **با ۳ نگارش عمدهٔ اخیر وردپرس آزمایش نشده است**. ممکن است دیگر نگهداری
یا پشتیبانی نشود و هنگام استفاده با نگارش‌های تازه‌تر وردپرس مشکل سازگاری داشته 
باشد.

![](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://fa.wordpress.org/plugins/shardb/#description)
 * [نقد و بررسی‌ها](https://fa.wordpress.org/plugins/shardb/#reviews)
 *  [نصب](https://fa.wordpress.org/plugins/shardb/#installation)
 * [توسعه](https://fa.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.⌉⌊Site admin
blogs screen showing dataset / partition for each blog.⌉[

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/) 30 آوریل 2019

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/) 21 ژانویه 2017 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/) 3 سپتامبر 2016 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+**
 *  نگارش وردپرس ** 4.7 یا بالاتر **
 *  آزمایش‌شده تا **4.8.31**
 *  زبان
 * [English (US)](https://wordpress.org/plugins/shardb/)
 * برچسب
 * [database](https://fa.wordpress.org/plugins/tags/database/)[multiple](https://fa.wordpress.org/plugins/tags/multiple/)
   [multisite](https://fa.wordpress.org/plugins/tags/multisite/)
 *  [نمایش پیشرفته](https://fa.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)

[بررسی شما](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/)