Load Balancer, fail tolerance and replication in PostgreSQL

Dear all,

We have a web application served by Apache with Tomcat behind for the=
=20
JSPs. The database backend is PostgreSQL. I have been asked to do some
research about how to achieve fail tolerance and load balancing in our=20
application. After searching a little bit this is my first impression:

- There are integrated software for high availability using PostgreSQ=
L=20
(i.e.: eRserver) but have commercial licences (you have to pay a lot fo=
r=20
it).

- There are some efforts for developing GPL application to achieve=20
replication, or load balancing or even clustering. My impression is tha=
t=20
they are in a earlier stage, but some of them look promising. Anyway I=20
am not very sure if any of them will suit into my setup (like pgcluster=
=20
or dbmirror).

What I have thought that in my setup maybe I just need to do=20
clustering with servers with the same setup: Apache/Tomcat. Then, just=
=20
do some sort of replication between the PostgreSQL databases that every=
=20
node of the cluster should have (i dont know which is the best GPL=20
replication software). Even I thought that maybe I could use some sort=20
of dns round- robin approach for load balancing for Apache.

Anyway as you can see I=B4m pretty lost and I need some guidance to p=
ut=20
me in the right direction...

Sorry for my English

Many thanks in advance

Miguel







Se que en Bulma sois mas forofos de MySQL que de PostgreSQL por
vuestras experiencias con la web de bulma, pero tengo que hacer un
estudio para usar PostgreSQL en un entorno donde se necesita balanceo d=
e
carga y tolerancia a fallos.

Realmente lo que tenemos es una aplicacion web, con Apache y Tomcat
como servidores de JSPs cuya base de datos es PostgreSQL, digo esto
porque he pensado que tal vez lo de buscar un sistema de alta
disponibilidad para PostgreSQL no sea necesario para este sistema, y
simplemente lo que podria hacerse seria un cluster con Apache, o inclus=
o
utilizar un algoritmo round-robin que vaya pasando las solicitudes a lo=
s
distintos servidores y un sistema de mirroring entre los distintos
servidores PostgreSQL.

He estado mirando en la p=E1gina web de PostgreSQL y navegando un poco,=
y
veo que hay alternativas que ofrecen alta disponibilidad (tolerancia a
fallos, balanceo y replicacion), pero de pago.

Como os digo se me ocurre a priori este enfoque que os digo, ya que
realmente solo hay una base de datos que mantener sincronizada (creo qu=
e
esto se puede hacer con dbmirror aunque no se si es solo a nivel de
tablas o de bases de datos).

Tambien he visto una herramienta llamada pgcluster. La verdad estoy un
poco perdido, alguien me puede echar un cable?

Un saludo

Miguel



-
To unsubscribe from this list: send the line "unsubscribe linux-admin" =
in
the body of a message to majordomo@vger.kernel.org
More majordomo info at http://vger.kernel.org/majordomo-info.html

Re: Load Balancer, fail tolerance and replication in PostgreSQL

Sorry I pasted a message in Spanish above my message my English, sorry=20
about that.

Regards,

Miguel

