[pgpool-general: 6753] Re: 【Anyone use pgpool-II with BDR?】

[Noriyuki Hayashi]

Dear Tatsuo-san and Luca-san, All

Thank you for interesting information to me.
I will try to configure as like below.
pgpool-II will be configured port for user access to allmost reading as select.
Only few times for update and delete.
BDR will be configured port for data correction for huge update and insert.

I always build rpm by myself from source as optimised one.
postgresql-bdr-9.4.21 will be built by myself.(prepared on CentOS7.6)
(Thinking repmgr for postgres-10 or something now)
pgpool will be built by myself with 3.5 to 3.7.
based on CentOS7.6.

Kind regards,
Hayashi

On Fri, 25 Oct 2019 08:07:18 +0900 (JST)
Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> Hi Luca,
> 
> Correction. 3.7 already supports logical replication *without* BDR.
> 
> Regarding BDR, probably it would not happen until PostgreSQL core
> supports BDR.
> 
> > Hi tatsuo,
> > Any plan to support bdr?
> > Regards,
> > luca
> > 
> > Il gio 24 ott 2019, 10:08 Tatsuo Ishii <ishii at sraoss.co.jp> ha scritto:
> > 
> >> > Hi noriyuki,
> >> > Currently I'm using pgpool (3.7.3 amefuriboshi) with bdr 9.4.21.
> >> > I've configured master_slave_sub_mode to logical.
> >> > Pgpool and bdr were build from source code.
> >> > Still wondering to myself if using pgpool with bdr had meaning or not.
> >> > Regards,
> >> > luca
> >>
> >> Pgpool-II 3.7 is not prepared for logical replication. I guess all
> >> write queries are always sent to one of the bdr masters (so it's not
> >> actually work as BDR).
> >>
> >> Best regards,
> >> --
> >> Tatsuo Ishii
> >> SRA OSS, Inc. Japan
> >> English: http://www.sraoss.co.jp/index_en.php
> >> Japanese:http://www.sraoss.co.jp
> >>
> >> > Il lun 21 ott 2019, 04:24 Noriyuki Hayashi <nhayashi at wats.gr.jp> ha
> >> scritto:
> >> >
> >> >> Hi Tatsuo-san and All,
> >> >>
> >> >> I hope everybody is well.
> >> >> I am wondering possiblity Postgres-BDR-9.21 with Pgpoo-II.
> >> >> Does anyone try to use Postgres-BDR-9.21 with Pgpoo-II?
> >> >>
> >> >> Pgpool-II is so good for LB with reading.
> >> >> BDR is working for multi master fine.
> >> >>
> >> >> KInd regards,
> >> >> Noriyuki Hayashi
> >> >> /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> >> >>
> >> >> Telecommunications Association License No. A-18-9191
> >> >> Government Resell  License No. 301039703002
> >> >>               WATS CO.,LTD.
> >> >>   Kawana Bldg, 5F  Kamata
> >> >> Ota-ku Tokyo, 144-0052 JAPAN
> >> >>        Phone 81-50-5830-5940
> >> >>        Ext&Mobile：201 VoiceMailDirect：201*1
> >> >>        FAX   81-50-5830-5941
> >> >>             http://wats.gr.jp
> >> >>           Mail： wats @ wats.gr.jp
> >> >> Please remove the space between @ as double side
> >> >>
> >> >> Key fingerprint = B53D FF2F BFEA FDA8 1439  38AA 8281 9A3E C9B6 2FC9
> >> >>
> >> >> /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> >> >>
> >> >> _______________________________________________
> >> >> pgpool-general mailing list
> >> >> pgpool-general at pgpool.net
> >> >> http://www.pgpool.net/mailman/listinfo/pgpool-general
> >> >>
> >>

/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

Telecommunications Association License No. A-18-9191
Government Resell  License No. 301039703002
              WATS CO.,LTD.   
  Kawana Bldg, 5F  Kamata
Ota-ku Tokyo, 144-0052 JAPAN
       Phone 81-50-5830-5940　
       Ext&Mobile：201 VoiceMailDirect：201*1
       FAX   81-50-5830-5941
            http://wats.gr.jp
          Mail： wats @ wats.gr.jp
Please remove the space between @ as double side

Key fingerprint = B53D FF2F BFEA FDA8 1439  38AA 8281 9A3E C9B6 2FC9

/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/