The solution I've seen is to write the message you want to send to the DB along with the transaction, and have some separate thread that tries to send the messa

The solution I've seen is to write the message you want to send to the DB along with the transaction, and have some separate thread that tries to send the messages to Kafka. Although, from various code bases I've seen, a lot of people just don't seem to worry about the possibility of data loss.