avalon566/sharding-scaling

PostgreSQL's Logical Replication implemention

Opened this issue · 5 comments

I find some content about PostgreSQL's Logical Replication, write a program demo with PostgreSQL's JDBC API document.
the content:
Physical and Logical replication API
Logical Decoding Plugins

I will try to implement PostgreSQL's Logical Replication, about this work, do you have some good suggestions.

Logical Decoding Plugins list a lot of plugins for Logical Replication Decoding, LogicalDecode is a java project, I will read this project code to complete this work.
I only refer the code ideas, not copy all the code.
Does this is a good idea? or have other good way?

BEGIN
table public.test_logic_table: INSERT: pk[bigint]:2 name[character varying]:'test'
COMMIT

BEGIN
table public.test_table: INSERT: id[integer]:1
COMMIT

this is demo code read the logical replication data.
Parse the data,I will split the data with Blank Character, Does this is a good idea?

@dongzl There are many servre side docode plugins we can choice. I think we can use adapters to change different formats into DataRecord.
By the way I send an email to you, pls check it.

@dongzl There are many servre side docode plugins we can choice. I think we can use adapters to change different formats into DataRecord.
By the way I send an email to you, pls check it.

Hi @avalon566 , happy National Day, It is a good idea, I will think about it.
and which email address do you send to me? I check my dzllikelsw@163.com email, and don't found any email about this work from you.

@dongzl I send you again. Please check the E-mail in trush mail box, if you can't receive in the mail box.