Change Data Capture (CDC)

Source                         Zwiron                       Destination
──────                         ──────                       ───────────
INSERT → written to log  ──▶  reads log  ──▶  INSERT
UPDATE → written to log  ──▶  reads log  ──▶  UPDATE
DELETE → written to log  ──▶  reads log  ──▶  DELETE

wal_level = logical
max_replication_slots = 5
max_wal_senders = 5

CREATE USER zwiron_cdc WITH REPLICATION LOGIN PASSWORD 'your_password';
GRANT SELECT ON ALL TABLES IN SCHEMA public TO zwiron_cdc;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO zwiron_cdc;

CREATE PUBLICATION zwiron_pub FOR ALL TABLES;

[mysqld]
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
binlog_format = ROW
binlog_row_image = FULL
expire_logs_days = 7

CREATE USER 'zwiron_cdc'@'%' IDENTIFIED BY 'your_password';
GRANT SELECT, RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'zwiron_cdc'@'%';
FLUSH PRIVILEGES;