[Pgpool-general] need help on the pgpool architecture

[Micka]

Thanks you very much for your tutorial, it helps me a lot to understand .

But I discovered that you use 3 server:

   1. Postgres database server on 10.0.0.34
   2. Postgres database server on 10.0.0.36
   3. pgpool server on 10.0.0.35


My question, is what happen if the "pgpool server" goes down ? it's not the
best configuration isn't it ?

I think that I'm going on this configuration :


   1. php server
   2. A: TomCat Server with : socket server A,  application A , database A,
   pgpool A
   3. B: Tomcat Server with:  socket server B, application B ( a backup to
   the application A ), database B, pgpool B ( to take the control if the
   Server A is down ).

I really need to have application A or B running at full time, and I can't
have the database not available !
My project is to receive data from phone( by socket connection ), insert the
data on the database, process the data, insert the new data in my database
and send the new data on the devices.

I plan to have a backup server ( B) if A goes down.


I'm not an expert in my project and i need some advise.


Thanks you !





On Tue, Feb 8, 2011 at 3:20 PM, AI Rumman <rummandba at gmail.com> wrote:

> I used Postgresql 8.3. You may try it with Postgresql 9.
>
> On 2/8/11, Micka <mickamusset at gmail.com> wrote:
> > 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
> >>>
> >>>
> >>
> >
>



-- 
Michael Musset,
Tel: 06 26 06 29 89
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110211/4139c1df/attachment.html>