BestHub
Sign in
Tagged articles
2678 articles
Page 16 of 27
IT Architects Alliance
IT Architects Alliance
Aug 15, 2021 · Databases

Understanding Local Transactions, ACID, CAP/BASE Theories, and Distributed Transaction Solutions (Seata, 2PC, TCC, Saga)

This article explains the fundamentals of local transactions and ACID properties, introduces CAP and BASE theories, discusses compensation jobs and transaction messages, and reviews distributed transaction models such as two‑phase commit, three‑phase commit, XA, TCC, Saga, and the Seata framework.

ACIDCAP theoremDatabase
0 likes · 15 min read
Understanding Local Transactions, ACID, CAP/BASE Theories, and Distributed Transaction Solutions (Seata, 2PC, TCC, Saga)
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 14, 2021 · Databases

Why Your MySQL Queries Are Slow and How to Fix Them with Indexes, ElasticSearch, and HBase

This article explains why MySQL queries become slow—covering index misuse, MDL locks, flush waits, row locks, and large‑table bottlenecks—then introduces ElasticSearch’s inverted‑index architecture and HBase’s column‑family storage, offering practical tips for performance tuning and hybrid solutions.

DatabaseElasticsearchHBase
0 likes · 18 min read
Why Your MySQL Queries Are Slow and How to Fix Them with Indexes, ElasticSearch, and HBase
Java Architect Essentials
Java Architect Essentials
Aug 13, 2021 · Databases

Understanding Redis Persistence: RDB and AOF Mechanisms

This article explains why Redis needs persistence, describes the two main persistence mechanisms—RDB snapshots and AOF command logging—their configuration, internal structures, operational principles, and trade‑offs, and provides practical code examples for implementing and tuning them.

AOFDatabaseIn-Memory
0 likes · 13 min read
Understanding Redis Persistence: RDB and AOF Mechanisms
Architects' Tech Alliance
Architects' Tech Alliance
Aug 11, 2021 · Databases

Database Disaster Recovery Technologies for the Financial Sector

This article examines financial sector database disaster recovery, defining disaster recovery and backup, analyzing current practices and requirements, reviewing market trends, and detailing various distributed database disaster‑recovery architectures such as single‑center, intra‑city active‑active, and multi‑site three‑center solutions.

DatabaseDistributed SystemsFinancial
0 likes · 13 min read
Database Disaster Recovery Technologies for the Financial Sector
DataFunSummit
DataFunSummit
Aug 11, 2021 · Backend Development

Technical Architecture of Alibaba's Intelligent Marketing Advertising Platform

This article presents a comprehensive overview of Alibaba's intelligent marketing advertising platform, covering business fundamentals, microservice migration, service governance, database design, real‑time data transmission, billing, reporting, and performance optimizations for high‑throughput, low‑latency ad delivery.

AdvertisingDatabaseMicroservices
0 likes · 17 min read
Technical Architecture of Alibaba's Intelligent Marketing Advertising Platform
Python Programming Learning Circle
Python Programming Learning Circle
Aug 11, 2021 · Databases

Generating One Billion SQLite Rows in Under a Minute: Python, PyPy, and Rust Performance Comparison

A programmer needed to create a billion‑row SQLite test database within a minute, found a naïve Python script unbearably slow, applied batch inserts and SQLite PRAGMA tweaks, then compared CPython, PyPy, and Rust implementations, ultimately achieving sub‑minute runtimes with Rust and highlighting best‑practice optimizations.

BenchmarkingDatabasePyPy
0 likes · 6 min read
Generating One Billion SQLite Rows in Under a Minute: Python, PyPy, and Rust Performance Comparison
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 10, 2021 · Databases

Kudu Overview: Architecture, Features, and Use Cases

Kudu is an open‑source columnar storage engine from Cloudera that combines high‑throughput batch processing with low‑latency random reads, offering features such as C++/Java APIs, Raft‑based replication, flexible consistency, partitioning, and integration with Hadoop, Spark, Impala, and other ecosystem components.

