Event Driven Architecture, Exactly One Delivery, Kafka, Message Broker, Software Development.
the transaction, in addition to msg_id in the WHERE clause we must also add handled = false, this is one of the ways to avoid MySQL having racing conditions. If we don’t add this check condition, it is still possible to process the same message twice under race conditions. There is a detailed