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.
Should I: A. Give each WordPress instance it's own read replica? or 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. Any thoughts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org