SkySQL is a cloud database service without the usual cloud compromises. It makes running MySQL-compatible databases in Google Cloud easy, but unlike Google Cloud SQL, it doesn’t impose artificial limitations and downtime in the name of automation. It takes advantage of powerful database features rather than removing them for simplicity, and because it deploys the same enterprise open source database platform as on-premises customers, it doesn’t have to implement missing features (e.g., high availability) with subpar, inefficient and proprietary infrastructure solutions.
Read the comparison: MariaDB SkySQL vs. Google Cloud SQL
SkySQL takes full advantage of the infrastructure and services provided by Google Cloud Platform (GCP) to provide customers with the best security, high availability and performance available in the cloud, leveraging the Google Kubernetes Engine (GKE) for orchestration, persistent disks for durability and Google Cloud Storage (GCS) for recovery and analytics.
SkySQL databases are deployed to GKE regional clusters via an advanced Kubernetes operator, providing enterprise customers with maximum security and high availability.
SkySQL transactional databases use SSD persistent disks for maximum performance and durability, enabling the SkySQL operator to automatically recover failed instances.
SkySQL analytical databases use parallel processing to query data stored in a columnar format on GCS, lowering the storage costs of large data warehouses in the cloud.
Deploy distributed SQL databases for unlimited read, write and storage – scale out when needed, as far as needed.
Decide when to upgrade (or not), and eliminate the random disruption caused by automatic minor upgrades.
Delay database maintenance as long as needed, and request a SkyDBA to perform scheduled, zero-downtime operations.
Eliminate downtime during automatic failover – connections remain open and all in-flight transactions are completed.
Use a single connection with built-in read/write splitting and load balancing to simplify data access and reduce code.
Launch hybrid transactional/analytical databases with row + columnar storage to build applications with real-time insight.
SkySQL can deploy standard transactional databases like Google Cloud SQL, data warehouses like Google BigQuery and distributed SQL databases like Google Spanner – all with the click of a button. However, unlike the disparate technologies used by Google Cloud for its database and data analytics services, all SkySQL databases and data warehouses are powered by MariaDB Enterprise Server, a multi-purpose database with optional distributed SQL and columnar storage engines. As a result, all transactional, analytical and hybrid transactional/analytical applications can use MySQL-compatible clients and standard SQL.
SkySQL brings the advanced capabilities of MariaDB Enterprise Server to the cloud, going above and beyond Google Cloud SQL with the world’s most powerful open source (and MySQL-compatible) database – adding distributed SQL for scaling reads, writes and storage, extending automatic failover with transaction replay for continuous availability, combining row and columnar storage for hybrid transactions/analytics and implementing both standard SQL and Oracle PL/SQL.
|Row and columnar storage||No||Yes|
|Custom configuration templates||No||Yes|
|Oracle Database compatibility||No||Yes|