Distributed Databases

Xiaolei Talks DB

Jun 5, 2025 · Databases

How Zhihu Scaled Its Data Architecture with OceanBase: A Multi‑Database Journey

Zhihu’s evolving data architecture transitioned from a single MySQL setup to a heterogeneous ecosystem of SQL, NoSQL, and graph databases, ultimately adopting OceanBase for its multi‑tenant, high‑compression capabilities, supported by tools like OMS, OCP, and ob‑operator to achieve cost savings, performance gains, and robust operations.

Distributed DatabasesOceanBasePerformance Optimization

0 likes · 12 min read

How Zhihu Scaled Its Data Architecture with OceanBase: A Multi‑Database Journey

Top Architect

Mar 13, 2025 · Databases

Choosing Between NewSQL Databases and Middleware‑Based Sharding: Advantages, Trade‑offs and Practical Guidance

The article objectively compares NewSQL distributed databases with middleware‑plus‑sharding solutions, covering architectural differences, distributed transaction handling, high‑availability, scaling, SQL support, storage engines, maturity, and provides a decision‑making checklist to help engineers select the most suitable approach for their workloads.

Distributed DatabasesHigh AvailabilityNewSQL

0 likes · 23 min read

Choosing Between NewSQL Databases and Middleware‑Based Sharding: Advantages, Trade‑offs and Practical Guidance

Architecture Digest

Mar 3, 2025 · Databases

NewSQL vs Middleware Sharding: A Comparative Analysis of Distributed Databases

This article objectively compares NewSQL distributed databases with traditional middleware‑based sharding solutions, examining their architectures, distributed transaction support, high availability, scaling, SQL capabilities, and maturity to help readers decide which approach best fits their workload and operational constraints.

Distributed DatabasesHigh AvailabilityNewSQL

0 likes · 18 min read

NewSQL vs Middleware Sharding: A Comparative Analysis of Distributed Databases

macrozheng

Mar 1, 2025 · Databases

NewSQL vs Middleware Sharding: Which Database Architecture Truly Wins?

An in‑depth comparison of NewSQL databases and middleware‑based sharding reveals each approach’s architectural strengths, distributed transaction handling, scalability, HA mechanisms, storage engine design, and ecosystem maturity, guiding readers on when to adopt NewSQL versus traditional sharding solutions.

Distributed DatabasesHigh AvailabilityNewSQL

0 likes · 18 min read

NewSQL vs Middleware Sharding: Which Database Architecture Truly Wins?

IT Services Circle

Oct 25, 2024 · Databases

Database Management Challenges in the Cloud Era and How Apache ShardingSphere Addresses Them

The article outlines the growing difficulties of managing diverse databases in cloud-native environments, introduces Apache ShardingSphere as a comprehensive open‑source solution with three core capabilities—connectivity, enhancement, and pluggability—and guides readers through a three‑step learning path from fundamentals to deployment and testing.

Cloud NativeDatabase ManagementDatabase Middleware

0 likes · 9 min read

Database Management Challenges in the Cloud Era and How Apache ShardingSphere Addresses Them

macrozheng

Aug 23, 2024 · Databases

NewSQL vs Middleware Sharding: Which Architecture Truly Wins?

This article objectively compares NewSQL databases with middleware‑based sharding solutions, examining architecture, distributed transactions, CAP constraints, high availability, scaling, SQL support, storage engines, and maturity to help readers choose the right approach for their workloads.

CAP theoremDistributed DatabasesHigh Availability

0 likes · 19 min read

NewSQL vs Middleware Sharding: Which Architecture Truly Wins?

Architecture Digest

Apr 19, 2024 · Databases

Comparing NewSQL Distributed Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Use Cases

The article objectively compares NewSQL distributed databases with traditional middleware‑based sharding solutions, examining their architectural differences, distributed transaction support, performance, scalability, high‑availability mechanisms, storage engines, and practical suitability for various application scenarios.

CAP theoremDistributed DatabasesHigh Availability

0 likes · 18 min read

Comparing NewSQL Distributed Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Use Cases

Alibaba Cloud Infrastructure

Mar 21, 2024 · Cloud Native

LightPool: An NVMe‑oF‑Based High‑Performance and Lightweight Storage Pool Architecture for Cloud‑Native Distributed Databases

The article presents LightPool, a cloud‑native storage‑pooling solution that leverages NVMe‑over‑Fabric, Kubernetes‑based scheduling, and a lightweight user‑space engine to deliver high‑performance, low‑cost, and highly available storage for large‑scale distributed databases while eliminating traditional bottlenecks.

Cloud NativeDistributed DatabasesHigh Performance

0 likes · 13 min read

LightPool: An NVMe‑oF‑Based High‑Performance and Lightweight Storage Pool Architecture for Cloud‑Native Distributed Databases

Aikesheng Open Source Community

Mar 21, 2024 · Cloud Native

LightPool: A NVMe‑oF‑Based High‑Performance and Lightweight Storage Pool Architecture for Cloud‑Native Distributed Databases

The article introduces LightPool, an open‑source NVMe‑over‑Fabric storage pool system presented at HPCA 2024, which combines cloud‑native design, high‑performance lightweight storage engine, and advanced scheduling to improve resource efficiency, cost, and availability for large‑scale distributed databases.

Distributed DatabasesHPCAHigh Performance

0 likes · 12 min read

LightPool: A NVMe‑oF‑Based High‑Performance and Lightweight Storage Pool Architecture for Cloud‑Native Distributed Databases

AntData

Mar 21, 2024 · Cloud Computing

LightPool: A Cloud‑Native NVMe‑oF Based High‑Performance Storage Pool Architecture for Distributed Databases

