[Mediawiki-l] Load Balancing?

[Brion Vibber]

-----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)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFt5j6wRnhpk1wk44RAh+xAKC9FpmkZTHTXNCUtL5FcTXxFgSLsgCg3abi
fQELVqs5zxHlNTu3OyTiUZw=
=Ma6e
-----END PGP SIGNATURE-----