[pgpool-general: 6119] Confused between Running Modes !
itcell.mpwz at mp.gov.in
Fri Jun 8 19:34:43 JST 2018
Kindly guide me ! I am heavily confused between Running modes of PgPool II 3.7.3.
I am having 3 PostgreSQL 10 Servers running in Streaming replication Hot Standby mode. In which 1 is master and 2 are slaves.
The 1 master PostgreSQL 10 Server supports both read/write and 2 slave PostgreSQL 10 Servers supports only read queries.
I am setting PgPool II 3.7.3 to load balance all my queries among these 3 servers based on query type i.e read queries should be distributed between
all the 3 PostgreSQL 10 servers and write query should only go to Master PostgreSQL 10 server. I don't want PgPool to do replication ! I just want PgPool to
do smart load-balancing.
Now for this above configuration of mine I am not able to decide PgPool II 3.7.3. Running Modes. I am confused between Master-Slave(Stream) Mode
and Streaming Replication mode !
Since the documentation for both the modes suggests that the streaming/replication and synchronization of data will be done by PostgreSQL 10 servers.
Please elaborate any technical details of both the modes if I am missing anything. And most importantly considering my PostgreSQL 10 Servers infrastructure
which mode should I use ???
I may missing something. Any suggestions are welcome.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general