Manual:$wgSharedTables
| <translate> Shared DB settings</translate>: $wgSharedTables | |
|---|---|
List of database tables (without prefixes) to share when $wgSharedDB is enabled. |
|
| <translate> Introduced in version:</translate> | 1.13.0 (r34353) |
| <translate> Removed in version:</translate> | <translate> still in use</translate> |
| <translate> Allowed values:</translate> | (array of strings) |
| <translate> Default value:</translate> | see below |
| <translate> Other settings:</translate> <translate> Alphabetical</translate> | <translate> By function</translate> | |
Details
This only includes the user table by default for backwards compatibility. However you may remove it so that you can enable extensions using the shared DB without having shared users. Or you can add in another table, such as interwiki to force MediaWiki to use the shared version of the table instead.
Be careful with sharing tables. The images, revisions, pages, and many of the other tables may have bad side effects if you share them.
In 1.16 (r56741), the new table for storing user preferences was added - user_properties.
See Manual:Shared database for usage information.
Default value
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">| <translate> MediaWiki version:</translate> |
$wgSharedTables = [
'user',
'user_properties',
'user_autocreate_serial',
];
| <translate> MediaWiki versions:</translate> |
$wgSharedTables = [
'user',
'user_properties',
];
| <translate> MediaWiki versions:</translate> |
$wgSharedTables = array( 'user', 'user_properties' );
Upgrading
As of MediaWiki 1.21, $wgSharedTables must be temporarily cleared during upgrade.
Otherwise, the shared tables are not touched at all (neither tables with $wgSharedPrefix, nor those with $wgDBprefix), which may lead to failed upgrade.
Example
If you wanted to share the ipblocks table, you would use:
$wgSharedTables[] = 'ipblocks';
See also
- Manual:$wgSharedDB
- Manual:$wgSharedPrefix
- Extension:GlobalPreferences - Allows a user to select which of their preferences will be global
