Getting Started With Distributed SQL

Book IconDownload Now
Getting Started with Distributed SQL Cover

What You'll Learn

In recent years, the use of NoSQL databases has become widespread, because there is a great need for distributed databases. NoSQL databases - unlike traditional relational databases - are built from the ground up to be distributed. Yet NoSQL has significant negatives, such as the lack of data consistency, vulnerabilities around data integrity, and slow and hard-to-write queries, due to the inherent lack of SQL support. Now there is a new class of databases: distributed SQL databases, also known as NewSQL.

This Refcard serves as a reference to the key characteristics of distributed SQL databases and provides information on the benefits of these databases, as well as insights into optimal query design, to get the most out of this architectural pattern.

Database Icon
The Need for Distributed SQL
Distributed SQL databases offer advantages for new, modern, cloud-native applications.
Server Icon
Sharding Middleware
A precursor to distributed SQL that supports the distribution of a single-server database, such as MySQL, across multiple independent servers.
Clipboard List Check Icon
Distributed SQL Architecture
Can run both transactional and analytical workloads by the use of an architecture that's made up of three layers: (i) distributed storage, (ii) distributed query execution, and (iii) SQL API.
Table Icon
Comparing Architectures of Distributed SQL Databases
Shared-everything (e.g. MySQL, PostgreSQL); shared-storage (e.g. Oracle Exadata, Snowflake, Google BigQuery); shared-nothing (e.g. SingleStore, VoltDB)
Code Icon
Query Execution Architecture
How the Data Definition Language (DDL) and Data Manipulation Language (DML) affect query design.
Book Icon
Distributed DDL, Distributed DML, and Distributed Joins
Insights into query design and execution for optimal performance at scale

Get This Free Refcard Today

Learn key characteristics of distributed SQL databases, benefits of these databases, as well as insights into query design and execution.
Ref card trifold

Download Refcard

Submit the form below to receive a copy of the Refcard.
This email address will be used as your username
SingleStore Partners

SingleStore is The Database of NowTM

The cloud-native operational database built for speed and scale
Accelerate business with instant insights delivered by the world’s fastest database for operational analytics
Create your future on a platform made for the demands of the data revolution, including machine learning and AI
Transform on your terms - with the familiarity and efficiency of SQL, and an architecture that bursts through limits