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 <[email protected]> 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

Reply via email to