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.