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
List them in $wgDBservers < https://www.mediawiki.org/wiki/Manual:$wgDBservers%3E - 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@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
List them in $wgDBservers < https://www.mediawiki.org/wiki/Manual:$wgDBservers%3E - 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@gmail.com wrote:
List them in $wgDBservers < https://www.mediawiki.org/wiki/Manual:$wgDBservers%3E - 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@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
mediawiki-l@lists.wikimedia.org