Analytics Availability

Overview

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".

Google Infrastructure

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.

GCS provides:

  • 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.

Production Readiness

MariaDB Platform for Analytics is designed for resiliency. Multi-node deployments (3 nodes) are production-ready.