Manual:$wgExternalServers

Específico do MySQL: $wgExternalServers
Array de servidores MySQL externos.
Introduzido na versão:	1.5.0 (r9118)
Removido na versão:	ainda em uso
Valores permitidos:	(ver abaixo)
Valor padrão:	[]
Outras definições: Alfabético | Por função

Detalhes

Array de servidores MySQL externos.

$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, using the same format as $wgDBservers .

The first node is considered 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 should 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 node.

Por exemplo:

$wgExternalServers = [ 'demoCluster' => [
  [ 'host' => 'master.example.org', 'user' => 'userM',  'password' =>'pwdM',  'dbname' => 'dbM',  'type' => "mysql", 'load' => 1 ],
  [ 'host' => 'slave1.example.org', 'user' => 'userS1', 'password' =>'pwdS1', 'dbname' => 'dbS1', 'type' => "mysql", 'load' => 1 ],
  [ '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.