🧱NewSQL

NEW

Relational databases that deliver horizontal scalability and high throughput while preserving SQL and ACID guarantees.

DESCRIPTION

NewSQL refers to modern relational database systems that combine strong transactional consistency with distributed, cloud-scale architectures. They typically expose a SQL interface, maintain ACID properties, and use techniques like consensus replication and partitioning to scale writes and reads. NewSQL targets high-throughput OLTP workloads that outgrow single-node RDBMSs without sacrificing consistency. Examples include CockroachDB, Google Cloud Spanner, TiDB, and YugabyteDB. These systems often implement global clocks or consensus algorithms to provide serializability. Adoption is common in fintech, e-commerce, and SaaS platforms. They compete with both NoSQL systems and traditional RDBMSs by promising scalability with familiar SQL.

ALTERNATIVE DEFINITIONS

Wikipedia

NewSQL is a class of relational database management systems that seek to provide the same scalable performance of NoSQL systems for online transaction processing (OLTP) read-write workloads while maintaining the ACID guarantees of a traditional database system.

Highlights OLTP focus and preservation of ACID while achieving NoSQL-like scalability.

Source

Cockroach Labs

NewSQL databases provide the scalability and performance of NoSQL systems while maintaining the relational model and ACID transactions, typically through a distributed SQL architecture.

Emphasizes distributed SQL as the architectural approach underpinning NewSQL.

Source

RELATED TERMS

Distributed SQL ACID CAP Theorem Online Transaction Processing Sharding Consistency Model Google Spanner CockroachDB

COMPETING TERMS

NoSQL Relational Database

KNOWLEDGE AREAS

Data Storage & Operations Data Engineering Data Architecture Cloud

TARGET AUDIENCE

Data Engineer Software Developer Data Architect Cloud Architect Data Modeler

EXTERNAL SOURCES

• Wikipedia - NewSQL
• Google Cloud - Spanner overview as distributed SQL
• Yugabyte - Distributed SQL concepts and benefits
• TiDB - TiDB distributed SQL overview
• Cockroach Labs - CockroachDB architecture details

TOP QUESTIONS

Why is NewSQL relevant today?

It offers SQL and ACID with cloud-scale horizontal scalability, enabling high-throughput OLTP workloads without abandoning relational modeling or transactional safety.

Category: Relevancy

How does NewSQL differ from NoSQL?

NewSQL maintains SQL and ACID guarantees while scaling; NoSQL often relaxes consistency for availability and flexibility, using non-relational models.

Category: Differences

What workloads suit NewSQL?

Write-intensive OLTP systems requiring global consistency, such as payments, order processing, and multi-region SaaS applications.

Category: Application

What are examples of NewSQL technologies?

CockroachDB, Google Cloud Spanner, TiDB, and YugabyteDB are prominent distributed SQL/NewSQL systems.

Category: Examples

What is the biggest risk with NewSQL adoption?

Operational complexity and cost can increase, especially with multi-region consensus and strict consistency settings.

Category: Risks

How does NewSQL ensure consistency?

Consensus algorithms (e.g., Raft, Paxos) and global time sources or hybrid logical clocks provide serializable or strong consistency.

Category: Mechanism

Is NewSQL a replacement for traditional RDBMS?

Not always; for single-node or modest-scale workloads, classic RDBMS is simpler. NewSQL shines when horizontal scaling is required.

Category: Opinion

How does latency compare in NewSQL?

Cross-region consensus may add latency; careful placement and transaction design mitigate performance impacts.

Category: Performance

What skills are needed for NewSQL?

SQL proficiency, understanding distributed systems, consensus, partitioning, and operational tooling are important.

Category: Requirements