My setup if fairly minimal but we have a need/demand to make it "Highly Available" meaning I need to have another site running the same wiki. My _idea_ was to use MySQL proxy to split read and writes between the nodes but doing some more reading the wgDBservers appears to be the proper option.
My current understanding would be configure the wgDBservers and just weight the local instance as its read slave and write to my master as it will be the first entry. The master would then replicate all writes back out to the slaves. Is this a fairly correct understanding?
Thanks.
On Wed, May 1, 2013 at 3:32 PM, Chad innocentkiller@gmail.com wrote:
On Wed, May 1, 2013 at 9:37 AM, Zach H. luckenbach@gmail.com wrote:
When using the wgDBservers option do I need to also use MySQL replication or does this handle it all?
Yes, you will. MediaWiki will only write to the master but will read from any slave (per the docs, the first entry in $wgDBservers is considered the master).
Depending on how complicated your setup is, the LoadBalancer configuration may also be of use to you:
https://www.mediawiki.org/wiki/Manual:$wgLBFactoryConf
-Chad
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l