-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Sullivan, James (NIH/CIT) [C] wrote:
How do you synchronize the MySQL? Or are you using a single remote MySQL server that all servers use.
Use a single MySQL server -- that's what servers are for. ;)
If you do actually need to spread load among multiple *database backend* servers due to overload *on the backend*, then set up one or more slave servers using MySQL's replication.
See the comments in includes/DefaultSettings.php for how to configure $wgDBservers to list additional database servers to read from. (Writes will go only to the master. Do not attempt multi-master replication! MySQL ain't meant for it.)
- -- brion vibber (brion @ pobox.com / brion @ wikimedia.org)