Topology

Overview

SkySQL offers databases for Transactions (OLTP and general purpose) and Analytics (OLAP, ad hoc queries and large data) workloads.

Reliability and scaling features differ by topology, allowing you to right-size choices for your business needs.

Topology is selected during Service Launch.

Topology choices are specific to workload type.

For information about how to choose a topology with the SkySQL DBaaS API, see "Topology Selections with the SkySQL DBaaS API".

Available Topologies

SkySQL services are optimized for your workload:

Workload Type

Topology

Use Case

Transactions

Enterprise Server Single Node

For small projects and development with moderate concurrency

Transactions

Enterprise Server With Replica(s)

Read scaling with high availability

Transactions

Xpand Distributed SQL

Read/write scaling with high concurrency and availability

Analytics

ColumnStore Data Warehouse

Run advanced analytical queries for millions of data records

Analytics

Serverless Analytics

Zero-ETL, real time analytics on any data in SkySQL or cloud storage