Manual:$wgExternalServers

From MediaWiki.org
Jump to: navigation, search

Other languages:
Deutsch • ‎English • ‎español • ‎français • ‎italiano • ‎日本語 • ‎polski • ‎português • ‎português do Brasil
MySQL specific: $wgExternalServers
An array of external MySQL servers.
Introduced in version: 1.5.0 (r9118)
Removed in version: still in use
Allowed values: (see below)
Default value: array()
Other settings: Alphabetical | By function

Details[edit]

An array of external MySQL servers.

$wgExternalServers collects all the usable clusters with all usable nodes of a cluster.

The top-level array's keys denote a cluster's name (The below example defines only one cluster. It has the name demoCluster).

The value to those keys are again arrays. They hold the specifications of the individual nodes.

The first node is consider the master. All writes to the database are performed through this master node.

Zero or more slave nodes may follow. (In the example below, you find two slave nodes).

Each node may have its own host, user, password, dbname, and type, as shown in the example. The load parameter allows to specify how much of the load should pass through this note.

e.g.

$wgExternalServers = array( 'demoCluster' => array (
  array( 'host' => 'master.example.org', 'user' => 'userM',  'password' =>'pwdM',  'dbname' => 'dbM',  'type' => "mysql", 'load' => 1 ),
  array( 'host' => 'slave1.example.org', 'user' => 'userS1', 'password' =>'pwdS1', 'dbname' => 'dbS1', 'type' => "mysql", 'load' => 1 ),
  array( 'host' => 'slave2.example.org', 'user' => 'userS2', 'password' =>'pwdS2', 'dbname' => 'dbS2', 'type' => "mysql", 'load' => 1 )
 ) 
);

(See External Storage for a discussion of this example, and how to turn this into a usable cluster configuration.)