List them in $wgDBservers <
https://www.mediawiki.org/wiki/Manual:$wgDBservers> - note that MediaWiki
still reads from master when it can't afford getting stale data, e.g.
"we're about to save a page, check if user is blocked" or "we're
updting
pagelinks, let's see what's already in there to insert/delete only needed
things".
Cool, Max! Thanks for the info!
Tim
On Mon, Aug 31, 2015 at 2:25 PM, Max Semenik <maxsem.wiki(a)gmail.com> wrote:
List them in $wgDBservers <
https://www.mediawiki.org/wiki/Manual:$wgDBservers> - note that MediaWiki
still reads from master when it can't afford getting stale data, e.g.
"we're about to save a page, check if user is blocked" or "we're
updting
pagelinks, let's see what's already in there to insert/delete only needed
things".
On Sun, Aug 30, 2015 at 8:53 PM, Tim Dunphy <bluethundr(a)gmail.com> wrote:
Hey guys,
I have a database cluster consisting of four MariaDB10 servers. The
first
two are setup in a master/master setup providing
HA/Failover via
HA/Proxy.
The second two are slave mysql nodes running in read_only mode. What I
would like to do is to setup my mediawiki site to send only mysql write
commands (insert,delete) to the two masters and reads (selects) from the
slaves.
I'll be putting all 4 mysql hosts into my HA/Proxy config. But what do I
need to do on the mediawiki end to make this happen? Are there any
articles
I can read that are geared towards this goal? And
docs you can point me
to,
or advice you can share would be greatly
appreciated.
Thanks,
Tim
--
GPG me!!
gpg --keyserver
pool.sks-keyservers.net --recv-keys F186197B
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
--
Best regards,
Max Semenik ([[User:MaxSem]])
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l