I have been exploring and reading various materials about NewSQL, so I have compiled what I have read.

Originally, I wanted to compare several NewSQL databases, but I realized I needed to understand the technologies used internally, so there are many articles related to those technologies.

List of Resources

• Hybrid Clock
• Hybrid Logical Clock (HLC)
• The Truly Scary Story of Distributed Systems
• Focusing on Jepsen, a Service for Verifying Distributed Processing Systems | Think IT
• Challenges with Distributed Systems
• Let Me Talk About Distributed Systems
• Why 3 Nodes are Needed in a Cluster - Qiita
• Is Anyone Using Distributed Systems Without Understanding? - Qiita
• Navigating the 8 Fallacies of Distributed Computing
• Pitfalls of Distributed Computing - Wikipedia
• Percolator vs Spanner. Implementing Distributed Transactions the Google Way | YugabyteDB
• Low Latency Reads in Geo-Distributed SQL with Raft Leader Leases | Yugabyte
• A Busy Developer’s Guide to Database Storage Engines — The Basics | Yugabyte
• Understanding the Distributed Consensus Algorithm Raft - Qiita
• 4 Data Sharding Strategies We Analyzed When Building YugabyteDB
• CockroachDB's Consistency Model
• Spanner vs. Calvin: Distributed Consistency at Scale
• Fauna | The Distributed Serverless Database
• Introduction to Fauna (Temporal Database) Why Use FQL Instead of Standard SQL? - Qiita
• Living Without Atomic Clocks: Where CockroachDB and Spanner Diverge
• How an Open Source Distributed NewSQL Database Delivers Time Services - TiDB - PingCAP
• The Vitess Docs | What Is Vitess
• Can NewSQL Be Used for Financial Transactions? - Distributed Database PingCAP
• Using TiDB in Mission-Critical Scenarios of the Financial Industry (Part 1) - PingCAP
• The CAP Theorem Wall: The Path to NewSQL | Database Access Performance Blog
• Consistency of Distributed Nodes: The Path to NewSQL | Database Access Performance Blog
• LSM-Tree and RocksDB, TiDB, CockroachDB Are Interesting · hnakamur's blog
• Amazon Aurora Architecture Overview
• Detailed Explanation of NewSQL Components - Qiita
• Explaining the Advancements of Amazon Aurora - Qiita
• TiDB on AWS EKS DMM Video PoC Report - DMM inside
• CockroachDB vs. TiDB vs. YugabyteDB Comparison
• NewSQL as of 2020 - Qiita
• Architecture Overview
• Explore YugabyteDB | YugabyteDB Docs
• [Paper Introduction] TiDB: a Raft-based HTAP Database
• Introduction to TiDB
• What Are the Differences Between SQL, NoSQL, and NewSQL? [Database Languages]
• Lessons Learned from the 10 Billion Yen Campaign: Supporting PayPay's Scalable Large-Scale Payment System - Logmi Tech

Impressions

When actually selecting a database, it seems necessary to conduct verification and performance comparisons according to the requirements, but I found some points to consider when comparing.

• SQL Interface Adopted
  • Compatibility with SQL such as MySQL or PostgreSQL
• Distributed Transaction Specifications
  • It's a bit difficult to understand, but the specifications for how consistency is ensured differ depending on the technologies and policies adopted, such as distributed consensus protocols like Raft or Paxos and distributed clocks.
• Whether Compute and Storage are Separate or Co-located
  • I've only used Spanner, so I thought it was normal for them to be separate like in Spanner, but apparently, there are others that aren't.
  • It might affect scalability assurance.
• Whether HTAP or Not
  • If considering analytical purposes, it seems to be an important point.
    • But are there any NewSQLs other than TiDB that support this...??