After geo routing (29 Oct), this post covers dual writes: partial failure, fake 2PC, single source of record, outbox alternatives, forced-window guards, reconciliation, migration-only dual periods and how CDC or event logs differ.

द्वैधलेखनधर्मः: A Metrical Codification of Dual Writes (with English glosses)

What this post is about

Dual writes attempt two independent durable updates in one business action without a shared commit. They are a common source of silent split truth.

Topics covered

1. Why dual write diverges
2. Partial success ghosts
3. No fake distributed TX
4. One system of record
5. Outbox or log then project
6. Idempotency if temporarily forced
7. Continuous reconciliation
8. Short migration windows only
9. Search and cache as derived
10. Contrast with CDC and event sourcing

Sanskrit title

द्वैधलेखनधर्मः = dvaidha-lekhana-dharmaḥ “dharma of twofold writing”.

English

Minimizable; Sanskrit-first.

ग्राह्यम् / Keep

१. one system of record: always preferred
२. project via outbox/log: not dual sync APIs
३. idempotency both sides: if forced
४. reconcile continuously: detect drift
५. migration dual window: time-boxed
६. search/cache derived: never twin primary
७. page on unrepaired drift: not silent hope

त्याज्यम् / Avoid

• two sync writes in one request as permanent design
• assume SaaS joins your 2PC
• skip reconcile because it usually works

पदच्छेदः
एककार्यं द्वयोः भण्डारयोः यदि युगपद् लिख्यते । द्वैधलेखनधर्मस्तस्माद् विसंवादाभयम् ॥१॥

Word-for-word

Gloss table

English sense
Dual writes update two systems in one business action without a shared transaction. Partial success creates permanent divergence.

Context / topic
Topic: why dual write is dangerous. Distinct from intentional CDC fan-out from one log.

वृत्तमिति: ८-८-८-८।

पदच्छेदः
A ok B fail = ghost truth । retry blindly द्विगुणदोषः ॥२॥

Word-for-word

Gloss table

English sense
When the second write fails you have a half-applied fact. Blind retries can double-apply the side that already succeeded.

Context / topic
Topic: partial failure.

वृत्तमिति: ८-८-८-८।

पदच्छेदः
no distributed TX across alien stores । hope-2PC मिथ्या ॥३॥

Word-for-word

Gloss table

English sense
Most SaaS and search indexes do not join your database two-phase commit. Do not pretend they do.

Context / topic
Topic: no fake 2PC.

वृत्तमिति: ८-८-८-८।

पदच्छेदः
single source + derived project । dual primary writes त्याज्यम् ॥४॥

Word-for-word

Gloss table

English sense
Write once to the system of record and project outward. Two equal primaries are dual write by another name.

Context / topic
Topic: one writer of truth.

वृत्तमिति: ८-८-८-८।

पदच्छेदः
outbox then consumer एकजन्म । direct dual API युद्धाय ॥५॥

Word-for-word

Gloss table

English sense
Prefer transactional outbox or change log then async consumers over two synchronous API writes in the request path.

Context / topic
Topic: outbox alternative.

वृत्तमिति: एकादशाक्षराः पादाः।

पदच्छेदः
idempotency keys on both sides if forced । अकुञ्चिकं द्वैधं अन्धम् ॥६॥

Word-for-word

Gloss table

English sense
If dual write is temporarily forced, give every side a stable idempotency key and a reconcile job.

Context / topic
Topic: forced dual write guards.

वृत्तमिति: ८-८-८-८।

पदच्छेदः
reconcile job compares checksums । drift silent प्रेतः ॥७॥

Word-for-word

Gloss table

English sense
Run continuous reconciliation that repairs or pages on drift. Unwatched dual stores diverge quietly.

Context / topic
Topic: reconciliation.

वृत्तमिति: ८-८-८-८।

पदच्छेदः
migration dual-write window short । forever dual ऋणम् ॥८॥

Word-for-word

Gloss table

English sense
A short dual-write cutover for migration can be planned. Permanent dual write is unpaid architectural debt.

Context / topic
Topic: migration only.

वृत्तमिति: ८-८-८-८।

पदच्छेदः
search cache analytics = derived not twin primary । index write beside DB dual ॥९॥

Word-for-word

Gloss table

English sense
Search indexes and caches should follow the log or outbox. Writing them in the same request as the DB is dual write.

Context / topic
Topic: search and cache.

वृत्तमिति: ८-८-८-८।

पदच्छेदः
CDC एकश्रुतिः बहूपयोगः द्वैधं द्वौ लेखनौ । घटनास्रोतः एकपङ्क्तिः ॥१०॥

Word-for-word

Gloss table

English sense
CDC and event logs fan out from one ordered source. Dual write invents two independent sources in one action.

Context / topic
Topic: series distinctions.

सन्धिः: CDC/ES एकस्रोतः; द्वैध द्विस्रोतः।

वृत्तमिति: एकादशाक्षराः पादाः।

पदच्छेदः
one-source outbox idempotency reconcile short-window पञ्चकम् । एभिर्द्वैधलेखनधर्मो विसंवादभयसमन्वितः ॥११॥

Word-for-word

Gloss table

English sense
Five limbs: one system of record, outbox or log projection, keys if forced, continuous reconcile and short migration windows only.

Context / topic
Topic: checklist.

वृत्तमिति: ८-८-८-८।

पदच्छेदः
इति द्वैधलेखनधर्मसारो विसंवादभयसमन्वितः । मितमेकलेखनं क्रियायोग्यं तन्त्रधर्मः स उच्यते ॥१२॥

Word-for-word

Gloss table

English sense
Closing: write once, project many times and never leave two primaries unreconciled.

Context / topic
Topic: close.

उपसंहारन्यायः: एकं लिख; बहु प्रक्षिप; द्वौ मा युगपत् प्राथम्येन।

वृत्तमिति: ८-८-८-८।

१. Why dual write
२. Partial fail
३. No 2PC
४. One source
५. Outbox
६. Keys if forced
७. Reconcile
८. Migration window
९. Derived indexes
१०. CDC/ES
११. Five limbs
१२. Close

1. Prior: outbox 2026-09-28; CDC 2026-10-13; event sourcing 2026-10-25; idempotency 2026-10-04.
2. Domain: dual-write anti-pattern and guards.
3. English minimizable; Sanskrit-first.
4. Style: no em dash; no Oxford comma in English clauses.