Zero-downtime database migrations

FintechBy: Mahdi Mansour Samaei2 min readSource: Civilica
Zero-downtime database migrations

1Introduction

Financial systems can’t afford downtime, but schema changes are unavoidable.

2Discussion

Expand-and-contract: add new structure, dual-write, backfill gradually, then remove the old.

Avoid long table locks, batch data moves and build indexes concurrently.

3Conclusion

Rehearse on realistic data with a rollback plan; use migration tools for history and consistency.

Share:TelegramWhatsAppLinkedIn

Sources

  1. Civilica ↗
  2. SID ↗
همفکران فناوری شریفThis article summarises the official sources cited, prepared by the Hamfekran Fanavari Sharif team for finance leaders.
Want to see these solutions in your organisation?Book a free demo

Related articles

FintechThreat hunting: finding attackers who triggered no alertHunting assumes compromise and actively searches for evidence instead of waiting for alerts.FintechSecrets management: where should passwords live?A database password in code will eventually reach the wrong hands.FintechAutomated bank reconciliation: ending manual finance workMatching bank statements to books is one of finance’s most time-consuming tasks — and ideal for automation.FintechDigital strategy for executives: where to startDigital transformation starts with a clear business question, not a software purchase.