For a LAPP setup what is better: 1 fast or 2 slower machines
Hello,
I'm running a CentOS 5.6 / 64 bit Linux
with PostgreSQL 8.4.8 and Drupal 7.4
on a 4GB quad-CPU machine.
In Autumn I can change my hoster
and for EUR 100 can either take
1) 2 machines with i7-920 Quad-Core
8 GB RAM, 2 x 750 GB SATA-II HDD
(Software-RAID 1)
or
2) 1 machine i7-980X Hexa-Core
24 GB RAM, 1 x 1,5 TB SATA II
What would you prefer?
I know, the usual answer is
"you don't provide enough details",
but would it really help anyone if I provide
all the details and print here all my scripts?
My current setup - postgresql.conf:
max_connections = 50
shared_buffers = 1024MB
and unix pipe only (for 2 machines I will
have to switch to TCP at 100 Mb/s switch).
I use pgbouncer with
pool_mode = session
server_reset_query = DISCARD ALL;
server_check_delay = 10
max_client_conn = 200
default_pool_size = 16
and at peak times it reports:
70 req/s, in 11616 b/s, out 784748 b/s,query 89556 us
34 req/s, in 5484 b/s, out 176943 b/s,query 60871 us
45 req/s, in 17976 b/s, out 169849 b/s,query 66496 us
53 req/s, in 10961 b/s, out 648585 b/s,query 40546 us
My httpd.conf:
<IfModule prefork.c>
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 120
MaxClients 120
MaxRequestsPerChild 4000
</IfModule>
Thank you
Alex
On Sat, Jul 9, 2011 at 10:19 AM, Alexander Farber
<alexander.farber@gmail.com> wrote:
Hello,
I'm running a CentOS 5.6 / 64 bit Linux
with PostgreSQL 8.4.8 and Drupal 7.4
on a 4GB quad-CPU machine.In Autumn I can change my hoster
and for EUR 100 can either take1) 2 machines with i7-920 Quad-Core
8 GB RAM, 2 x 750 GB SATA-II HDD
(Software-RAID 1)or
2) 1 machine i7-980X Hexa-Core
24 GB RAM, 1 x 1,5 TB SATA IIWhat would you prefer?
2 machines for two reasons. 1: separating out app from db server
means it's way easier to figure out which is acting up should you have
a performance problem. 2: the dual machines have RAID-1 hard drives,
the single machine just has one big 1.5TB drive. No way would I run a
production system on a single drive, especially considering how cheap
hard drives are nowadays.
Hi,
On Sat, Jul 9, 2011 at 6:53 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Sat, Jul 9, 2011 at 10:19 AM, Alexander Farber
<alexander.farber@gmail.com> wrote:1) 2 machines with i7-920 Quad-Core
8 GB RAM, 2 x 750 GB SATA-II HDD
(Software-RAID 1)2) 1 machine i7-980X Hexa-Core
24 GB RAM, 1 x 1,5 TB SATA II2 machines for two reasons. 1: separating out app from db server
means it's way easier to figure out which is acting up should you have
a performance problem. 2: the dual machines have RAID-1 hard drives,
the single machine just has one big 1.5TB drive. No way would I run a
production system on a single drive, especially considering how cheap
hard drives are nowadays.
and where to run the pgbouncer,
probably on the Apache machine?
Regards
Alex