Columnar StorageDatabaseHadoop
0 likes · 64 min read
Kudu Overview: Architecture, Features, and Use Cases
Practical DevOps Architecture
Practical DevOps Architecture
Aug 9, 2021 · Operations

MySQL Installation and Configuration Bash Script

This article provides a step‑by‑step Bash script for installing, configuring, and starting MySQL 8.0 on a Linux system, including user creation, directory setup, permission handling, initialization checks, and service management, and ensures proper environment variables.

BashDatabaseInstallation
0 likes · 4 min read
MySQL Installation and Configuration Bash Script
Open Source Linux
Open Source Linux
Aug 8, 2021 · Databases

MongoDB Essentials: 52 Common Questions Answered

This comprehensive guide covers everything from MongoDB's core concepts, data model, and architecture to practical commands for creating databases, collections, indexes, sharding, replication, aggregation, and troubleshooting, providing clear answers to over fifty frequently asked questions.

DatabaseIndexesMongoDB
0 likes · 27 min read
MongoDB Essentials: 52 Common Questions Answered
MaGe Linux Operations
MaGe Linux Operations
Aug 4, 2021 · Databases

What Is MongoDB? Features, Commands, and Best Practices Explained

This article provides a comprehensive overview of MongoDB, covering its definition, document‑oriented storage, key features, differences from relational databases, sharding and replication mechanisms, common commands, data types, indexing, aggregation, and practical usage scenarios for modern applications.

DatabaseMongoDBNoSQL
0 likes · 23 min read
What Is MongoDB? Features, Commands, and Best Practices Explained
Wukong Talks Architecture
Wukong Talks Architecture
Aug 4, 2021 · Databases

Understanding MySQL InnoDB Locks: Shared, Exclusive, Intention, Gap, Next‑Key, Auto‑Inc, and Predicate Locks

The article presents a detailed interview‑style walkthrough of MySQL InnoDB locking mechanisms, covering table‑ versus row‑level locks, shared and exclusive locks, intention locks, gap and next‑key locks, auto‑increment locks, predicate locks, and related SQL statements, illustrated with tables and code examples.

ConcurrencyDatabaseInnoDB
0 likes · 13 min read
Understanding MySQL InnoDB Locks: Shared, Exclusive, Intention, Gap, Next‑Key, Auto‑Inc, and Predicate Locks
Tencent Database Technology
Tencent Database Technology
Aug 2, 2021 · Databases

MySQL 8.0 Resource Groups: Overview and Implementation

This article introduces MySQL 8.0's resource group feature, detailing its concepts, configuration commands, query hint usage, and the underlying implementation including new parser classes, platform APIs, runtime components, performance schema integration, and persistence mechanisms, with code examples throughout.

DatabaseMySQLParser
0 likes · 17 min read
MySQL 8.0 Resource Groups: Overview and Implementation
Code Ape Tech Column
Code Ape Tech Column
Aug 1, 2021 · Databases

Master MySQL Performance: Essential Tools and How to Use Them

This guide introduces four powerful MySQL performance‑tuning utilities—MySQLTuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—detailing their installation, command‑line usage, and how to interpret the generated reports to optimize database configuration and query efficiency.

DatabaseMySQLPercona
0 likes · 9 min read
Master MySQL Performance: Essential Tools and How to Use Them
IT Architects Alliance
IT Architects Alliance
Jul 26, 2021 · Databases

How to Diagnose and Fix Database IO/CPU Bottlenecks with Sharding

The article explains how IO and CPU bottlenecks increase active database connections, then details horizontal and vertical sharding techniques, practical tools, step‑by‑step implementation, and common pitfalls to help engineers relieve pressure on database resources.

CPU BottleneckDatabaseHorizontal Partition
0 likes · 10 min read
How to Diagnose and Fix Database IO/CPU Bottlenecks with Sharding
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 23, 2021 · Databases

Understanding MySQL Index Usage, Slow Queries, and Optimization Strategies

This article explains how MySQL index usage affects query performance, demonstrates that hitting an index does not guarantee speed, explores slow‑query logging parameters, shows practical experiments with EXPLAIN, and presents optimization techniques such as composite indexes, index condition push‑down, and virtual columns to reduce row scans.

