Architecture question I'm having trouble finding an answer to:
I run four WordPress websites. I have mysql setup in a write master/read replica slave
configuration on Amazon. There is one master that all the WordPress instances write to.
I'm trying to figure out how to setup the read replicas.
A. Give each WordPress instance it's own read replica?
B. Have all the WordPress instances use all the read replicas?
I have done A before, and it works fine. But by going with B I can consolidate, use
beefier hardware and save money.