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