DatabaseMySQLindex
0 likes · 11 min read
Understanding MySQL Index Usage, Slow Queries, and Optimization Strategies
Open Source Linux
Open Source Linux
Jul 22, 2021 · Databases

Master SQL: Essential Syntax, Queries, and Advanced Techniques

This comprehensive guide covers SQL fundamentals—including database terminology, syntax structure, DDL/DML/TCL/DCL commands, CRUD operations, subqueries, joins, unions, functions, ordering, grouping, indexes, constraints, transactions, permissions, stored procedures, cursors, and triggers—providing clear examples and best practices for relational database development.

CRUDDatabaseStored Procedures
0 likes · 26 min read
Master SQL: Essential Syntax, Queries, and Advanced Techniques
Programmer DD
Programmer DD
Jul 22, 2021 · Backend Development

How to Achieve Exactly‑Once Message Processing in RocketMQ Without Heavy Transactions

This article explains why message middleware guarantees at‑least‑once delivery, the challenges of duplicate consumption, and presents both simple and advanced deduplication strategies—including transactional and non‑transactional approaches using relational databases or Redis—to achieve effectively exactly‑once semantics in RocketMQ.

DatabaseExactly-OnceIdempotence
0 likes · 18 min read
How to Achieve Exactly‑Once Message Processing in RocketMQ Without Heavy Transactions
Java Backend Technology
Java Backend Technology
Jul 20, 2021 · Backend Development

How to Implement Efficient MyBatis Streaming Queries in Spring

Streaming queries return an iterator instead of a full result set, reducing memory usage, but require keeping the database connection open; this guide explains MyBatis’s Cursor interface, its methods, and three practical ways—using SqlSessionFactory, TransactionTemplate, or @Transactional—to safely perform MyBatis streaming queries in Spring.

CursorDatabaseJava
0 likes · 7 min read
How to Implement Efficient MyBatis Streaming Queries in Spring
Programmer DD
Programmer DD
Jul 11, 2021 · Databases

Inside MyBatis Transactions: The Real Story of JDBC Commit, Rollback & Close

This article demystifies MyBatis transaction handling by explaining the true JDBC methods—setAutoCommit, commit, rollback—and clarifying common misconceptions about create, begin, close, and suspend, while exploring MyBatis’s Transaction, TransactionFactory, and practical code examples that illustrate how commits, rollbacks, and connection closing behave in various scenarios.

DatabaseJDBCMyBatis
0 likes · 10 min read
Inside MyBatis Transactions: The Real Story of JDBC Commit, Rollback & Close
Selected Java Interview Questions
Selected Java Interview Questions
Jul 7, 2021 · Operations

Redis Monitoring Metrics and Commands Guide

This article provides a comprehensive overview of Redis monitoring metrics—including performance, memory, basic activity, persistence, and error indicators—along with recommended monitoring tools, configuration settings, and command-line examples for gathering and interpreting these metrics in production environments.

DatabaseMetricsOperations
0 likes · 7 min read
Redis Monitoring Metrics and Commands Guide
dbaplus Community
dbaplus Community
Jul 6, 2021 · Databases

Why Do MySQL Transactions Deadlock and How Can You Prevent It?

This article explains the root causes of MySQL deadlocks in InnoDB, walks through transaction and lock fundamentals, analyzes real‑world log cases, and presents practical solutions such as adjusting isolation levels, using SELECT FOR UPDATE, adding unique indexes, or checking existence before deletion to eliminate deadlocks.

DatabaseInnoDBLock
0 likes · 12 min read
Why Do MySQL Transactions Deadlock and How Can You Prevent It?
Efficient Ops
Efficient Ops
Jul 5, 2021 · Operations

10 Essential Practices to Prevent DBA and Ops Disasters

Learn ten practical strategies—from safe change rollbacks and cautious destructive commands to robust backups, clear prompts, vigilant monitoring, and disciplined handovers—that help DBAs and operations engineers avoid costly system failures and maintain reliable production environments.

