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.
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.
| Cloud SQL | SkySQL | |
|---|---|---|
| Multi-cloud | No | Yes |
| Distributed SQL | No | Yes |
| Multi-master clustering | No | Yes |
| Row and columnar storage | No | Yes |
| Transaction replay | No | Yes |
| Session restore | No | Yes |
| Connection migration | No | Yes |
| Read/writes splitting | No | Yes |
| Load balancing | No | Yes |
| Custom configuration templates | No | Yes |
| Sequences | No | Yes |
| Oracle Database compatibility | No | Yes |
| Temporal tables | No | Yes |
