MariaDB SkySQL Unleashes Powerful Serverless Analytics and Cost Optimization Features

MariaDB has introduced an update to its managed database-as-a-service (DBaaS) called SkySQL, which brings serverless analytics and cost management features. This update eliminates the necessity for conventional data extraction, transformation, and loading processes by integrating a serverless layer powered by Apache Spark SQL.

SkySQL, being a managed instance of the MariaDB platform, encompasses a comprehensive set of features. It combines online analytical processing (OLAP) and online transaction processing (OLTP) capabilities and incorporates enterprise functionalities such as sharding, load balancing, and auto-failover. These features are enabled through the utilization of MariaDB Xpand, MariaDB Enterprise Server, and MariaDB ColumnStore.

MariaDB has introduced an autoscaling feature in SkySQL to assist enterprises in reducing database costs and enhancing expenditure management. This feature operates based on user-defined rules, particularly CPU utilization thresholds. When the CPU utilization surpasses a predetermined level for a sustained duration, additional replicas or nodes are added. Conversely, if the utilization falls below another threshold, nodes or replicas are removed. By paying only for the utilized resources, enterprises can maintain cost predictability.

The latest update of SkySQL brings not only autoscaling but also serverless analytics capabilities, rendering traditional extract, transform, load (ETL) tasks unnecessary. By leveraging a serverless analytics layer powered by Apache Spark SQL, SkySQL enables operational analytics on both active transactional data and external data sources. This approach ensures that analytical and transactional views remain consistent.

Furthermore, the release provides data scientists with access to a dedicated version of Apache Zeppelin notebooks. These notebooks are equipped with pre-loaded examples that showcase analytics on data stored in SkySQL. They serve as a valuable tool for discovering database schemas, executing queries on data stored in Amazon S3, and facilitating query federation to combine data across SkySQL databases and S3 object storage.

The latest version of SkySQL is now widely accessible on AWS and Google Cloud. It incorporates updated editions of MariaDB Xpand (6.1.1), Enterprise Server (10.6.12), and ColumnStore (6.3.1). Additionally, new customers who subscribe to the DBaaS have the opportunity to receive $500 in credits.

?

Conclusion

In conclusion, the latest release of MariaDB SkySQL brings significant enhancements to the managed database-as-a-service. The introduction of serverless analytics, cost management features, and autoscaling capabilities enables enterprises to reduce costs, improve analytics performance, and ensure scalability. With the elimination of traditional ETL tasks and the integration of powerful tools like Apache Spark SQL and Apache Zeppelin notebooks, SkySQL provides a comprehensive solution for data analysis and management. The availability of the updated version on AWS and Google Cloud, along with the opportunity for new customers to claim $500 credits, further adds to its appeal as a reliable and efficient DBaaS option.