Thread: Clustering postgresql

Hello list,

has postgresql the functionality for clustering, load balancing
and failover. I have to setup two redundant web-servers with and
want run a dbms cluster on this machines.

My webapps should only see one dbms, but there should be two
redundant dbms. I know that mysql 4.1 supports this feature, but
mysql is not a ... ;-)  so I want use PostgreSQL


Thanks for your advice

Björn Voigt

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Mon, 6 Sep 2004, [ISO-8859-1] Björn Voigt wrote:

> has postgresql the functionality for clustering, load balancing
> and failover. I have to setup two redundant web-servers with and
> want run a dbms cluster on this machines.
>
> My webapps should only see one dbms, but there should be two
> redundant dbms. I know that mysql 4.1 supports this feature, but
> mysql is not a ... ;-)  so I want use PostgreSQL

If you haven't written your application yet, consider using C-JDBC:

http://c-jdbc.objectweb.org/
"C-JDBC provides a flexible architecture that allows you to achieve
scalability, high availability and failover with your database tiers.
C-JDBC instantiates the concept of RAIDb : Redundant Array of Inexpensive
Databases. The database is distributed and replicated among several nodes
and C-JDBC load balance the queries between these nodes."

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org                devrim.gunduz~linux.org.tr
             http://www.tdmsoft.com
             http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBRLDitl86P3SPfQ4RArv7AKCYsJL24XbITEAcHjJNPeJxtt4AhACdHVZS
8WJsurXkzVaiwliJLXw96cY=
=6SL7
-----END PGP SIGNATURE-----

Björn Voigt wrote:

> Hello list,
>
> has postgresql the functionality for clustering, load balancing
> and failover. I have to setup two redundant web-servers with and
> want run a dbms cluster on this machines.

I think you have to try replication solution. You can try PGCluster or
master-slave combination Slony-pgpool.

I haven't tried them yet, but in one or two month I need a replication solution,
a multimaster one, and the first thing I'm gonna try is PGCluster.

Raoul