Highlights:

  • SkySQL now supports autoscaling, which assigns resources based on demand to scale up and down as needed and protects clients from overpaying for unused capacity.
  • The new version of SkySQL, which contains Xpand 6.1.1, MariaDB Enterprise Server 10.6.12, and ColumnStore 6.2.1, is now broadly accessible on Amazon and Google Cloud.

MariaDB plc has announced the immediate availability of a new version of its SkySQL cloud database-as-a-service, which provides enterprises with tools to control cloud expenditures effectively.

Moreover, SkySQL now supports autoscaling, which assigns resources based on demand to scale up and down as needed and protects clients from overpaying for unused capacity. According to the business, this edition also includes serverless analytics, which operates on existing data without requiring extract/transforms/load methods.

Jags Ramnarayan, Senior Vice President and General Manager of SkySQL said, “The new version is “tuned and optimized for the most rigorous of situations.” He cited the distributed SQL capability of MariaDB’s Xpand database that makes it “easy to operate, monitor, run analytics and scale elastically.”

MariaDB is an open-source drop-in alternative for Oracle Corporation’s MySQL. According to SolidIT Consulting and amp; Software Development gmbh’s DB-Engines list, it is the twelfth most common database management system, although its popularity has been rising rapidly. SkySQL, the managed version of MariaDB, was one of the first DbaaS to handle row, columnar, and mixed row and columnar storage, a technology that enables transactional and analytical processing on the same data set.

Autoscaling parameters

According to the business, SkySQL offers autoscaling of compute and storage resources in response to fluctuations in demand. Customer-defined rules determine when scaling actions are initiated. For instance, settings may be configured so that a new replica or node is automatically created when CPU use surpasses 75% across all replicas for 30 minutes.

In contrast, nodes can be degraded when sustained CPU use decreases below 50% for an hour. By merging autoscaling and distributed node deployment, Xpand on SkySQL can add or remove nodes automatically.

SkySQL’s capacity to do operational analytics on transactional data, sometimes known as “translytical,” was enabled for the first time in 2019 and is now enhanced with a serverless analytics layer driven by Apache Spark SQL. This method eliminates conflicts between analytical and transactional perspectives and only charges users for the functions they employ.

Access to an Apache Zeppelin notebook with pre-loaded examples of approaches for analytics on data stored in SkySQL is available to data scientists. It may also be used to find database schemas, query data stored in Amazon Web Services Inc.’s S3 object storage, and federate queries to link SkySQL and S3 data sets.

The new version of SkySQL, which contains Xpand 6.1.1, MariaDB Enterprise Server 10.6.12, and ColumnStore 6.2.1, is now broadly accessible on Amazon and Google Cloud.