DatabaseOperationsOracle
0 likes · 6 min read
10 Essential Practices to Prevent DBA and Ops Disasters
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 5, 2021 · Databases

Fetching the Latest Record per Name Group in MySQL 5.6/5.7

The article explains why a simple GROUP BY query in MySQL 5.6 returns the earliest rows instead of the most recent ones, demonstrates how to correctly obtain the latest record per name using sub‑queries or window functions, and discusses the impact of the ONLY_FULL_GROUP_BY mode in MySQL 5.7.

DatabaseGROUP BYMySQL
0 likes · 5 min read
Fetching the Latest Record per Name Group in MySQL 5.6/5.7
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 2, 2021 · Databases

Observing the Effects of MySQL Group Commit through Experiments

Through a series of experiments using MySQL 8.0, this article demonstrates how group commit reduces I/O operations by consolidating multiple transactions into a single commit group, showing that doubling load increases runtime modestly while transaction count and commit groups rise significantly, highlighting performance benefits.

DatabaseGroup CommitIO optimization
0 likes · 4 min read
Observing the Effects of MySQL Group Commit through Experiments
Code Ape Tech Column
Code Ape Tech Column
Jun 30, 2021 · Databases

Implementing Like Functionality with Redis Bitmaps

This article explains how to use Redis bitmap operations to efficiently implement like, sign‑in, and other binary state features, covering bitmap fundamentals, common use cases, essential commands, Java code examples with Jedis, and range query techniques.

BackendDatabaseJava
0 likes · 7 min read
Implementing Like Functionality with Redis Bitmaps
Alibaba Cloud Native
Alibaba Cloud Native
Jun 28, 2021 · Cloud Native

How Chanjet Scaled SaaS for 1.3M SMEs with Cloud‑Native Architecture

Chanjet transformed its monolithic SaaS platform for millions of small‑business customers by adopting a cloud‑native, container‑based micro‑service architecture, enabling elastic scaling, reduced operational costs, unified data services, automated DevOps pipelines, and comprehensive observability across front‑end, back‑end, and infrastructure layers.

DatabaseDevOpsMicroservices
0 likes · 27 min read
How Chanjet Scaled SaaS for 1.3M SMEs with Cloud‑Native Architecture
Architecture Digest
Architecture Digest
Jun 27, 2021 · Backend Development

Scalable Architecture Without Magic: Principles and Practical Setups

The article outlines practical principles for building scalable, stateless backend architectures—choosing the right tools, using multiple servers, applying caching and rate limiting, delegating responsibilities to databases, handling large data volumes, and presenting example configurations from small to massive deployments.

CachingDatabaseScalability
0 likes · 11 min read
Scalable Architecture Without Magic: Principles and Practical Setups
Java Backend Technology
Java Backend Technology
Jun 20, 2021 · Databases

Avoid These 10 Fatal SQL Mistakes Every Java Developer Makes

Java developers often mishandle SQL, leading to performance, correctness, and maintenance issues; this article outlines ten common pitfalls—from misunderstanding NULL and misusing UNION to neglecting MERGE and batch inserts—and provides practical solutions to write efficient, reliable database queries.

Best PracticesDatabaseJDBC
0 likes · 11 min read
Avoid These 10 Fatal SQL Mistakes Every Java Developer Makes
IT Architects Alliance
IT Architects Alliance
Jun 20, 2021 · Databases

Master‑Slave Replication Pitfalls and Deep Dive into Redis Sentinel

This article examines the limitations of Redis master‑slave replication, such as manual failover and single‑node bottlenecks, and provides an in‑depth exploration of Redis Sentinel’s architecture, configuration parameters, detection mechanisms, automatic failover process, and best‑practice recommendations for achieving high availability.

DatabaseRedisfailover
0 likes · 11 min read
Master‑Slave Replication Pitfalls and Deep Dive into Redis Sentinel
Top Architect
Top Architect
Jun 19, 2021 · Databases

SQL Query Performance Optimization Tips

