Beijing and Singapore MariaDB Server Fests

MariaDB Server Fest is coming to Asia Pacific! Beijing and Singapore are the two symbols for the timezones, much like Paris for the Server Fest in Europe, Middle East and Africa, and New York for the Server Fest in the Americas.

The reason we have two different symbols for the same time zone is that we want to adapt to the different Internet landscape in China.

Singapore is like Paris and New York

For Singapore, things look like they do in Paris and New York.

Read more

Server Fest Presenter List

The MariaDB Server Fest next month has approved quite a number of exciting presentations. The presenters are now busy filming their presentations, which will be aired three times – Monday to Wednesday 14-16 September 2020 in the Paris timezone (for EMEA), Tuesday to Thursday 15-17 September 2020 in the New York timezone (for the Americas), and Friday to Sunday 18-20 September 2020 in the Beijing timezone (for APAC).

Interactivity through cloning

Through logic (not magic), we have cloned the presenters. As the presentation is aired in the form of video, slides and voice, the presenter is fully concentrating on following what you, the attendee, ask in the chat room.

Read more

Multilingual MariaDB video on Set Theory Features

Our very own Ian Gilfillan has created a brief and clear video called Get Set for Set Theory: UNION, INTERSECT and EXCEPT in SQL


Get Set for Set Theory: UNION, INTERSECT and EXCEPT in SQL

In a tad more than six minutes, you’ll see exactly how UNION, INTERSECT and EXCEPT work, starting in MariaDB 10.3, a few years back.

Ian explains what they are for, and the option to change default behaviour of DISTINCT with ALL (of which the ALL option was introduced in MariaDB 10.5).

That’s not new.

Read more

MariaDB Server Fest CfP extended until Wed 15 July 2020

Thank you for the many submissions to our Call for Papers, and to your insightful replies to our Call for Attendees.

Based on the CfA replies and other feedback given to us, we could draw a few conclusions.

Attendees: Three-day event

First, we will spread out the event from a two-day event to a three-day event, for the attendees. We received several comments around preferences for shorter days, giving time for “normal” work. Rather three short days, than two long ones. That made perfect sense to us. We already changed a couple of convetions when moving from a physical event to a virtual;

Read more

ColumnStore Native Part of MariaDB 10.5

On Wednesday 24 June 2020, MariaDB Server 10.5 was released GA. While there are several cool new features included, this first 10.5 blog is about the groundbreaking new component, ColumnStore.

The big picture

ColumnStore brings data warehousing to the world of MariaDB Server. It’s a columnar storage engine (Wikipedia: Column-oriented DBMS), enabling what is often called HTAP (Wikipedia: Hybrid Transactional/Analytical Processing). The Columnar data type stores data by columns, not by rows, enabling quick analytical reporting over huge data volumes.

The news

The ColumnStore engine is part of MariaDB Server 10.5.

Read more

MariaDB Server Fest 14-20 Sep 2020

Join our Online Conference in September! In three different time zones, we will meet users of MariaDB Server for two packed days of presentations, interactions and insights.

The Call for Papers is open. And we have a favour to ask everyone considering attending: Please fill in our Call for Attendance survey! We need your help to ensure that we do logistics right when it comes to timing and formats, that we cover all topics that interest you, and that we prepare interactivity and tools in the best possible way.

Registration is not open yet.

Read more

Selecting the right database

How do you select a database in practice? How do you pretend to select it? And, if you want to be serious, how do you select it logically?

Those are the key questions I dug into, during my keynote last week at Percona Live Online.


For those who feel they don’t want to listen to the entire 30 minute video of the presentation, I have compiled a number of entry points for you below:

  • 0:23 Silly hat meme, “Teknologmössa”
  • 2:19 Agenda
  • 2:43 Choosing a database in practice
  • 3:59 Pretending to choose a database
  • 5:00 Triggers for making a fresh choice
  • 5:51 Monetary impulses
  • 7:53 Database lifecycle impulses
  • 10:07 MariaDB 5.5 on Github
  • 11:24 Framework for database choice: 1.

Read more

Congratulations, MySQL, 25 years today!

Time flies!

It certainly doesn’t feel like 25 years ago that Monty released MySQL. At that time, I thought it was a bit redundant of Monty to create Yet Another Database, the world was full of them already. But MySQL turned out to become the database for Internet, growing hand-in-hand with PHP (and Perl and Python). 

When MySQL was created 1995, Monty’s oldest daughter My was six years old. When the first MariaDB was released 2009, My’s little sister Maria was one year younger, five years old.

The oldest mysql.com site I found: 5 July 1998

One innovation over the other databases was the license model.

Read more