openGauss系数据库逻辑复制实现双写
好久之前写过一篇关于逻辑复制的文章openGauss/MogDB 同一个实例下完成发布订阅,现在在此基础上再添加一篇关于逻辑复制实现双写的案例,本来准备了3个环境,分别是306、501和505,奈何在5版本向3版本订阅的时候,出现了报错,但也将整个过程都记录下来吧。
环境准备
节点信息
MogDB=# select version(); version
------------------------------------------------------------------------------------------------------------------------------------------------------
(MogDB 5.0.5 build b77f1a82) compiled at 2023-12-08 03:11:47 commit 0 last mr 1804 on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)
MogDB=# show wal_level ;
wal_level
-----------
logical
(1 row)
MogDB=# select version();
version
------------------------------------------------------------------------------------------------------------------------------------------------------
(MogDB 5.0.1 build ae6d2ada) compiled at 2023-08-16 09:07:43 commit 0 last mr 1804 on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)
MogDB=# show wal_level ;
wal_level
-----------
logical
(1 row)
MogDB=# select version(); version
------------------------------------------------------------------------------------------------------------------------------------------------------
(MogDB 3.0.6 build 0e82b772) compiled at 2023-09-08 03:05:33 commit 0 last mr 1801 on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)
MogDB=# show wal_level ;
wal_level
-----------
logical
(1 row)