MariaDB Blog

May 25, 2018

Sequences Support in MariaDB Server 10.3

In the SQL standard SQL:2003 sequences are defined. The idea of sequences is to have a way of requesting unique values on demand. The typical use case for sequences is to have a unique identifier that can be used on multiple tables. In addition it might be useful in some cases to have an identifier before an actual row is inserted. With the normal way of having an automatically incrementing identifier, the identifier value will only be available after insert of the row and the identifier will only be unique inside its own table.

Read More

May 24, 2018

MariaDB TX 3.0 – First to Deliver on the Promise of Enterprise Open Source

It’s one thing to be open source. It’s another to be enterprise open source.

That begs the question: What does it mean to be enterprise open source?

You have to be 100% committed to the open source community – collaboration, transparency and innovation. You have to be 100% committed to customer success – providing the enterprise features and reliability needed to support mission-critical applications.

Read More

May 24, 2018

The Ease of Migrating to MariaDB TX Using New Oracle Compatibility Features

One of the central themes of MariaDB TX 3.0 is reducing the cost, reusing established skill sets and increasing the efficiency, speed and technical viability of migrations from complex, proprietary databases. We’ve added some amazing new features including SEQUENCE constructs, Oracle-style packages, and the ROW data type - making migrations dramatically easier and a true game changer for enterprise open source databases.

Read More

May 23, 2018

A Look into MariaDB Auditing for GDPR Compliance

When we are talking about a database auditing concept, what we are focused on is tracking the use of database records, and the monitoring of each operation on the data.

The auditing activities goal is to provide a clear and reliable answer to the typical 4 W questions: Who accessed the database, When did this happen, What was touched, Where this access came from. Auditing should also help the security team answer the 5th W: Why this happened?

Read More

April 25, 2018

Try MariaDB Server 10.3 in Docker

There are times when you may want to test specific software or a specific version of software. In my case, I wanted to play with MariaDB Server 10.3.6 Release Candidate and some of the new, upcoming features. I didn’t want to have a permanent installation of it on my laptop so I chose to put it in a Docker container that I can easily copy to another place or remove. These are the steps I had to take to get it done.

Read More