MariaDB Blog

October 02, 2017

Getting Started with MariaDB Galera and MariaDB MaxScale on CentOS

MariaDB Galera Cluster is a great way to implement High Availability with MariaDB and combining it with MariaDB MaxScale creates a great High Availability Cluster with transparent failover. Getting started with any HA solution is mostly a bit confusing as there are so many components that work together and each has to be configured to work with the other. This blogpost shows how to get started with MariaDB Galera Cluster with MariaDB MaxScale on CentOS / RHEL 7.

Read More

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