Tagged articles
SQL Compatibility
11 articles · Page 1 of 1
GoldenDB, co‑developed by ZTE and CITIC Bank, is a PGXC‑based distributed database that delivers strong consistency, flexible sharding, high performance, MySQL compatibility, and comprehensive management tools, making it especially suitable for demanding financial industry workloads.
GoldenDBSQL CompatibilitySharding
0 likes · 8 min read

This article details Xiaomi’s practical deployment of Trino, covering its architectural role, core and extended capabilities, performance comparisons, integration with Iceberg and Spark, operational enhancements, multi‑cluster and ad‑hoc query scenarios, future cloud‑storage plans, and a Q&A session.
OLAPSQL CompatibilitySpark
0 likes · 20 min read

The article explains mysql_sniffer, a MySQL‑protocol packet sniffer that captures queries in real time, details its benefits for MySQL 8.0 upgrades, shows how to interpret incompatibilities, provides full command‑line options, usage examples, testing procedures, and a GitHub download link.
MySQLSQL CompatibilityTool
0 likes · 7 min read


ITPUBDec 4, 2022 · Databases
The article examines whether establishing national standards for Chinese domestic databases can foster industry development, weighing the risks of over‑regulation against the benefits of standardized observability, data‑dictionary, cloud‑integration, and programming interfaces, while sharing real‑world migration experiences.
Chinese databasesDatabase StandardsSQL Compatibility
0 likes · 11 min read

This article details a low‑impact migration from MyCat to DBLE, covering required parameter adjustments, sharding function replacement, data node handling, and business‑SQL compatibility issues, while providing concrete configuration examples and practical recommendations for a smooth transition.
DBLEDatabase MigrationMycat
0 likes · 7 min read

Youzan replaced ClickHouse and Druid with Apache Doris, refined its vectorized engine by eliminating deserialization overhead in the merge‑aggregation phase, achieving roughly a 30 % query‑time boost, and validated compatibility through SQL rewriting and traffic replay, while planning further SIMD‑based optimizations and broader adoption.
Apache DorisClickHouseDruid
0 likes · 8 min read

This article explains the design and implementation of a cloud‑native MPP query layer for ClickHouse, detailing its architecture, core features, execution flow, performance advantages, SQL compatibility, and future development plans to create a high‑performance, multi‑source OLAP data platform.
ClickHouseMPPSQL Compatibility
0 likes · 13 min read


21CTOSep 1, 2021 · Databases
This article examines the evolving data‑storage demands of large‑scale commercial advertising systems, traces the development of BaikalDB from early MySQL sharding to a heterogeneous, cloud‑native distributed database, and explains its storage, compute, and scheduling designs that deliver high reliability, low cost, and millisecond‑level performance.
Advertising SystemsBaikalDBSQL Compatibility
0 likes · 27 min read

This article provides an in‑depth technical overview of OceanBase 2.2, covering its distributed architecture, high‑availability design, multi‑tenant resource pool, Oracle/MySQL compatibility, performance benchmarks, ecosystem tools such as OCP, ODC, OMS, and disaster‑recovery solutions for financial‑grade workloads.
Distributed DatabaseOceanBaseSQL Compatibility
0 likes · 14 min read

This article compares ten typical in‑memory databases, discusses their technical characteristics such as performance, ACID support and SQL compatibility, and provides comprehensive technical and non‑technical criteria as well as hardware recommendations for choosing the most suitable in‑memory database solution.
ConsistencySQL Compatibilitydatabase selection
0 likes · 7 min read

This article walks through a gray‑scale, controlled upgrade of Hive from version 0.13 to 2.1, covering metadata schema analysis, syntax compatibility, new Hive‑2.1 features, UDF adjustments, performance tweaks, and a step‑by‑step procedure to ensure stability and zero service interruption.
HiveSQL CompatibilityUpgrade
0 likes · 20 min read
