[Pgpool-general] Re: Pgpool few questions.

[Tatsuo Ishii]

[Cc:ed to pgpool-general]

From: SielaQ <sielaq at wp.pl>
Subject: Pgpool few questions.
Date: Sun, 10 Apr 2005 17:01:39 +0200
Message-ID: <1621380984.20050410170139 at wp.pl>

> Hello Tatsuo!

Hi,

>   I'm a student from Poland.
>   In this year I'll have my thesis (project work).
>   I'd like to use (inter alia) Your project to present,
>   that Postgres Real Cluster is possible.
>   (High Availability + Load Balance)
>   
>   I will compare few nowadays project :
>    ASYNCH : slony, erServer
>     SYNCH : pgpool, pgcluster
>     
>    Showing that Postgres(+other projects) can vie WITH Oracle RAC :)
> 
> ----------------
> My qestions are:
> 
> 1.Do you use 2-phase-commit protocol to distribute the data to others
> nodes ?
>   It is important to me for having Synchronud Replication
>   - with Disturbed Transaction

No. This is simply because PostgreSQL does not support 2PC.

> 2.Is it possible to use 2 Master nodes (with failover) using Your
> project ?
> 
> 3.Can I use heartbeat with pgpool ?
> 
>  I'd like to have TRANSPARENT database (with 2 nodes)
>  I your documentation is written :
> 
>  " Also, pgpool could use two PostgreSQL servers for fail over. If the
>    first server goes down, pgpool will automatically switch to the
>    secondary server. "
>    
>  so I understand that heartbeat is NOT needed, is it ?

Basically yes. The reason I added a heart beat(health checking) was I
wanted to catch PostgreSQL failures *before* actually issuing any SQL
command.

> 4. How to configurate (configfile) for Two master machines
>     replicated with transacions
>     with failover and load balance:
> 
>     replication_mode = true
>     load_balance_mode = true
>     master_slave_mode = false
>     
>     secondary_backend_host_name = node2
>     secondary_backend_port = 5432
> 
>     I should use allmost the same options on both nodes, shouldn't I ?

Can explain more about what "two master machines" means?
--
Tatsuo Ishii

> I will be very thankful
> if you help me
> !!! ARIGATOU !!!
> 
> ---------------
> Best Regards,
>  Wojtek Sielski
>