4 ms·

I'm trying to understand if with v14 I will be able to connect Debezium to a "slave" node and not to the "master" in order to read the WAL but can't figure it o

• zozbot234 5y ago
  Whoa, I thought the proper terminology was more like primary/replica. Are we talking Postgres databases or decades-old clunky IDE hard drives?
  • PlugaruT 5y ago
    Yeah, I should have used "primary"/"replica", I agree. Somehow this words did not came to my mind. Thanks
  • slumpr 5y ago
    Both are valid. Master/slave is an older way of describing how the two are related, but most DBMSes used this terminology up until recently.
• anarazel 5y ago
  Unfortunately that didn't make it into 14, there were too many rough edges to file off.
• gunnarmorling 5y ago
  I was just yesterday talking to someone about this; they mentioned that Patroni leverages some way for setting up replication slots on replicas [1]. Haven't tried my self yet, but seems worth exploring. Something I'd like to dive into within Debezium is usage of the pg_tm_aux extension, which supposedly allows to set up replication slots "in the past", so you could use this to have seamless failover to replicas without missing any events. In any case, this entire area is of high importance for us and we're keeping an eye on any improvements closely, so I hope it will be sorted out sooner or later. [1] https://twitter.com/cyberdemn/status/1443130986116624388 https://twitter.com/cyberdemn/status/1443130986116624388 [2] https://github.com/x4m/pg_tm_aux https://github.com/x4m/pg_tm_aux
  • anarazel 5y ago
    That extension is not safe / correct afaict.