Question about using Debezium with MariaDB Galera through ProxySQL

[Martin Zelený]

Hi Debezium team,

I'm trying to figure out the best way to run the MariaDB connector against a MariaDB Galera cluster when connecting through ProxySQL, and I want to make sure I understand it correctly.

From what I've seen:

* The connector has to stick to one specific Galera node, because each node has its own binlog files/positions even though Galera replicates the same data.
* If ProxySQL fails the connection over to another node, Debezium can't continue from the stored offset, since the new node's binlog doesn't match.
* Running multiple connectors (one per node) that write to the same Kafka topics would cause duplicates.

Before I lock in the design, could you confirm whether this is accurate?
And is there any supported way to handle automatic failover for Galera, or is the only practical option to pin Debezium to a single node and do manual failover if that node goes down?

Thanks a lot for any clarification!

Martin Zeleny

[jiri.p...@gmail.com]

Hi,

in general if you run Debezium with MySQL/MariaDB cluster then you need to have GTIDs enabled. That's solution to most of your concerns.

Jiri

[Martin Zelený]

Hi Jiri,

MariaDB nodes of Galera cluster have GTID enabled. Otherwise the Galera cluster wouldn't work at all. It's a Multi-primary topology [1]. I just need to confirm that I didn't overlook anything regarding possible HA setup: MariaDB Galera cluster/ProxySQL/Debezium.

Regards,

Martin

[1] https://debezium.io/documentation/reference/stable/connectors/mariadb.html#supported-mariadb-topologies