Comprehensive Overview of NewSQL Databases and Their Applications

Mike Chen, a seasoned architect with over ten years of experience at leading Chinese tech companies, introduces NewSQL as the next generation of scalable, high‑performance SQL databases that combine the ACID guarantees of traditional relational systems with the horizontal scalability of NoSQL.

What Is NewSQL?

NewSQL refers to a class of modern relational databases designed for online transaction processing (OLTP) workloads, offering NoSQL‑like scalability while preserving strong consistency and full SQL support.

Key characteristics include:

Relational data model

Strong consistency and transactional guarantees

Full SQL query capability

Horizontal scalability inspired by NoSQL architectures, enabling massive data storage

Popular NewSQL Products

The rise of NewSQL is linked to research papers on Google’s BigTable, Spanner, and the mature implementation of the Raft algorithm.

Notable NewSQL systems include:

Google Spanner (the pioneering NewSQL database)

CockroachDB (an open‑source Spanner‑inspired implementation)

TiDB (PingCAP’s open‑source distributed relational database)

OceanBase (Ant Group’s enterprise‑grade distributed database)

TDSQL (Tencent’s MySQL‑compatible distributed database)

1. Spanner

Spanner is a globally distributed, scalable database designed and deployed by Google. It organizes data into many zones, each resembling a BigTable server deployment. A zone contains a zone master and hundreds to thousands of spanservers, with data replicated across zones for high availability.

2. CockroachDB

CockroachDB is an open‑source implementation of Spanner that provides standard SQL support, linear scalability, strong consistency, and high availability.

3. TiDB

TiDB, developed by PingCAP, is an open‑source distributed relational database that supports both OLTP and OLAP workloads (HTAP). It offers horizontal scaling, financial‑grade high availability, real‑time analytics, and cloud‑native deployment, while remaining compatible with the MySQL 5.7 protocol.

4. OceanBase

OceanBase is Ant Group’s fully self‑developed enterprise‑grade distributed relational database, offering financial‑level reliability, strong consistency, high performance, online scaling, and broad SQL compatibility.

5. TDSQL

TDSQL for MySQL, created by Tencent, is a distributed database product featuring strong consistency, high availability, global deployment, horizontal scalability, high performance, and enterprise‑grade security, along with intelligent DBA tools and automated operations.

NewSQL Application Scenarios

1. Financial‑grade commercial databases – NewSQL can handle high‑frequency, low‑value transactions typical of modern fintech services.

2. E‑commerce platforms – Distributed architecture enables linear performance scaling to meet massive traffic spikes.

3. Massive data storage and access – Elastic vertical and horizontal scaling supports industrial IoT, smart cities, smart homes, vehicle networks, and charging stations.

4. HTAP (Hybrid Transactional/Analytical Processing) – NewSQL enables simultaneous OLTP and OLAP workloads on the same data without interference, reducing storage costs and serving use cases such as IoT analytics, business intelligence, recommendation systems, and search engines.

For readers interested in deeper study, the author offers a 300,000‑word collection of architecture materials and a comprehensive Java interview question set covering Java, multithreading, JVM, Spring, MySQL, Redis, Dubbo, middleware, and more. Details and download links are provided in the original article.