Re: Master/Slave, DB separation or just spend $$$?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Jul 22, 2009 at 1:52 AM, Kelvin Quee<kelvinq@xxxxxxxxx> wrote:
> Hi Scott,
>
> Thanks for the quick reply.
>
> I have been staring at *top* for a while and it's mostly been 40% in
> userspace and 30% in system. Wait is rather low and never ventures
> beyond 1%.
>
> My hardware is a duo core AMD Athlon64 X2 5000+, 1GB RAM and a single
> 160 GB SATA II hard disk drive.

So I take it you're on a tight budget then?  I'm guessing you could
put a single quad core cpu and 8 Gigs of ram in place for a reasonable
price.  I'd highly recommend setting up at least software RAID-1 for
increased reliability.

> I will go look at Slony now.

Might be overkill if you can get by on a single reasonably powerful machine.

> Scott, one question though - If my master is constantly changing,
> wouldn't the updates from the master to the slave also slow down the
> slave?

Yes it will, but the overhead for the slave is much less than the master.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux