The following availability details pertain to SkySQL's MariaDB Platform for Analytics (ColumnStore).
Highly Available Analytics with MariaDB Enterprise ColumnStore
MariaDB Platform for Analytics uses MariaDB Enterprise ColumnStore as the columnar storage engine for MariaDB Enterprise Server, which provides high availability:
Multi-node topology supports automatic failover if the primary node fails.
Enterprise ColumnStore data is stored in cloud object storage, which is cost-effective, highly available, and virtually limitless.
Enterprise ColumnStore schemas and other database objects are replicated between nodes using MariaDB Replication.
Automatic Failover with MariaDB MaxScale
MariaDB Platform for Analytics uses MariaDB MaxScale for automatic failover.
MaxScale's MariaDB Monitor (
mariadbmon) provides automatic failover:
MaxScale's MariaDB Monitor continuously checks the status of all primaries and replicas.
If the primary node fails, MaxScale promotes the most up-to-date replica to be the new primary.
All existing replicas will be redirected to use the newly promoted primary.
SkySQL also provides failover for MaxScale itself:
If the MaxScale instance fails, it is restarted or replaced, depending on the specific issue.
If one an instance fails, it is restarted or replaced, depending on the specific issue.
Redundant MaxScale instances are also supported as optional configuration option. For additional information, see "MaxScale Redundancy".
MariaDB SkySQL services on GCP rely on Google Kubernetes Engine (GKE), which is a component of Google Cloud Platform (GCP). MariaDB SkySQL inherits many availability features from GKE and GCP:
The resiliency of regional GKE Kubernetes clusters which include multiple zones within a region.
The auto-healing functionality of Kubernetes.
Google's goal to have 99.5% up-time, as mentioned in the SLA for GKE.
Google Cloud Storage
MariaDB Platform for Analytics uses Google Cloud Storage (GCS) for storage of analytical data.
Economical and cost-effective storage
Scalable and virtually limitless storage
Resilient and highly available storage
Powered by Kubernetes
MariaDB SkySQL services run in containers powered by Kubernetes. MariaDB SkySQL inherits many availability features from Kubernetes' self-healing functionality:
Failed containers are automatically restarted.
Unhealthy containers are automatically killed.
Dead containers are automatically replaced.
All of this happens in a way that is transparent to the user.
If the MaxScale instance fails it is restarted or replaced, depending on the specific issue.
In multi-node deployments, if one of the MariaDB Enterprise Server instances fails, it is restarted or replaced, depending on the specific issue.
MariaDB Platform for Analytics is designed for resiliency. Multi-node deployments (3 nodes) are production-ready.