Re: One database per server architecture

2011-10-19 Thread Wm Mussatto
On Tue, October 18, 2011 22:40, Johan De Meersman wrote: - Original Message - From: Ryan Mark rm...@tribune.com (WordPress does not like to share an app server) and added memcache. Really? We run dozens of the thing on a couple of virtuals with no problems at all. Then again, we

Re: One database per server architecture

2011-10-19 Thread Johan De Meersman
- Original Message - From: Wm Mussatto mussa...@csz.com I've turned on the reporting of full table scans into the show query log and Wordpress has a large number of full table scans so it could easily be Never trust your vendor to know their way around your systems. Check where

One database per server architecture

2011-10-18 Thread Mark, Ryan
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.

Re: One database per server architecture

2011-10-18 Thread Lydia Rowe
You have answered your own question, good sir. Or so I have come to believe. Is your primary concern $? Is your organization focused on the bottom line? Option B allows you to move in the costsaving direction. I imagine some may object to sharing resources between (potentially exploitable)

Re: One database per server architecture

2011-10-18 Thread Mark, Ryan
Thanks guys! I figured there would be no clearcut answer. I was curious if there were any nuggets of wisdom or rules of thumb I was overlooking. We initially launched sharing db servers, but had performance trouble. We've since tracked down problems in our app server config (WordPress does not

Re: One database per server architecture

2011-10-18 Thread Johan De Meersman
- Original Message - From: Ryan Mark rm...@tribune.com (WordPress does not like to share an app server) and added memcache. Really? We run dozens of the thing on a couple of virtuals with no problems at all. Then again, we don't exactly get millions of hits on most of them, so if