Lobster Programming
Author

Lobster Programming

Sharing insights on technical analysis and exchange, making life better through technology.

170
Articles
0
Likes
1.2k
Views
0
Comments
Recent Articles

Latest from Lobster Programming

100 recent articles max
Lobster Programming
Lobster Programming
Sep 14, 2026 · Databases

Three-Field Schema for Encrypted Phone Number Queries by Last Four Digits

The article analyzes flawed approaches for querying encrypted phone numbers by last four digits — memory decryption, ciphertext fuzzy matching, partial encryption, and mapping tables — and presents a three-field design (full ciphertext, masked display, indexed last-four plaintext) that ensures compliance, security, and millisecond query performance at million-user scale.

AES-256SM4compliance
0 likes · 6 min read
Three-Field Schema for Encrypted Phone Number Queries by Last Four Digits
Lobster Programming
Lobster Programming
Aug 31, 2026 · Databases

How MySQL Repeatable Read Solves Phantom Reads with MVCC and Next-Key Locks

This article explains how MySQL's Repeatable Read isolation level prevents phantom reads by combining MVCC snapshot reads for consistent views and Next-Key Locks (record + gap locks) to block inserts during current reads like UPDATE, detailing the ReadView mechanism, version chains, and a concrete phantom read scenario.

Gap LockIsolation LevelMVCC
0 likes · 8 min read
How MySQL Repeatable Read Solves Phantom Reads with MVCC and Next-Key Locks
Lobster Programming
Lobster Programming
Aug 17, 2026 · Backend Development

How to Prevent Message Loss in RocketMQ: Producer, Broker, and Consumer Strategies

The article explains why messages can be lost in RocketMQ at the producer, broker, or consumer level and provides concrete strategies—including synchronous sending, async retries, synchronous disk flush, synchronous replication, and manual consumer acknowledgment with dead‑letter monitoring—to ensure reliable delivery.

Asynchronous SendBroker ConfigurationConsumer Acknowledgment
0 likes · 9 min read
How to Prevent Message Loss in RocketMQ: Producer, Broker, and Consumer Strategies
Lobster Programming
Lobster Programming
Aug 10, 2026 · Backend Development

Designing Efficient Read/Unread Tracking for One-on-One and Group Chats

The article examines how to implement read/unread status for single and group chats at scale, comparing a simple last‑read‑ID approach for one‑on‑one conversations with database, Redis hash, and bitmap‑watermark solutions for groups, and discusses their performance and memory trade‑offs.

BackendBitMapMySQL
0 likes · 7 min read
Designing Efficient Read/Unread Tracking for One-on-One and Group Chats
Lobster Programming
Lobster Programming
Aug 3, 2026 · Databases

How to Eliminate MySQL Master‑Slave Lag: Parallel Replication, Read‑Routing, and Redis Marking

To address MySQL master‑slave replication lag, the article explains enabling parallel replication (setting slave_parallel_workers), routing reads to the master for latency‑sensitive operations, and using a Redis short‑term marker to direct recent writes to the master, while outlining configuration steps and trade‑offs.

Database LagMySQLParallel Replication
0 likes · 6 min read
How to Eliminate MySQL Master‑Slave Lag: Parallel Replication, Read‑Routing, and Redis Marking
Lobster Programming
Lobster Programming
Jul 27, 2026 · Backend Development

Mastering Liteflow: Core Concepts and a Real‑World Spring Boot Demo

This article introduces the Liteflow rule‑engine framework, explains its core concepts, syntax, and configuration options, and walks through a complete Spring Boot 3.2 / Java 17 project that demonstrates building, deploying, and testing a multi‑step workflow with practical code examples.

EL SyntaxJava 17LiteFlow
0 likes · 14 min read
Mastering Liteflow: Core Concepts and a Real‑World Spring Boot Demo
Lobster Programming
Lobster Programming
Jul 20, 2026 · Fundamentals

A Comprehensive Guide to New Features from JDK 8 Through JDK 27

The article systematically outlines the major new features introduced in JDK 8 and each subsequent release up to JDK 27, highlighting language enhancements, API additions, module system, garbage collectors, virtual threads, and offering migration recommendations for different project scenarios.

JDKJavaLanguage Features
0 likes · 10 min read
A Comprehensive Guide to New Features from JDK 8 Through JDK 27
Lobster Programming
Lobster Programming
Jul 13, 2026 · Backend Development

Three‑layer mechanism to ensure a single charge for repeated payment attempts

The article explains a three‑layer strategy—pre‑intercept via Redis locks or temporary tokens, mid‑process control using order status and optimistic locking, and post‑fallback with delayed MQ messages and nightly reconciliation—to guarantee that multiple user clicks result in only one successful payment.

Distributed LockOptimistic LockToken
0 likes · 7 min read
Three‑layer mechanism to ensure a single charge for repeated payment attempts
Lobster Programming
Lobster Programming
Jul 6, 2026 · Backend Development

Why Kafka Achieves Such High Throughput

Kafka’s exceptionally high throughput stems from a combination of design choices—including sequential disk writes, zero‑copy data transfer, batch processing, partition‑level parallelism, OS page‑cache utilization, and producer‑side compression—that together minimize I/O overhead, CPU usage, and latency.

CompressionKafkaPartitioning
0 likes · 6 min read
Why Kafka Achieves Such High Throughput