Re: PostgreSQL alternative to "Oracle Real Application Cluster"
От | Paul Thomas |
---|---|
Тема | Re: PostgreSQL alternative to "Oracle Real Application Cluster" |
Дата | |
Msg-id | 20030618160455.A18931@bacon обсуждение исходный текст |
Ответ на | Re: PostgreSQL alternative to "Oracle Real Application Cluster" ("Arjen van der Meijden" <acm@tweakers.net>) |
Список | pgsql-general |
On 18/06/2003 14:39 Arjen van der Meijden wrote: > > Have you considered a simple load balancing set-up? You don't > > mention how > > you generate the web pages - hopefully not a scripting language if > > performance matters! If, for instance, your application is > > written in > > Java/JSPs then you could set up several servers running Tomcat and > > PostgreSQL and load balance them from an Apache web server > > with mod_jk. > Where would the 400-4000GB of data go in this setup? On all the distinct > postgresql-servers? On a single SAN/NAS? (Postgresql doesn't really work > with that, does it? At least not in a loadbalancing setup). I think each server would need its own copy of the data as (from what I read on this list) 2 postmasters cannot share a common database. So if the OP wants to use PG then he is going to have to have duplicate databases. > And why can't a scriptinglanguage not be used with loadbalancing? I know > it is hard or impossible to get a connectionpool in such setups, but > that doesn't mean they can't be used with loadbalancing... I was referring to the performance of scripting languages in web applications. Java web applications are generally much faster and, as I pointed out, there is an OSS load balancing option available for Java. regards -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
В списке pgsql-general по дате отправления: