MariaDB Blog

September 18, 2017

Announcing MariaDB ColumnStore 1.1.0 Beta

We are happy to announce that today we are releasing 1.1.0 beta software of MariaDB ColumnStore, the high performance, columnar storage engine for large scale analytics on MariaDB. Beta is an important time in our release and we encourage you to download this release today! Please note that we do not recommend running beta releases in production.

MariaDB ColumnStore 1.1 introduces the following key new capabilities:

Read More

September 05, 2017

Automatic Partition Maintenance in MariaDB

A MariaDB Support customer recently asked how they could automatically drop old partitions after 6 months. MariaDB does not have a mechanism to do this automatically out-of-the-box, but it is not too difficult to create a custom stored procedure and an event to call the procedure on the desired schedule. In fact, it is also possible to go even further and create a stored procedure that can also automatically add new partitions. In this blog post, I will show how to write stored procedures that perform these tasks.

Read More

August 24, 2017

5 Essential Practices for Database Security

Data breaches are expensive. Between business disruption, loss of customer confidence, legal costs, regulatory fines and any direct losses that may result from a ransomware attack, for instance, the effects can add up to millions. The best defense is a good offense. In this blog, we'll look at five key practices to keep your database secure: protect, audit, manage, update and encrypt.

Read More