This article provides a comprehensive collection of practical MySQL and SQL performance optimization techniques, covering index usage, query rewriting, avoiding full table scans, proper data types, efficient joins, backup strategies, and other best practices to improve database speed and reliability.

DatabaseIndexesMySQL
0 likes · 18 min read
SQL Query Performance Optimization Tips
Laravel Tech Community
Laravel Tech Community
Jun 18, 2021 · Databases

Understanding NULL Values in Databases

This article explains the special nature of NULL in SQL, how to correctly test for NULL using IS NULL, the three‑valued logic of true/false/unknown, and the pitfalls of NOT, NOT IN, and Oracle’s handling of empty strings versus NULL.

DatabaseIS NULLNULL
0 likes · 6 min read
Understanding NULL Values in Databases
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 18, 2021 · Databases

How to Compile a Debug Version of MySQL Using Docker

This article explains step‑by‑step how to build a MySQL debug binary inside a Docker container, covering environment preparation, dependency installation, configuring the build with CMake, compiling, and locating the resulting mysqld‑debug executable, while also noting performance trade‑offs of debug builds.

CMakeDatabaseDebug Build
0 likes · 3 min read
How to Compile a Debug Version of MySQL Using Docker
Wukong Talks Architecture
Wukong Talks Architecture
Jun 17, 2021 · Databases

Ensuring Data Consistency Without Native Transactions in MongoDB

The article explains how lack of native transactions in MongoDB 3.0 can cause data inconsistency during order processing, compares it with SQL transaction mechanisms, and proposes optimization and compensation strategies such as retry queues, asynchronous tasks, and refund handling to ensure eventual consistency.

Backend DevelopmentCompensationData Consistency
0 likes · 10 min read
Ensuring Data Consistency Without Native Transactions in MongoDB
Xianyu Technology
Xianyu Technology
Jun 17, 2021 · Mobile Development

Flutter-based IM Architecture Redesign for Xianyu

The Xianyu instant‑messaging system, burdened by years of technical debt, was rebuilt with a Flutter‑centric, four‑layer architecture that shares FlutterEngine instances, introduces an entity cache and custom ORM, simplifies synchronization, and delivers up to 40 MB memory savings, lower power use, reduced CPU load and roughly half the development and testing effort.

DatabaseFlutterIM
0 likes · 11 min read
Flutter-based IM Architecture Redesign for Xianyu
IT Xianyu
IT Xianyu
Jun 16, 2021 · Databases

Understanding Database Connection Pools vs. ThreadLocal in Java

This article explains the fundamental differences between database connection pools and ThreadLocal‑cached connections in Java, illustrating how connection pools improve performance while ThreadLocal enables sharing a single connection across methods within the same thread for consistent transaction control, and discusses practical usage patterns.

Backend DevelopmentConnection PoolDatabase
0 likes · 7 min read
Understanding Database Connection Pools vs. ThreadLocal in Java
Laravel Tech Community
Laravel Tech Community
Jun 15, 2021 · Backend Development

PDO::inTransaction – Checking If Inside a Transaction

The PDO::inTransaction method returns a boolean indicating whether the current database connection is actively inside a transaction, works only with drivers that support transactions, takes no parameters, and returns TRUE on success and FALSE on failure.

BackendDatabasePDO
0 likes · 1 min read
PDO::inTransaction – Checking If Inside a Transaction
Laravel Tech Community
Laravel Tech Community
Jun 14, 2021 · Backend Development

PDO::rollBack – Rolling Back a Transaction in PHP

The article explains how the PHP PDO::rollBack() method aborts the current transaction, restores autocommit mode when needed, outlines its parameter‑less signature, return values, and provides a complete code example demonstrating transaction handling and rollback behavior.

BackendDatabasePDO
0 likes · 2 min read
PDO::rollBack – Rolling Back a Transaction in PHP
IT Xianyu
IT Xianyu
Jun 11, 2021 · Databases

10 Common Mistakes Java Developers Make When Writing SQL

