1 views collected around this technical thread.
The article explains how Baidu Cloud Redis's Data Flashback feature combines RDB snapshots with timestamped AOF logs to provide fast, space‑efficient, point‑in‑time data recovery, overcoming the limitations of native Redis persistence in high‑traffic scenarios.
This article presents a comprehensive technical overview of Alibaba Cloud AnalyticDB MySQL and its Serverless Spark integration, detailing architecture, core optimizations, security enhancements, and real‑world case studies that demonstrate how to achieve cost‑effective, high‑performance data lake analytics.
The study benchmarks Tencent Cloud KeeWiDB with YCSB workloads, showing that its Redis‑compatible KV service delivers up to 149 k QPS reads and 127 k QPS writes for 128‑byte strings, out‑performing self‑built Pika and Redis clusters, though larger values suffer bandwidth throttling, confirming KeeWiDB as a low‑cost, high‑performance option for small‑value, read‑heavy use cases.
This article provides a comprehensive overview of Tencent's self‑developed MySQL kernel TXSQL, covering its evolution, overall architecture, columnar storage engine, instant DDL capabilities, enterprise‑grade features, high‑availability mechanisms, performance optimizations, and the rigorous development and testing processes behind the product.
This article walks through creating a lightweight Hongxing Erke‑style e‑commerce mini‑program using WeChat's cloud development, covering tool setup, cloud database design, UI layout, tabBar customization, data loading, pagination, sorting, and detail‑page navigation with practical code examples and common pitfalls.
This guide explains Tencent Cloud MySQL's three instance types, detailed replication modes (asynchronous, semi‑synchronous, strong synchronous), high‑availability failover mechanisms, upgrade procedures, binlog management, restore options, slow‑query tuning, and space fragmentation, providing practical insights for reliable cloud database operations.
Tencent’s cloud‑native database TDSQL‑C separates compute and storage, offering petabyte‑scale network‑attached storage, automatic scaling, million‑level QPS, MySQL/PostgreSQL compatibility, serverless per‑use billing, two‑level caching, instant snapshot‑based backup and restore, and a roadmap toward ultra‑minimal operations, multi‑region DR and column‑store analytics.
The article traces database technology from the commercial Oracle era through open‑source and the emerging cloud‑native phase, highlights cloud as the primary battleground and the importance of the to‑B market, reviews historic academic contributions, examines Oracle and China’s TDSQL evolution, and outlines five future directions—distributed, intelligent, multi‑model, hardware‑software integration, and cloud convergence—while urging DBAs to adapt their full‑stack skills.
This article analyzes a severe MySQL performance issue caused by massive user‑access logs, then presents three solution paths—optimizing the existing database, migrating to a compatible high‑performance database, and adopting big‑data technologies—detailing design best practices, indexing, partitioning, sharding, and cloud‑native options to restore query speed and scalability.
This article analyzes the performance problems of a massive MySQL 5.6 RDS table storing billions of user‑activity records and presents three practical solutions—optimizing the existing schema and queries, migrating to a MySQL‑compatible high‑performance database, and adopting a big‑data platform—detailing design, indexing, partitioning, sharding, and cloud‑native options.
Three leading database experts from Tencent and cloud firms share how deep curiosity, hands‑on experimentation, persistent learning—combined with mastering distributed, cloud, and autonomous databases—forge an outstanding data craftsman, while advising newcomers to master performance, security, one DB per category, and start with open‑source tools.
Tencent Cloud MySQL 8.0 builds on official MySQL improvements with eight enterprise‑grade enhancements—TDE encryption, kernel‑level audit, multi‑queue thread pool, strong consistency, AEP SSD support, lightweight AP mode, hotspot updates, and SQL rate‑limiting—delivering high‑performance, secure, and scalable solutions for e‑commerce, gaming, finance, and new‑retail workloads while paving the way for cloud‑native, AI‑driven database evolution.
During the COVID‑19 surge, Tencent Cloud Redis scaled losslessly by using a proprietary slot‑specific RDB sync method that avoids downtime, handles large keys, Lua scripts, and multi‑key commands, outperforming open‑source and DTS approaches while minimizing resource duplication and maintaining 24/7 service.
The article outlines the essential technical requirements of cloud databases, explores emerging architectural trends such as storage‑SQL separation, multi‑model support, and disaster‑recovery multi‑active designs, and discusses their business advantages and typical application scenarios in modern enterprises.
The report summarizes SIGMOD/PODS 2019 in Amsterdam, covering a blockchain-focused keynote, the CDBTune paper on end‑to‑end automatic cloud database tuning using deep reinforcement learning, modern hardware research, award‑winning systems, and related industry activities, providing a comprehensive academic overview.
Tencent Cloud’s CynosDB for MySQL separates compute from distributed storage, using a log‑driven, stateless architecture that eliminates local I/O, enables sub‑second failover, 2.5× write performance, lock‑free structures, async group‑commit, compressed logs, fast parallel recovery, and scalable replication, with future plans for external buffer pools and multi‑master support.
The article summarizes the 58 Group technical salon where experts from Tujia.com, Kingsoft Cloud, and 58 Group shared their experiences on building block‑based database automation systems, cloud database architectures, high‑availability designs, self‑service platforms, and intelligent operation practices for large‑scale database services.
The article details Tencent’s TXSQL (Tencent MySQL) architecture and optimizations—including asynchronous table deletion, DDL NO_WAIT/WAIT, MDL visibility, lock splitting, parallel replication, query push‑down, read‑view enhancements, low‑overhead auditing and KMS‑integrated encryption—highlighting its role as the core engine powering CDB for diverse industries such as gaming, finance, e‑commerce and internal services like WeChat and QQ.
The article presents a detailed case study of the 58 Cloud DB Platform, describing its architecture, automated workflow using Celery and Ansible, and intelligent features such as server selection and alarm merging powered by machine‑learning, highlighting how it streamlines MySQL, Redis, and MongoDB operations for developers and DBAs.
The article explains the key technical requirements of cloud databases, such as elastic scaling, compute‑storage separation, multi‑model support and self‑management, and discusses emerging architectural trends like storage‑SQL separation, multi‑model engines, and disaster‑recovery/multi‑active designs for various enterprise scenarios.