The article introduces LightPool, an open‑source cloud‑native storage‑pool architecture built on NVMe‑over‑Fabric that delivers high performance, low cost, and high availability for large‑scale distributed databases, and explains its design, scheduling, storage engine, and hot‑upgrade/migration capabilities presented at the 30th IEEE HPCA conference.

Distributed DatabasesHigh PerformanceLiteIO

0 likes · 13 min read

LightPool: A Cloud‑Native NVMe‑oF Based High‑Performance Storage Pool Architecture for Distributed Databases

DataFunSummit

Feb 1, 2024 · Databases

StarRocks 3.0 Storage‑Compute Separation Architecture: Design, Implementation, and Evaluation

This article explains the storage‑compute separation architecture introduced in StarRocks 3.0, presents industry case studies, details the design of StarOS and compute nodes, discusses technical challenges and key techniques, and evaluates cost, reliability, elasticity, and performance through benchmarks and user feedback.

Cloud NativeDistributed DatabasesStarRocks

0 likes · 11 min read

StarRocks 3.0 Storage‑Compute Separation Architecture: Design, Implementation, and Evaluation

Aikesheng Open Source Community

Nov 29, 2023 · Databases

When to Use Distributed vs. Centralized Databases: Analysis, Benchmarks, and Best Practices

This article examines the trade‑offs between centralized and distributed OLTP databases, presents industry usage statistics, performance benchmarks, practical questions for migration, and detailed guidance on sharding, SQL design, and operational considerations to help decide when a distributed solution is truly needed.

Database ArchitectureDistributed DatabasesOLTP

0 likes · 12 min read

When to Use Distributed vs. Centralized Databases: Analysis, Benchmarks, and Best Practices

Laravel Tech Community

Sep 18, 2023 · Databases

Why MySQL May Not Be Suitable for Containerization and When It Can Be

The article examines the challenges of running MySQL in Docker containers, highlighting data‑security, performance, state, and resource‑isolation concerns, while also presenting scenarios and strategies where containerizing MySQL can be viable.

Distributed DatabasesDockerMySQL

0 likes · 7 min read

Why MySQL May Not Be Suitable for Containerization and When It Can Be

Architects' Tech Alliance

Jun 4, 2023 · Databases

Hybrid Deployment Strategies for Distributed Databases on X86 and ARM Servers

This article examines hybrid deployment schemes for distributed databases across X86 and ARM server architectures, detailing cross‑cluster, multi‑data‑center, and single‑data‑center approaches, and discusses their applicability to financial industry workloads, performance testing, and gradual migration strategies.

ARMDistributed DatabasesFinancial Industry

0 likes · 10 min read

Hybrid Deployment Strategies for Distributed Databases on X86 and ARM Servers

Architects' Tech Alliance

Feb 28, 2023 · Databases

Hybrid Deployment Strategies for Distributed Databases across X86 and ARM Server Architectures

The article examines three hybrid deployment schemes—cross‑cluster, multi‑data‑center within a cluster, and single‑data‑center within a cluster—for distributed databases running on both X86 and ARM servers, highlighting their technical steps, benefits, and relevance to the financial industry.

ARMDistributed DatabasesFinancial Industry

0 likes · 8 min read

Hybrid Deployment Strategies for Distributed Databases across X86 and ARM Server Architectures

Efficient Ops

Feb 12, 2023 · Databases

Why Single‑Node MySQL Is No Longer Enough: Embrace Distributed Databases

The article explains the limitations of standalone MySQL for large‑scale workloads, explores sharding, read/write separation, and middleware approaches, and argues that modern distributed databases and cloud‑native solutions are the sustainable path forward for data‑intensive applications.

Cloud DatabasesDatabase ScalingDistributed Databases

0 likes · 6 min read

Why Single‑Node MySQL Is No Longer Enough: Embrace Distributed Databases

Architect's Guide

Jan 26, 2023 · Databases

Primary Key and Index Design for Distributed Databases

The article explains why auto‑increment primary keys are unsuitable for sharded databases, recommends globally unique ordered identifiers, and details index and global‑table strategies—including redundant tables, index tables, and embedding shard information in keys—to achieve efficient single‑shard queries.

Distributed DatabasesSQLglobal unique identifier

0 likes · 10 min read

Primary Key and Index Design for Distributed Databases

IT Architects Alliance

Oct 10, 2022 · Databases

Designing Routing Keys for Database Sharding in an Order Platform

The article explains how to choose and implement routing keys for database sharding in an online food ordering system, covering supported scenarios, user‑side and merchant‑side keys, single‑ and multi‑database strategies, and the impact on data distribution and query efficiency.

Database DesignDistributed Databasesorder platform

0 likes · 6 min read

Designing Routing Keys for Database Sharding in an Order Platform

IT Architects Alliance

Sep 26, 2022 · Databases

Horizontal Scaling in TDSQL: Design Principles, Practices, and Case Studies

This article explains the background, challenges, and design principles of horizontal scaling for TDSQL, detailing its architecture, scaling process, shard‑key selection, high availability, distributed transactions, performance optimization, practical case studies, and a Q&A section.

Distributed DatabasesHigh AvailabilityPerformance Optimization

0 likes · 24 min read

Horizontal Scaling in TDSQL: Design Principles, Practices, and Case Studies

IT Architects Alliance

Sep 15, 2022 · Databases

Designing Indexes and Primary Keys for Distributed Database Architectures

Effective index and primary key design in distributed database architectures requires using globally unique, ordered identifiers instead of auto‑increment keys, embedding shard information in keys, employing auxiliary index tables, and handling global tables to ensure queries target a single shard, thereby preserving scalability and performance.

Distributed DatabasesUUIDglobal tables

0 likes · 11 min read

Designing Indexes and Primary Keys for Distributed Database Architectures