PGPool in Master-Master mode, is it possible?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

PGPool in Master-Master mode, is it possible?

Vikas Sharma
Hello There,

I need to setup two PGPool Servers in Master-Master mode, First thing I want to know, is it possible?

I know we can setup 2 PGPool servers in master-slave mode using watchdog.

Could anyone please enlighten me and any workaround for this?

Regards
VS
Reply | Threaded
Open this post in threaded view
|

Re: PGPool in Master-Master mode, is it possible?

Tatsuo Ishii-3
> Hello There,
>
> I need to setup two PGPool Servers in Master-Master mode, First thing I
> want to know, is it possible?
>
> I know we can setup 2 PGPool servers in master-slave mode using watchdog.
> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html
>
> Could anyone please enlighten me and any workaround for this?
>
> Regards
> VS

> I need to setup two PGPool Servers in Master-Master mode, First thing I
> want to know, is it possible?
>
> I know we can setup 2 PGPool servers in master-slave mode using watchdog.
> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html
>
> Could anyone please enlighten me and any workaround for this?

This is not an appropriate list. You should go to the Pgpool mailing
list:

https://www.pgpool.net/mailman/listinfo/pgpool-general

Anyway... I am not sure what you mean by "Master-Master mode" but if
that means you want to issue write queries by connecting to any of
Pgpool-II port, it's already possible in the set up you have created.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply | Threaded
Open this post in threaded view
|

Re: PGPool in Master-Master mode, is it possible?

Vikas Sharma
Thank you Tatsuo for the Reply, I will post this in list you mentioned.

By Master-Master, I meant two pgpool servers both active accepting connections from Application, If one Pgpool Server becomes unlavailable other still accepting connections. At an Ideal time, both Pgpool instances on each PgPool server working actively.  The database in this case will be 1 master and 2 slaves, replicated by streaming replication.

Regards
VS

On 14 November 2017 at 22:56, Tatsuo Ishii <[hidden email]> wrote:
> Hello There,
>
> I need to setup two PGPool Servers in Master-Master mode, First thing I
> want to know, is it possible?
>
> I know we can setup 2 PGPool servers in master-slave mode using watchdog.
> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html
>
> Could anyone please enlighten me and any workaround for this?
>
> Regards
> VS

> I need to setup two PGPool Servers in Master-Master mode, First thing I
> want to know, is it possible?
>
> I know we can setup 2 PGPool servers in master-slave mode using watchdog.
> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html
>
> Could anyone please enlighten me and any workaround for this?

This is not an appropriate list. You should go to the Pgpool mailing
list:

https://www.pgpool.net/mailman/listinfo/pgpool-general

Anyway... I am not sure what you mean by "Master-Master mode" but if
that means you want to issue write queries by connecting to any of
Pgpool-II port, it's already possible in the set up you have created.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

Reply | Threaded
Open this post in threaded view
|

Re: PGPool in Master-Master mode, is it possible?

Tatsuo Ishii-3
I am not familiar with swarm cluster nor repmgr. So I wonder why you
wouldn't be able to get to the goal you are trying to achieve without
repmgr. Can you please elaborate more?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> I am also interested in this set-up
> My idea is to run pgpool in a docker swarm cluster and to have two instances of pgpool on different nodes (but not in watchdog mode). In this case it is not possible to give the responsablity to pgpool to do the failover otherwise both instances would try to do the failover (they don't know about each other, no watchdog mode). So I have to set failover_command parameter to an empty string and let repmgr do the automatic failover. I have tested and I believe it is ok: in case of master failure repmgr does the promote, pgpool will not do the failover but will constantly try to reconnect to a new master and as soon as repmgr has done the promotion it is OK.
> The important think is that when pgpool starts I have to read the state of the cluster in the repmgr metadata table (repl_nodes) and generate the /tmp/pgpool_status file based on that. (I even have to do a promote_node in the edge case that the master is down and was brought down when pgpool also was down).  
> But the inconvenient is that if pgpool fails, let's say because the docker node of pgpool is stopped, then docker swarm restart the service on another node but this can take a few seconds. So I would prefer to have multiple pgpool. I did not have the time right now to test such a scenario but I am interested to know if it is possible.
> Pierre
>
>     On Wednesday, November 15, 2017, 11:02:31 AM GMT+1, Vikas Sharma <[hidden email]> wrote:  
>  
>  Thank you Tatsuo for the Reply, I will post this in list you mentioned.
>
> By Master-Master, I meant two pgpool servers both active accepting connections from Application, If one Pgpool Server becomes unlavailable other still accepting connections. At an Ideal time, both Pgpool instances on each PgPool server working actively.  The database in this case will be 1 master and 2 slaves, replicated by streaming replication.
>
> Regards
> VS
>
> On 14 November 2017 at 22:56, Tatsuo Ishii <[hidden email]> wrote:
>
>> Hello There,
>>
>> I need to setup two PGPool Servers in Master-Master mode, First thing I
>> want to know, is it possible?
>>
>> I know we can setup 2 PGPool servers in master-slave mode using watchdog.
>> http://www.pgpool.net/pgpool- web/contrib_docs/watchdog_ master_slave_3.3/en.html
>>
>> Could anyone please enlighten me and any workaround for this?
>>
>> Regards
>> VS
>
>> I need to setup two PGPool Servers in Master-Master mode, First thing I
>> want to know, is it possible?
>>
>> I know we can setup 2 PGPool servers in master-slave mode using watchdog.
>> http://www.pgpool.net/pgpool- web/contrib_docs/watchdog_ master_slave_3.3/en.html
>>
>> Could anyone please enlighten me and any workaround for this?
>
> This is not an appropriate list. You should go to the Pgpool mailing
> list:
>
> https://www.pgpool.net/ mailman/listinfo/pgpool- general
>
> Anyway... I am not sure what you mean by "Master-Master mode" but if
> that means you want to issue write queries by connecting to any of
> Pgpool-II port, it's already possible in the set up you have created.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_ en.php
> Japanese:http://www.sraoss.co. jp
>
>
>  


--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Previous Thread Next Thread