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=listsearcharchive@lassosoft.com