I would like to set up my Multisite WP install on two servers in different countries which are both using the same databases. Multi-DB, as I understand, is designed to balance MySQL loads across several databases. I need help with creating a redundancy between the two servers in a scalable way.
We are trying to achieve 2 or more fully redundant systems which can scale up (HDD space) in tandem.
Or, if we can find a way to have 3 nodes where the WP Install is redundant across 2 slave nodes that would be OK so long as we have a load balancer to send requests to the correct IPs. Could anyone point me in the right direction, a guide would be great but any information would be appreciated.