SkySQL Features

SkySQL Features

Transactional databases

SkySQL can deploy transactional databases for applications operating at any scale, from a standalone database for development to a fully distributed database for massive production workloads. Simply choose from replication for read scaling, multi-master clustering for continuous availability or distributed SQL for full read, write and storage scaling.

Read scaling

Take advantage of built-in read scaling and load balancing by deploying a replicated or clustered databases – no application changes needed.

Multi-master

Provide continuous availability by deploying a multi-master cluster to prevent instance/zone failures from causing any downtime.

Distributed SQL

Keep up with growing or dynamic workloads by deploying a distributed SQL database, and adding or removing database instances as needed.

Modern data warehouses

SkySQL can deploy modern data warehouses for interactive, ad hoc analytics on massive data sets. It stores data in a columnar format and executes queries on it with massively parallel processing to maximize performance, and stores data on object storage (e.g., Amazon S3) to reduce costs and scale storage independently of compute (more cost savings).

Columnar data

Data is stored in a columnar format with up to 90% compression to reduce disk I/O and improve the performance of analytical queries.

Object storage

Data is stored on low-cost object storage with unlimited capacity in order to store more data without requiring more compute instances.

Multi-node

Data warehouses can run on multiple database instances to not only provide high availability, but to scale via massively parallel processing too.

Hybrid transactions/analytics

SkySQL can deploy hybrid transactional/analytical processing (HTAP) databases, removing the need to use separate database and data warehouse services (e.g., Amazon RDS and Amazon Redshift) and enabling businesses to create more insightful customer experiences by enriching transactional applications with historical data and real-time analytics.

Dual format

SkySQL hybrid databases store data in a row format for fast transaction processing and in a columnar format for fast analytics, with row data on high-performance SSDs and columnar data on low-cost object storage.

Change-data-capture

SkySQL hybrid databases can automatically replicate transactional data to the columnar format so it is immediately available for analytics, removing the need for manual change-data-capture and batch updates.

Background Divider Element

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.

Multi-zone

SkySQL ensures high availability by deploying replicated, clustered and distributed databases across multiple zones within a region.

Multi-master

SkySQL can provide continuous availability with multi-master clustering, removing the downtime incurred by replication with automatic failover.

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.

Distributed SQL

SkySQL can deploy distributed SQL databases for applications whose performance requirements currently or will soon exceed what replicated and clustered databases are capable of, or which experience short-term surges and need additional database capacity to continue meeting their SLAs.

Read/write splitting

SkySQL automatically performs read/write splitting and load balancing, routing writes to one database instance while load balancing reads across the others. Developers don’t have to worry about using separate read and write connections and knowing about individual database instances.

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

Background Divider Element

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