On Fri, Feb 3, 2012 at 2:55 PM, Christopher Opena <counterveil@gmail.com> wrote:
> Merlin, thanks for the response.
no problem. if you're open to architecture suggestions you might also
want to consider going with HS/SR and getting those large olap queries
off your main database. you'll have to configure it to be very
forgiving of long running queries (which can pause replication) but
this should be a huge win in terms of total load on the main server.
also, you can skimp on hardware to a certain degree to cut costs. we
still want to get to the bottom of this obviously but it can't hurt to
get a plan 'B' going...
merlin