Re: [ADMIN] Virtualization vs. sharing a server

2010-05-01 Thread Enrico Weigelt
* Ramiro Barreca wrote: > As Virtualiaztion is almost discarded after reading many articles that > locate this option in the "don'ts-list", we want to know your experience (if > any) about installing a PostgreSQL and a Firebird server in the same Linux > server. Depends on the kind of virtualiza

Re: [ADMIN] Virtualization vs. sharing a server

2010-03-31 Thread Greg Smith
Rodger Donaldson wrote: On Tue, March 30, 2010 06:09, Greg Smith wrote: You answered your own question here. Ramiro is looking for suggestions for how to scale up to >500 connections at once, and it's not that likely virtualization can fill any useful role in that context. That rather

Re: [ADMIN] Virtualization vs. sharing a server

2010-03-30 Thread Jaume Sabater
On Mon, Mar 29, 2010 at 4:50 PM, Ramiro Barreca wrote: > As this is a very heterogeneous platform (from Oracle 10g, SQL Server 2008, > Firebird 2.1, Mysql 5, Postgre 8.4 up to Informix 5 and even COBOL apps) whe > are evaluating Virtualization or just sharing a server among PostgreSQL and > fireb

Re: [ADMIN] Virtualization vs. sharing a server

2010-03-30 Thread Rodger Donaldson
On Tue, March 30, 2010 06:09, Greg Smith wrote: > Michael Gould wrote: >> >> I don't know why virtualization is considered a no-no...Since these >> are all quad core with 32 gig running Windows 2003 64 bit, we can run >> about 100 users concurrently on each application server before we >> start to

Re: [ADMIN] Virtualization vs. sharing a server

2010-03-29 Thread Greg Smith
Ramiro Barreca wrote: 1. Is there a configuration option we need to consider to share this server? The two main configuration options that impact how much RAM PostgreSQL uses are shared_buffers and work_mem. If the server is shared, you just need to avoid tuning those upwards as f

Re: [ADMIN] Virtualization vs. sharing a server

2010-03-29 Thread Greg Smith
Michael Gould wrote: I don't know why virtualization is considered a no-no...Since these are all quad core with 32 gig running Windows 2003 64 bit, we can run about 100 users concurrently on each application server before we start to see a strain. You answered your own question here. Ram

Re: [ADMIN] Virtualization vs. sharing a server

2010-03-29 Thread Michael Gould
Ramiro, I don't know why virtualization is considered a no-no.  We use VMware ESX.  On some smaller applications we run both the application and database on the virutal machine.  We've not had a issue with this combination in 5+ years.  We also have 6 images that run on 2 machines just for th

[ADMIN] Virtualization vs. sharing a server

2010-03-29 Thread Ramiro Barreca
At this moment we are considering a plan for upgrading many servers in our datacenter. As this is a very heterogeneous platform (from Oracle 10g, SQL Server 2008, Firebird 2.1, Mysql 5, Postgre 8.4 up to Informix 5 and even COBOL apps) whe are evaluating Virtualization or just sharing a server amon