[Pgpool-general] need help on the pgpool architecture
Micka
mickamusset at gmail.com
Tue Feb 8 12:26:18 UTC 2011
I would like to know if it is preferable to use postgreSQL 9 or Postgresql
8.3.8 ?
Postgresql 8.3.8 is described in the tutorial.
Thanks,
On Tue, Feb 8, 2011 at 1:19 PM, AI Rumman <rummandba at gmail.com> wrote:
> I think this may help you;
>
> http://airumman.blogspot.com/2011/02/postgresql-failover-with-pgpool-ii.html
>
> On Tue, Feb 8, 2011 at 5:27 PM, Micka <mickamusset at gmail.com> wrote:
>
>> Hi,
>>
>> I would like to configure a backup server for my application.
>>
>> I thought about that :
>>
>> Master Server : A Slave Server : B
>> - PostgreSQL 9 A - PostgreSQL 9 B
>> - PgPool A - Pgpool B
>> - TomCat Application A - TomCat Application B
>>
>>
>> Normal case:
>> The application A use pgpool A to insert/update/delete data.
>> database B can be used for loadbalancing.
>>
>> Other case:
>> The server Master goes down;
>> How can I detect it ? Is it possible to use PgPool B with this
>> configuration : ( Server B is the master and server A is the slave ).
>> I thought about that :
>>
>> 1. The Application B detect that the Application A is not responding.
>> 2. The application B take the control, and use the Pgpool B for
>> insert/delete/update data.
>> 3. When the Server A goes back online, it detect that now its
>> configuration is slave mode.
>> 4. The Pgpool B detect that database A is online and sync the database
>> B with the database A.
>>
>>
>> Is it possible ?
>>
>>
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110208/f75b0d06/attachment.html>
More information about the Pgpool-general
mailing list