SkySQL Features

Transactions, analytics or both

SkySQL can deploy databases or data warehouses optimized for fast transactions, interactive analytics or smart transactions, standard transactions enriched with real-time analytical queries.

Transactions

Deploy databases optimized for fast transaction processing using high-performance block storage (persistent SSDs) and multiple read replicas.

Analytics

Deploy MariaDB Platform as a data warehouse optimized for scalable, interactive analytics using a columnar format and cloud object storage.

Both

Deploy MariaDB Platform as a hybrid database optimized for smart transactions using block and object storage for row and columnar data.

High availability

SkySQL combines Kubernetes and MariaDB MaxScale to maintain availability across instance/zone failures and ensure all database deployments are restored to full capacity, regardless of whether the failures affected primaries or replicas.

Regional clusters

SkySQL automatically deploys replicated databases to 3+ zones by default, maintaining availability even if multiple zones failure.

Automatic failover

SkySQL performs an automatic failover within seconds if the primary fails, and if a replica fails, automatically retries queries on a different one.

Self-healing

SkySQL uses Kubernetes and persistent disks to automatically recover failed database instances and restore deployments to full capacity.

Disaster recovery

SkySQL combines nightly backups, persistent disks, point-in-time rollback and cross-region replication to minimize the recovery point and recovery time objectives (RPO/RTO) of mission-critical, production databases.

Automated backups

SkySQL performs automated non-blocking backups every night to support on-demand, point-in-time restore when requested.

Flashback

SkySQL can perform an online point-in-time rollback when requested to undo recent changes such as accidental deletes or updates.

Cross-region replicas

SkySQL can optionally deploy replicas in secondary regions in order to recover from a primary region failure. Coming soon.

Scalability

SkySQL uses an advanced database proxy to abstract away the underlying database topology and provide applications with transparent query routing. When replicas are added, the effect is immediate – no application changes required.

Read load balancing

SkySQL provides applications with adaptive load balancing by default, routing queries to the fastest replicas based on current query response times so developers no longer have to worry about replicas, their IP addresses and performing load balancing themselves.

Learn more
Read/write splitting

SkySQL provides applications with transparent read/write splitting, automatically routing writes to the primary and load balancing reads across replicas so developers no longer have to worry about creating separate read and write connections when scaling out with read replicas.

Learn more

Security

SkySQL databases are secure by default, with end-to-end encryption, single-tenant environments and all database access restricted until administrators whitelist specific clients and servers. In addition, MariaDB’s Trust Center provides detailed information on SkySQL security policies and procedures as well as HIPPA practices and GDPR compliance.

End-to-end encryption

SkySQL encrypts data both in transit and at rest, requires secure client connections (i.e., SSL/TLS) and provides a certificate chain for verification.

Whitelisting

SkySQL databases are not publicly accessible, and require admins to whitelist the IP addresses or ranges of any clients requiring access.

Documentation
Single tenancy

SkySQL creates a private Kubernetes cluster in each region an enterprise customer deploys to, isolating all of their database infrastructure.

Configuration

SkySQL allows the default database configuration values to be overridden by creating custom configurations. These configurations are versioned and can be applied to any database. SkySQL keeps track of the versions databases are using, and whether or not they are current.

SkySQL Configuration Manager

Monitoring

SkySQL provides real-time and historical monitoring via an interactive dashboard built on Prometheus and Grafana. This interactive monitoring dashboard groups related infrastructure, operating system and database metrics together, displaying them as charts and graphs.

SkySQL Monitoring

 

Workload analysis

SkySQL workload analysis applies thousands of observations per week to a deep learning model. The result is a set of distinct workloads with recurring transitions and patterns, and their key distinguishing metrics – all helpful in diagnosing workload irregularities and changes, and all available for interactive visualization.

SkySQL workload analysis

Background Divider Element

Get started

It’s easy to get started with SkySQL, and it doesn’t cost a thing. Sign up for SkySQL today and get a $500 credit toward up to three databases of any size and any type (transactional, analytical or both).