search

avalon566 / sharding-scaling

Apache License 2.0
10 stars 4 forks source link

PostgreSQL's Logical Replication implemention #8

Open dongzl opened 5 years ago

dongzl commented 5 years ago

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.

dongzl commented 5 years ago

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?

dongzl commented 5 years ago

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?

avalon566 commented 5 years ago

@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 commented 5 years ago

@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.

avalon566 commented 5 years ago

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