From: | "r(dot)takahashi_2(at)fujitsu(dot)com" <r(dot)takahashi_2(at)fujitsu(dot)com> |
---|---|
To: | 'Amit Kapila' <amit(dot)kapila16(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> |
Cc: | Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | RE: Multi-Master Logical Replication |
Date: | 2022-06-13 11:02:40 |
Message-ID: | TYCPR01MB5693F4CC8E1AB1294235A5AE82AB9@TYCPR01MB5693.jpnprd01.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
In addition to the use cases mentioned above, some users want to use n-way
replication of partial database.
The following is the typical use case.
* There are several data centers.
(ex. Japan and India)
* The database in each data center has its unique data.
(ex. the database in Japan has the data related to Japan)
* There are some common data.
(ex. the shipment data from Japan to India should be stored on both database)
* To replicate common data, users want to use n-way replication.
The current POC patch seems to support only n-way replication of entire database,
but I think we should support n-way replication of partial database to achieve
above use case.
> I don't know if it requires the kind of code you are thinking but I
> agree that it is worth considering implementing it as an extension.
I think the other advantage to implement as an extension is that users could
install the extension to older Postgres.
As mentioned in previous email, the one use case of n-way replication is migration
from older Postgres to newer Postgres.
If we implement as an extension, users could use n-way replication for migration
from PG10 to PG16.
Regards,
Ryohei Takahashi
From | Date | Subject | |
---|---|---|---|
Next Message | Álvaro Herrera | 2022-06-13 11:09:48 | Re: Using PQexecQuery in pipeline mode produces unexpected Close messages |
Previous Message | houzj.fnst@fujitsu.com | 2022-06-13 10:08:16 | RE: Support logical replication of DDLs |