tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vic Cekvenich ...@basebeans.com>
Subject Re: Database load balancing?
Date Mon, 24 Feb 2003 12:02:41 GMT
Try caching first; with Poolman.sf.net or 
http://www.phworks-online.com/cache.html


Replication could slow you down.

.V

Ralph Einfeldt wrote:
> It depends on your requirements.
> 
> For read only load balancing to achieve more performance
> you might also consider to use replication:
> 
> http://gborg.postgresql.org/project/pgreplication/projdisplay.php
> 
> This way you could for exapmle setup 4 instances of
> tomcat and 2 instances of postgreSQL where one db instance
> is shared by two tomcats.
> 
> This is no true loadbalancing, but might give you 
> enough power through the use of serveral db instances.
> 
> The main drawbacks against true load balancing are:
> - no simple fail over (you would have to implement on your own)
> - no load based switching between databases. (The 
>   connectiones between the tomcat instances and
>   the databases are rather static)
> 
> 
> You migh also read the following article
> http://conferences.oreillynet.com/presentations/os2002/johnson_darren.pdf
> 
> with pointers to other replication solution to postgreSQL.
> 
> 
> 
> 
>>-----Original Message-----
>>From: Hawkeye I. King [mailto:hawkeye@aruke.com]
>>Sent: Monday, February 24, 2003 11:39 AM
>>To: Tomcat Users List
>>Subject: Database load balancing?
>>
>>Does anyone have a clue about load balancing read-only 
>>database requests to PostgreSQL?  I'm developing a 
>>data-intensive application that requires scalability, 
>>not just from Tomcat, but from Postgres as well. 
>>I will use hardware load balancing to Tomcat, but I cannot 
>>do the same to a database using persistent connections.
>>
>>The only thing I've seen (after several days of searching) is
>>DBBalancer, an alpha release load balancer with no JDBC support.
>>



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message