> Dear all,
>
> We have a web application served by Apache with Tomcat behind for th=
e=20
> JSPs. The database backend is PostgreSQL. I have been asked to do som=
e
> research about how to achieve fail tolerance and load balancing in ou=
r=20
> application. After searching a little bit this is my first impression=
:
>
> - There are integrated software for high availability using=20
> PostgreSQL (i.e.: eRserver) but have commercial licences (you have to=
=20
> pay a lot for it).
>
> - There are some efforts for developing GPL application to achieve=20
> replication, or load balancing or even clustering. My impression is=20
> that they are in a earlier stage, but some of them look promising.=20
> Anyway I am not very sure if any of them will suit into my setup (lik=
e=20
> pgcluster or dbmirror).
>
> What I have thought that in my setup maybe I just need to do=20
> clustering with servers with the same setup: Apache/Tomcat. Then,=20
> just do some sort of replication between the PostgreSQL databases tha=
t=20
> every node of the cluster should have (i dont know which is the best=20
> GPL replication software). Even I thought that maybe I could use some=
=20
> sort of dns round- robin approach for load balancing for Apache.
>
> Anyway as you can see I=B4m pretty lost and I need some guidance to =
put=20
> me in the right direction...
>
> Sorry for my English
>
> Many thanks in advance
>
> Miguel
>
>
>
>
>
>
>
> Se que en Bulma sois mas forofos de MySQL que de PostgreSQL por
> vuestras experiencias con la web de bulma, pero tengo que hacer un
> estudio para usar PostgreSQL en un entorno donde se necesita balanceo=
de
> carga y tolerancia a fallos.
>
> Realmente lo que tenemos es una aplicacion web, con Apache y Tomcat
> como servidores de JSPs cuya base de datos es PostgreSQL, digo esto
> porque he pensado que tal vez lo de buscar un sistema de alta
> disponibilidad para PostgreSQL no sea necesario para este sistema, y
> simplemente lo que podria hacerse seria un cluster con Apache, o incl=
uso
> utilizar un algoritmo round-robin que vaya pasando las solicitudes a =
los
> distintos servidores y un sistema de mirroring entre los distintos
> servidores PostgreSQL.
>
> He estado mirando en la p=E1gina web de PostgreSQL y navegando un poc=
o, y
> veo que hay alternativas que ofrecen alta disponibilidad (tolerancia =
a
> fallos, balanceo y replicacion), pero de pago.
>
> Como os digo se me ocurre a priori este enfoque que os digo, ya que
> realmente solo hay una base de datos que mantener sincronizada (creo =
que
> esto se puede hacer con dbmirror aunque no se si es solo a nivel de
> tablas o de bases de datos).
>
> Tambien he visto una herramienta llamada pgcluster. La verdad estoy u=
n
> poco perdido, alguien me puede echar un cable?
>
> Un saludo
>
> Miguel
>
>
>
> -
> To unsubscribe from this list: send the line "unsubscribe linux-admin=
" in
> the body of a message to majordomo@vger.kernel.org
> More majordomo info at http://vger.kernel.org/majordomo-info.html
>

-
To unsubscribe from this list: send the line "unsubscribe linux-admin" =
in
the body of a message to majordomo@vger.kernel.org
More majordomo info at http://vger.kernel.org/majordomo-info.html

Re: Load Balancer, fail tolerance and replication in PostgreSQL

Hello Brandon,

Thank you very much for your hint, sounds very promising. I have tried=
=20
to find the roadmap of the version 7.5 and I cant find it. Do you know=20
more or less when version 7.5 are suppossed to be released?

Many thanks

Miguel

> Miguel Gonz=E1lez Casta=F1os wrote:
>
>> - There are integrated software for high availability using=20
>> PostgreSQL (i.e.: eRserver) but have commercial licences (you have t=
o=20
>> pay a lot for it).
>>
>> - There are some efforts for developing GPL application to achieve=20
>> replication, or load balancing or even clustering. My impression is=20
>> that they are in a earlier stage, but some of them look promising.=20
>> Anyway I am not very sure if any of them will suit into my setup=20
>> (like pgcluster or dbmirror).
>
>
>> Anyway as you can see I=B4m pretty lost and I need some guidance to=
=20
>> put me in the right direction...
>>
>
>>
>> -
>> To unsubscribe from this list: send the line "unsubscribe=20
>> linux-admin" in
>> the body of a message to majordomo@vger.kernel.org
>> More majordomo info at http://vger.kernel.org/majordomo-info.html
>>
> Not to sure what kind of timeframe you have here, but replication is=
=20
> marked as "Urgent" on the PostgreSQL 7.5 relese todo list=20
> http://developer.postgresql.org/todo.php
>
>
>

-
To unsubscribe from this list: send the line "unsubscribe linux-admin" =
in
the body of a message to majordomo@vger.kernel.org
More majordomo info at http://vger.kernel.org/majordomo-info.html