is it possible to replicate only a partition ?

vcarusivcarusi Registered User

Hi,
I have a big table around 100G/1600 columns/3 partitions. I need to replicate only a partition.

I found a solution :

  • copy the partition into a second table,
  • replicate this table

The downside is that all records from the first table are copied into the second table.
I would delete the second table and re-create it. But, I am afraid that the server will replicate (again) entire table. And I want to replicate only the last modifications.

Did someone have to replicate a partition ?
Thank you,
Veronica

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file