Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Everything You Need to Know About NewSQL in 2020

Everything You Need to Know About NewSQL in 2020

The database is usually the heart of a software system. And there are many database technologies that we can pick from. In this talk, we’ll explore where RDBMS and NoSQL fall short and how NewSQL fills the gap. We’ll see what types of NewSQL databases exist and how they work. And we’ll also go over different NewSQL solutions that we can pick for our projects. By the end of the talk, we’ll have a good understanding of when and how to apply a NewSQL database in our big scale applications.

Nikolay Stoitsev

October 29, 2020
Tweet

More Decks by Nikolay Stoitsev

Other Decks in Programming

Transcript

  1. Everything You Need to Know About NewSQL in 2020 Nikolay

    Stoitsev, Engineering Manager @ Halo DX
  2. F. Chang, J. Dean, S. Ghemawat, W. C. Hsieh, D.

    A. Wallach, M. Burrows, T. Chandra, A. Fikes, and R. E. Gruber. Bigtable: A distributed storage system for structured data. ACM Trans. Comput. Syst., 26:4:1–4:26, June 2008.
  3. G. DeCandia, D. Hastorun, M. Jampani, G. Kakulapati, A. Lakshman,

    A. Pilchin, S. Sivasubramanian, P. Vosshall, and W. Vogels. Dynamo: amazon’s highly available key-value store. SIGOPS Oper. Syst. Rev., 41:205–220, October 2007.
  4. Databases with novel architecture CockroachDB • Open Source - https://github.com/cockroachdb/cockroach

    • Easy to setup • Horizontal scalability and high availability • Geo-partitioning and distribution of data • ACID transactions
  5. Calvin and FaunaDB • Scalable • ACID Transactions • One

    global consensus protocol • GraphQL • User defined functions • Commercial
  6. Databases with novel architecture NuoDB • Horizontal scalability • High

    availability • ACID transactions • Separate Transaction Management and Storage Management • Used in banking • https://nuodb.com VoltDB • Horizontal scalability with Geo Replication • High availability • ACID transactions (Serialized) • In-memory database • Low latency • Used in many domains • https://www.voltdb.com/
  7. Middlewares Apache Ignite • Peer-to-peer mesh network • Distributed queries

    • Distributed caching • Storage and processing framework • Horizontally scalable • Atomic types • Replicated data structures • https://ignite.apache.org Apache Trafodion • SQL query language on Apache HBase • Big data workloads • ACID transactions • https://trafodion.apache.org
  8. Managed Cloud Databases Cloud Spanner • Horizontal scalability • High

    availability • ACID transactions • Planet scale • Widely used • https://cloud.google.com/s panner Azure Cosmos DB • Horizontal scalability • High availability • ACID transactions • Planet scale • Widely used • Multi-Model • https://azure.microsoft.com /en-us/services/cosmos-db
  9. Summary RDBMS Easy to run Has transactions Can’t scale NoSQL

    Can scale Provides availability No transactions NewSQL Can Scale Has transactions Lack maturity