NewSQL is a term used to describe a class of modern relational database management systems (RDBMS) that seek to combine the scalability and performance advantages of NoSQL databases with the ACID (Atomicity, Consistency, Isolation, and Durability) guarantees of traditional SQL databases.
Traditional SQL databases, such as MySQL and PostgreSQL, have been widely used for many years in applications that require ACID compliance, such as financial transactions and inventory management. However, they can struggle to scale effectively in high-traffic, high-volume environments.
NewSQL databases aim to address this scalability issue by using a distributed architecture, in which data is partitioned and distributed across multiple nodes in a cluster, while still maintaining ACID compliance. This allows them to handle large volumes of transactions and queries more efficiently, without sacrificing consistency or durability.
Some popular NewSQL databases include CockroachDB, TiDB, and VoltDB. These databases are designed for use cases where both scalability and ACID compliance are critical, such as financial trading systems, e-commerce platforms, and high-volume transaction processing.
Overall, NewSQL represents a new breed of databases that combine the best of both SQL and NoSQL worlds, providing high scalability and high availability, while still ensuring data consistency and reliability.