Smart Transactions Availability

Overview

The following availability details pertain to SkySQL's MariaDB Platform for Smart Transactions (HTAP).

Single-Stack HTAP with MariaDB Enterprise Server

MariaDB Platform for Smart Transactions (HTAP) on SkySQL uses MariaDB Enterprise ColumnStore as the columnar storage engine and InnoDB as the row-based storage engine for MariaDB Enterprise Server, which provides excellent availability:

  • Data is replicated from InnoDB to ColumnStore using HTAP replication.

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

For additional information, see "HTAP Replication".

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.

Production Readiness

MariaDB Platform for Smart Transactions (HTAP) is resilient enough to handle non-critical applications that allow for short periods of downtime in the case of failure.