On Fri, May 17, 2013 at 11:42:22AM -0500, Thornton, Susan M. (LARC-B702)[LITES] wrote: > Can anyone tell me if it's a workable solution to put Postgres on a > separate server from your Dspace application? In the past, we've had them on > the same server, but are considering configuring a Postgres-only server so > that we don't have Postgres instances all over the place.
We are running that way now. We still have a few databases to migrate, but we do have a couple of DSpace instances running against a single Pg instance in a separate machine. Since the Pg JDBC driver always uses a TCP connection whether the DBMS is local or remote, the only change in performance should be due to the network hardware and the overall utilization of the path between the hosts. > If this is possible (I'm thinking it is), can anyone list pros and cons > of implementing this configuration? Are they any performance issues we need > to be aware of, etc? Pro: o As you said, fewer Pg instances to maintain, back up, etc. o DSpace and Pg don't step on each other by competing for the same resources. (This could be significant, as they tend to get busy concurrently.) o No DBMS version skew across applications. o Simpler host resource tuning for both products. Con: o your DSpace instance is now dependent on *two* hosts. o DBMS maintenance downtime affects all connected applications. I haven't noticed any performance issues. One DSpace instance seems slightly *more* responsive this way, but it also moved to newer hardware around the same time so I can't really say that the DBMS connection made a difference one way or the other. -- Mark H. Wood, Lead System Programmer [email protected] Machines should not be friendly. Machines should be obedient.
signature.asc
Description: Digital signature
------------------------------------------------------------------------------ AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d
_______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
