BestHub
Sign in
Tag

transaction consistency

0 views collected around this technical thread.

Lobster Programming
Lobster Programming
Apr 17, 2025 · Backend Development

How Local Message Tables Solve Distributed Transaction Challenges

Using a local message table, developers can break down distributed transactions into local database operations and asynchronous MQ messages, ensuring eventual consistency, simplifying implementation, and handling retries, while balancing advantages like simplicity and compatibility against drawbacks such as added maintenance and potential queue dependencies.

Distributed SystemsMessage Queuebackend architecture
0 likes · 5 min read
How Local Message Tables Solve Distributed Transaction Challenges
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 29, 2021 · Databases

Resolving GTID Consistency Errors When Updating InnoDB and MyISAM Tables in MySQL

The article explains why MySQL raises a GTID consistency error when a single transaction updates both InnoDB and MyISAM tables, demonstrates how to reproduce the issue, and evaluates three mitigation strategies: separating the updates, converting MyISAM to InnoDB, or disabling ENFORCE_GTID_CONSISTENCY.

Database AdministrationGTIDInnoDB
0 likes · 6 min read
Resolving GTID Consistency Errors When Updating InnoDB and MyISAM Tables in MySQL
Selected Java Interview Questions
Selected Java Interview Questions
Feb 28, 2020 · Databases

Asynchronous Flow‑Log Approach for Transaction Consistency in Sharded Databases

The article explains how to maintain transaction consistency between a primary database and sharded tables by using a flow‑log table and an asynchronous processor that ensures eventual consistency, handles ordering, retries, and avoids the complexity of transactional message queues.

Distributed Systemsasynchronous processingdatabases
0 likes · 9 min read
Asynchronous Flow‑Log Approach for Transaction Consistency in Sharded Databases