On May 22, 2008, at 1:14 PM, Perrin Harkins wrote:
The module I'm presenting at YAPC::NA and OSCON this year,
DBIx::Router, will make it easier to add this kind of partitioning
after the fact. It lets you set up rules to choose which database to
send a query to. When I have a public prototype
On Wed, May 21, 2008 at 7:32 PM, Jonathan Vanasco <[EMAIL PROTECTED]> wrote:
> personally, i think one should always architect applications with separate
> DB handles for read/write/log/session at the outset. you can essentially
> make them 'one' handle until necessary... but it takes barely any t
On May 20, 2008, at 4:00 PM, Issac Goldstand wrote:
Right - I know that in theory, but was worried about the disk/ram/
cpu overhead of replicating the writes to all of the slave servers
offsetting that benefit...
The explanation i gave to this on the Pylons list today was such:
when you're
On Tue, May 20, 2008 at 4:00 PM, Issac Goldstand <[EMAIL PROTECTED]> wrote:
> Right - I know that in theory, but was worried about the disk/ram/cpu
> overhead of replicating the writes to all of the slave servers offsetting
> that benefit...
Good point. I'd suggest you look at how much RAM you ca
Perrin Harkins wrote:
On Sun, May 18, 2008 at 8:05 AM, Issac Goldstand <[EMAIL PROTECTED]> wrote:
Also, do people have concrete
benchmarks of keeping a read-only replication mysql on the webservers vs a
single read/write shared mysql server?
Any time you can spread the reads over multiple se
On Sun, May 18, 2008 at 8:05 AM, Issac Goldstand <[EMAIL PROTECTED]> wrote:
> Also, do people have concrete
> benchmarks of keeping a read-only replication mysql on the webservers vs a
> single read/write shared mysql server?
Any time you can spread the reads over multiple servers it will help.
Th
Hi all,
I know that bits and pieces of high-load configuration questions have
been posted to this list ([EMAIL PROTECTED]) and am CC-ing the mod_perl folks
(since I know there are a bunch of knowledgeable people on the subject
lurking there, but please post responses to [EMAIL PROTECTED]), but
