[pgpool-general: 4350] I: pgpool master to master

[Alessandro - Infopix]

Hi!

 

 

I'm evaluating for configuration master to master or master/slave.. 

I am more oriented to master/master configuration.

 

For master/slave I found this example:

http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/en.html

 

For master/master I haven’t found example… Have you got an example configuration to link me?

 

 

I thought to install pgpool on every two server and put on server 1’s pgpool server1 and server2 as node..on server2’s pgpool server 2 and server 1 as node.

In this way the app on server 1 can connect to server1’s pgpool (postgresdb) and the app on server 2 can connect to server2’s pgpool (postgresdb).

 

Thanks

 

 

Alessandro 

Da: alessio.gennari78 at gmail.com <mailto:alessio.gennari78 at gmail.com>  [mailto:alessio.gennari78 at gmail.com] Per conto di Mephysto
Inviato: giovedì 21 gennaio 2016 21.38
A: Alessandro - Infopix
Cc: pgpool-general at pgpool.net <mailto:pgpool-general at pgpool.net> 
Oggetto: Re: [pgpool-general: 4343] pgpool master to master

 

Hi Alessandro,

do you need a master-slave configuration example?

 

Bye.

 

Alessio

 

On 21 January 2016 at 08:44, Alessandro - Infopix <alessandro at infopix.it <mailto:alessandro at infopix.it> > wrote:

Hi,

 

I need configuration in which have two server active. I need live replica synchronous of database.

Can I find an example of configuration?

I thought to install pgpool on every two server and put on server 1’s pgpool server1 and server2 as node..on server2’s pgpool server 2 and server 1 as node.

In this way the app on server 1 can connect to server1’s pgpool (postgresdb) and the app on server 2 can connect to server2’s pgpool (postgresdb).

Is it the right way?

 

Thanks

 

A.Baccanelli

 

 


_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net <mailto:pgpool-general at pgpool.net> 
http://www.pgpool.net/mailman/listinfo/pgpool-general

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160122/f8e826bc/attachment.html>