The article outlines ten frequent errors that Java programmers encounter when writing SQL—ranging from misunderstanding NULL handling to misusing UNION, pagination, and batch inserts—and provides practical solutions to improve correctness, performance, and maintainability of database interactions.

Best PracticesDatabaseJDBC
0 likes · 9 min read
10 Common Mistakes Java Developers Make When Writing SQL
Alibaba Cloud Developer
Alibaba Cloud Developer
Jun 10, 2021 · Databases

Why Hand‑Written SQL Parsers Outperform Auto‑Generated Ones: Design & Performance Insights

This article examines the trade‑offs between automatically generated and manually crafted SQL parsers, detailing lexical‑syntax analysis techniques, performance challenges in OLAP workloads, and the authors’ custom parser design that achieves up to 30‑50× speed gains in complex queries and bulk inserts.

DatabaseParserlexical analysis
0 likes · 17 min read
Why Hand‑Written SQL Parsers Outperform Auto‑Generated Ones: Design & Performance Insights
Laravel Tech Community
Laravel Tech Community
Jun 9, 2021 · Backend Development

PDO::inTransaction – Check If Inside a Transaction

PDO::inTransaction is a PHP PDO method that returns a boolean indicating whether the current database connection is actively within a transaction, applicable only to drivers that support transactions, and it takes no parameters.

BackendDatabasePDO
0 likes · 1 min read
PDO::inTransaction – Check If Inside a Transaction
Laravel Tech Community
Laravel Tech Community
Jun 9, 2021 · Databases

Comprehensive Guide to SQL Syntax, Commands, and Advanced Features

This article provides a thorough overview of relational database fundamentals, SQL syntax structures, data definition and manipulation languages, transaction control, permission management, as well as detailed examples of CRUD operations, subqueries, joins, unions, functions, constraints, stored procedures, cursors, and triggers, all illustrated with practical code snippets.

DDLDMLDatabase
0 likes · 23 min read
Comprehensive Guide to SQL Syntax, Commands, and Advanced Features
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 9, 2021 · Databases

Comprehensive Guide to ClickHouse: Features, Configuration, Table Engines, and Real‑World Use Cases

This article provides an in‑depth overview of ClickHouse, covering its OLAP advantages, core features, detailed configuration files, various table engines (MergeTree, ReplacingMergeTree, SummingMergeTree, Log series, external integrations), practical examples, performance tips, and real‑world deployment scenarios.

ClickHouseDatabaseOLAP
0 likes · 62 min read
Comprehensive Guide to ClickHouse: Features, Configuration, Table Engines, and Real‑World Use Cases
Architect
Architect
Jun 6, 2021 · Databases

Optimizing MySQL Pagination for Large Datasets: Analysis and Solutions

An engineer describes a production MySQL pagination issue where large offset queries caused severe slowdown, analyzes the root cause, demonstrates data simulation scripts, and presents three optimization strategies—including index covering with subqueries, redefining start positions, and applying offset limits—to improve query performance on massive tables.

DatabaseMySQLPerformance Optimization
0 likes · 13 min read
Optimizing MySQL Pagination for Large Datasets: Analysis and Solutions
Code Ape Tech Column
Code Ape Tech Column
Jun 4, 2021 · Databases

8 MySQL Performance Tricks to Slash Query Time from Seconds to Milliseconds

This article examines common MySQL performance pitfalls such as inefficient LIMIT offsets, implicit type conversions, suboptimal UPDATE/DELETE joins, mixed sorting, misuse of EXISTS, and limited condition pushdown, then demonstrates concrete rewrites—including range reduction and WITH clauses—that reduce execution times from seconds to milliseconds.

DatabaseMySQLPerformance Optimization
0 likes · 12 min read
8 MySQL Performance Tricks to Slash Query Time from Seconds to Milliseconds
Ops Development Stories
Ops Development Stories
Jun 4, 2021 · Operations

Step-by-Step Guide to Monitoring MongoDB with Zabbix Agent 2

This tutorial explains how to use Zabbix Agent 2 to monitor MongoDB databases and clusters, covering the required read‑only user setup, relevant Zabbix templates, key metrics such as jumbo chunks, connection pool stats, server status, collection and replSet information, and practical configuration examples.

