Tag

transaction splitting

0 views collected around this technical thread.

Architect
Architect
Dec 10, 2024 · Backend Development

Splitting Large Transactions to Ensure Distributed Consistency in Backend Systems

This article analyzes the challenges of distributed transaction consistency when combining MySQL writes with third‑party system calls, presents a concrete financial reimbursement case, and proposes a solution that splits a big transaction into small, retryable units using a task table, scheduled jobs, and Spring's after‑commit hook to achieve reliable consistency without excessive latency.

MySQLSpringbackend development
0 likes · 9 min read
Splitting Large Transactions to Ensure Distributed Consistency in Backend Systems
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 1, 2021 · Databases

How to Split Large Transactions in TiDB: Guidelines, Limits, and Practical Scripts

The article explains why TiDB discourages large transactions, outlines the historical transaction limits, shows how to configure size thresholds, and provides concrete scripts for splitting big updates based on primary‑key characteristics to keep transaction size within safe bounds.

Database OptimizationSQLTiDB
0 likes · 8 min read
How to Split Large Transactions in TiDB: Guidelines, Limits, and Practical Scripts