The Dual-Write Problem

A dual write is when the application writes to two systems: the database and a message queue (or search index, or cache). It sounds reasonable but it creates a consistency problem that has no simple fix. This is the trap the interviewer is waiting for. The Dual-Write Failure Modes The Fix: Outbox Pattern When Dual Writes Are Acceptable