RE: Multi-Master Logical Replication

From: "kuroda(dot)hayato(at)fujitsu(dot)com" <kuroda(dot)hayato(at)fujitsu(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>, vignesh C <vignesh21(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, 'Bruce Momjian' <bruce(at)momjian(dot)us>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Subject: RE: Multi-Master Logical Replication
Date: 2022-05-30 09:49:58
Message-ID: TYAPR01MB5866E42E2BC98EEDBC97C610F5DD9@TYAPR01MB5866.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dear hackers,

I added documentation more and tap-tests about LRG.
Same as previous e-mail, 0001 and 0002 are copied from [1].

Following lists are the TODO of patches, they will be solved one by one.

## Functional

* implement a new state "waitforlsncatchup",
that waits until the upstream node receives the latest lsn of the remaining nodes,
* implement an over-node locking mechanism
* implement operations that shares initial data
* implement mechanisms to avoid concurrent API execution

Note that tap-test must be also added if above are added.

## Implemental

* consider failure-handing while executing APIs
* add error codes for LRG
* move elog() to ereport() for native language support
* define pg_lrg_nodes that has NULL-able attribute as proper style

[1]: https://commitfest.postgresql.org/38/3610/

Best Regards,
Hayato Kuroda
FUJITSU LIMITED

Attachment Content-Type Size
v3-0003-PoC-implement-LRG.patch application/octet-stream 72.1 KB
v3-0004-add-tap-tests.patch application/octet-stream 17.4 KB
v3-0005-add-documents.patch application/octet-stream 30.0 KB
v16-0001-Skip-replication-of-non-local-data.patch application/octet-stream 57.2 KB
v16-0002-Support-force-option-for-copy_data-check-and-thr.patch application/octet-stream 52.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2022-05-30 11:38:21 Re: Perform streaming logical transactions by background workers and parallel apply
Previous Message Andrey Borodin 2022-05-30 09:40:06 Amcheck verification of GiST and GIN