BestHub
Sign in
Lobster Programming
Author

Lobster Programming

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

174
Articles
0
Likes
1.5k
Views
0
Comments
Recent Articles

Latest from Lobster Programming

100 recent articles max
Lobster Programming
Lobster Programming
Oct 15, 2026 · Fundamentals

AQS Unveiled: State, CLH Queue, and Template Method in Java Concurrency

This article explains Java's AbstractQueuedSynchronizer (AQS) core model using a service counter analogy, detailing how the state variable and CLH queue manage thread synchronization, the template method pattern separating queuing logic from acquisition rules, and how LockSupport.park/unpark enable efficient thread blocking and waking, illustrated with ReentrantLock and CountDownLatch examples.

AQSAbstractQueuedSynchronizerCLH Queue
0 likes · 7 min read
AQS Unveiled: State, CLH Queue, and Template Method in Java Concurrency
Lobster Programming
Lobster Programming
Oct 8, 2026 · Backend Development

MCP for Java Development and Testing: MySQL & Browser Automation Guide

This article explains the Model Context Protocol (MCP), its architecture and communication methods, then demonstrates how to build and configure a MySQL-MCP server in Python, integrate it with AI tools like Workbuddy, and use browser automation via MCP for automated testing of web applications.

AI toolsJava developmentMCP
0 likes · 10 min read
MCP for Java Development and Testing: MySQL & Browser Automation Guide
Lobster Programming
Lobster Programming
Sep 29, 2026 · Databases

Why Vector Databases Are Essential Beyond Relational Databases for AI

This article explains why vector databases like Milvus and Qdrant are necessary for AI applications despite the existence of relational databases like MySQL, detailing differences in indexing (ANN vs B+ trees), query logic (similarity vs exact match), consistency models, data structures, and ideal use cases such as RAG and recommendation systems.

AI embeddingsANN indexesHNSW
0 likes · 6 min read
Why Vector Databases Are Essential Beyond Relational Databases for AI
Lobster Programming
Lobster Programming
Sep 21, 2026 · Backend Development

5 Ways to Prevent API Replay Attacks: From Nonces to Idempotency Keys

This article explains five practical solutions to prevent API replay attacks, including unique nonces with Redis storage, timestamp validation, combined signature-timestamp-nonce schemes, backend-issued one-time tokens, and business-level idempotency keys for critical operations like payments.

API securityBackend DevelopmentRedis
0 likes · 6 min read
5 Ways to Prevent API Replay Attacks: From Nonces to Idempotency Keys
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-256ComplianceSM4
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.

BitmapMySQLRedis
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 LagMySQLRead Routing
0 likes · 6 min read
How to Eliminate MySQL Master‑Slave Lag: Parallel Replication, Read‑Routing, and Redis Marking