Bug report

What Debezium connector do you use and what version?

Components：debezium-server-kafka, debezium-connector-sqlserver

Version: 2.7.2

What behavior do you see?

Debezium Server 2.7.2 introduced a performance regression when it fixed a Kafka blocking issue (https://issues.redhat.com/projects/DBZ/issues/DBZ-7575).

This is due to now having to wait for the RecordMetadata of each record being produced individually. Essentially, we went from a non-blocking to a blocking producer.

For more context see this comment on GitHub:
https://github.com/debezium/debezium-server/pull/116#issuecomment-2358973382

Feature request or enhancement

Add the ability fo the Kafka Producer to operate in full non-blocking async mode.