I’ve been thinking about how the Debezium JDBC Sink Connector handles failover scenarios.

In our setup, we connect to a MySQL instance using a domain name. If a failover occurs, the domain gets updated to point to a new MySQL instance (formerly a slave). Although I haven't conducted a full experiment, it seems likely that the connector would stop because the existing connection would be terminated abnormally.

Would it be possible to introduce an option for the JDBC Sink Connector to automatically retry the connection when such failover events happen? This would enhance fault tolerance and minimize downtime during failovers.