Agent2DatabaseMongoDB
0 likes · 6 min read
Step-by-Step Guide to Monitoring MongoDB with Zabbix Agent 2
IT Architects Alliance
IT Architects Alliance
May 31, 2021 · Databases

40 Common Redis Interview Questions and Answers

This article compiles 40 frequently asked Redis interview questions covering fundamentals, data types, persistence, clustering, performance tuning, memory optimization, security, and advanced usage such as pipelines and distributed locks, providing concise answers to help candidates prepare confidently for technical interviews.

CachingDatabaseInterview
0 likes · 20 min read
40 Common Redis Interview Questions and Answers
MaGe Linux Operations
MaGe Linux Operations
May 31, 2021 · Databases

Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data

A developer’s production fix using dozens of UPDATE statements unintentionally set a column to zero because of misplaced quotation marks, illustrating how MySQL’s implicit conversion and syntax quirks can turn seemingly correct SQL into disastrous data loss.

Data RecoveryDatabaseImplicit Conversion
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data
Tencent Database Technology
Tencent Database Technology
May 31, 2021 · Databases

TXSQL Query Optimizer Framework: Transformation, Join Reorder, and Cost Model

This article introduces the TXSQL query optimizer built on MySQL 8.0.22, detailing its cascades‑style framework, transformation rewrite rules such as outer‑join elimination and subquery flattening, join‑order heuristics, cost‑model configuration, and execution strategies, providing a comprehensive overview of its design and enhancements.

Cost ModelDatabaseJoin Reorder
0 likes · 25 min read
TXSQL Query Optimizer Framework: Transformation, Join Reorder, and Cost Model
Architect's Tech Stack
Architect's Tech Stack
May 31, 2021 · Databases

Tendis Hybrid Storage Architecture: Design, Features, and Implementation Details

This article introduces the pain points of using Redis as a cache, presents Tencent's Tendis solution with its three product variants, and provides an in‑depth explanation of the hybrid storage version’s overall architecture, component functions, version control, cold‑hot data interaction, eviction policies, and scaling mechanisms.

CacheCuckoo FilterDatabase
0 likes · 17 min read
Tendis Hybrid Storage Architecture: Design, Features, and Implementation Details
MaGe Linux Operations
MaGe Linux Operations
May 29, 2021 · Databases

40 Must‑Know Redis Interview Questions to Ace Your Next Job

This article compiles 40 common Redis interview questions and detailed answers, covering Redis fundamentals, data types, persistence mechanisms, performance characteristics, clustering, replication, memory optimization, eviction policies, and practical usage scenarios to help candidates confidently succeed in technical interviews.

CachingDatabaseInterview
0 likes · 23 min read
40 Must‑Know Redis Interview Questions to Ace Your Next Job
Tencent Architect
Tencent Architect
May 28, 2021 · Cloud Native

Exploring Tencent Cloud Native Database TDSQL-C Architecture and Practices

The presentation at SACC2021 detailed the background, architecture, performance, reliability, and future development directions of Tencent's cloud‑native distributed database TDSQL‑C, highlighting its compute‑storage separation, serverless elasticity, high QPS capability, and advanced fault‑tolerance mechanisms.

DatabaseScalabilityTDSQL-C
0 likes · 6 min read
Exploring Tencent Cloud Native Database TDSQL-C Architecture and Practices
ITPUB
ITPUB
May 27, 2021 · Backend Development

Ensuring Cache‑Database Consistency: Strategies, Pitfalls, and Delayed Double‑Delete

This article examines common cache‑database consistency approaches, analyzes their drawbacks through concrete examples, compares them in a decision matrix, and proposes a reliable solution—delayed double‑delete with retry mechanisms—detailing implementation code, timing considerations, and practical deployment tips for high‑read, low‑write services.

Cache ConsistencyDatabaseconsistency strategies
0 likes · 11 min read
Ensuring Cache‑Database Consistency: Strategies, Pitfalls, and Delayed Double‑Delete