Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature question] CDC support in Citus #7630

Open
10bdaddy opened this issue Jun 18, 2024 · 0 comments
Open

[Feature question] CDC support in Citus #7630

10bdaddy opened this issue Jun 18, 2024 · 0 comments

Comments

@10bdaddy
Copy link

I would like to ask you because I have some questions while testing the "CDC Support in Citus" feature provided from CITUS 11.3 version.

The following environments were tested first.

  1. Citus version : 12.1.3
  2. PostgreSQL version: 16.3
  3. Debezium version: 2.5.0.Beta1

And the settings that https://www.citusdata.com/updates/v11-3/#cdc_support guides are also applied to all nodes.
citus.enable_change_data_capture='on'

Also, I followed the example and there are different results from the document.

  1. CREATE PUBLICATION cdc_publication FOR TABLE sensors;
    When creating publication in this way, the CDC Event of sensor table did not occur from the worker node.

  2. CREATE PUBLICATION cdc_publication FOR ALL TABLES;
    When creating publication in this way, the CDC Event of sensor table occurred from the worker node.
    However, the document describes "This decoder translates any table name in the event from a partial shard name" as follows,
    but the message that actually occurs was issued as sensors_$shardid.

  3. The document explains, "For reference tables, this step is not required signs the changes to reference tables will be published only from co-ordinator node." However, during the test, the CDC event was not issued in the co-ordinator node with the reference table, and the event was generated in one of the worker nodes (nodeid 1).

Is there anything I'm missing in the setup by any chance?

@10bdaddy 10bdaddy changed the title [Feature request] CDC support in Citus [Feature question] CDC support in Citus Jun 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant