12.16Idempotency and database uniqueness

If Mule owns a database table:

processed_requests
------------------
request_id
status
result

make:

request_id

unique.

Then:

INSERT request_id = REQ-123

first worker succeeds.

Second worker gets unique constraint violation.

That is often much safer than:

SELECT
then
INSERT

Again: atomic enforcement.