2 min Applications

MariaDB gives SkySQL DBaaS solution better auto scaling

MariaDB gives SkySQL DBaaS solution better auto scaling

MariaDB has upgraded its SkySQL Database-as-a-Service (DBaaS) solution. This should allow customers to better manage their cloud costs through auto scaling capabilities.

The new version of the DBaaS service is suitable for use in the harshest environments, according to the vendor.

A key part of the update is the addition of auto scaling. This feature allows enterprises to scale compute power and storage resources up and down according to capacity demand. This should help users of the SkySQL DBaaS service not pay for unsolicited capacity.

Users can set certain rules for this purpose that become active when, for example, CPU usage is above 75 percent for 30 minutes. Then computing power and/or storage is scaled up. When usage drops below 50 percent again, capacity is automatically scaled down. Users can always set upper and lower limits, so there are no surprises.

Tip: MariaDB Announces New Innovation Release Model

Serverless analytics layer

In addition to autoscaling, the new version of SkySQL has better capabilities for performing operational analytics on transactional data.

This feature, already possible since 2019, has now been enhanced with a serverless analytics layer based on Apache Spark SQL. This eliminates inconsistency between analytics and transactional insights. It also allows users to pay only for the features they actually use.

Furthermore, data scientists can now access an Apache Zeppelin notebook via preloaded samples of techniques for running analytics on data stored in SkySQL. The technology can also be used to discover database schemas, run queries on data in AWS S3 object storage and federate queries to add data from SKYSQL and S3 data sets.

The new version of the DBaaS solution is now generally available on AWS and Google Cloud. The solution additionally includes Xpand 6.1.1, MariaDB Enterprise Server 10.6.12 and ColumnStore 6.3.1.