Topology
This page is part of MariaDB's Documentation.
The parent of this page is: Launch-Time Selections
Topics on this page:
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 |