Exploring Cache Data Consistency

This article discusses data inconsistency between cache and database and the best choice of solutions in different business scenarios.

Use Transactional Messages to Understand RocketMQ Service Messages

This article introduces the scenarios, basic principles, implementation details, and actual use of RocketMQ transactional messages to help you use RocketMQ transactional messages.

The Principle, Response to Prevention of PostgreSQL Transaction ID Exhaustion or Exhaustion Warning

This article explains the background of Transaction ID Exhaustion, analyzes its problems, and offers ways to solve and prevent future problems.

An Interpretation of the Source Code of OceanBase (4): Life of Transaction

This article analyzes the external interfaces of database transactions of OceanBase.

Quick Creation of a Large Number of Partition Indexes in PostgreSQL

This article answers the following question, “How can I quickly create indexes for all partition tables without blocking DML operations?”