[Pgpool-general] pgpool-II features doubts

Pedro Silva pedrovieirasilva at gmail.com
Fri Apr 24 14:35:37 UTC 2009


Hi Guys,

I'm staring with pgpool-II and currently have configured a pgpool front-end with 
two backed receiving connections.
My configuration is pretty straight forward as I've only changed the default 
configuration to replication_mode = true and load_balancing_mode = true .

I've already started my web applications that use hibernate, and perform heavy 
database insertion on startup, and everything seems to be working fine, at least 
all data is consistent on both back ends.

I have several doubts regarding this configuration as it not explicit(at least 
for me) by reading the documentation. Here are some of the questions if someone 
would please be able to answer me.

1.I would like to understand if my current configuration is a really 
master-master configuration?

2. Load Balancing as it is activated will distribute my SELECT queries between 
my two backends.

3. If I now setup online recovery it doesn't matter if backend1 one or backend2 
fails because recovery works from the one that is running, right?

4. It is my understanding that recovery phase 1 will only finish when clients 
terminate their connections. Won't this be a problem due to the fact that web 
applications have normally a pool of connections that is kept between the 
database and the application? This way the connections will never end and phase 
1 won't finish, right?

Feel free to answer if you can provide some enlightenment to this.
Thanks in advance!
Pedro


More information about the Pgpool-general mailing list