Using CONNECT SE to access remote JSON data with demo examples in Docker

CONNECT is a storage engine (SE) plugin used to access external, local or remote data. In this blog we are going to show how to install the CONNECT storage engine in a Docker container and how to share JSON data between containers.

Enabling CONNECT SE plugin in Docker

CONNECT SE needs to be installed within the container in order to use it. To see how to do that please check Installing plugins in the MariaDB Docker Library Container.

Create JSON data on remote server

The most important feature of CONNECT SE to MariaDB is the flexibility to create tables from various data sources, like the same database and other DMBS’s tables or files with different formats.

FOSDEM22 MariaDB devroom committee

We are pleased to announce the FOSDEM22 MariaDB devroom committee.

In February 2022, MariaDB will be hosting its second dedicated devroom at FOSDEM, and the committee have the job of narrowing down the submissions to choose the most interesting final selection for the FOSDEM and MariaDB communities.

Last year the number of submissions far exceeded the available slots, as it had in earlier years when MariaDB participated as part of the joint MySQL, MariaDB and Friends devroom, and we hope not to let the committee off easy this year.

The committee

Sveta Smirnova (Percona)
Oli Sennhauser (FromDual)
Manuel Arostegui (Wikimedia Foundation)
Federico Razzoli (Vettabase)
Daniel Black (MariaDB Foundation)
Daniel Bartholomew (MariaDB Corporation)

Welcome to everyone, and we’re looking to seeing what you decide on!

CfP for the MariaDB devroom FOSDEM 2022 now open

MariaDB is happy to again be hosting a devroom at FOSDEM 2022. This year’s event will be the second virtual FOSDEM, and the MariaDB devroom will take place on Saturday 5 February 2022. The deadline for submissions is very soon, 21 December 2021.

FOSDEM is one of the highlights of the calendar, aimed at free and open-source developers, and is free to attend, with no registration necessary.

Engineering and DBA-related topics such as:

  • best practices
  • migrating to MariaDB
  • MariaDB features
  • optimising on particular hardware

are particularly welcome, but the committee (being announced soon) will consider any submissions of interest to the broader MariaDB community.

Server MiniFest Wed 8 Dec 2021: From the Frontlines

Join our next Server MiniFest, to get the latest news from the MariaDB Server frontlines – in a fresh format inspired by Not the Nine O’Clock News.

Not the Nine O’Clock News?

We may not be as funny as the famous BBC2 sketch comedy aired 1979-82. Let me correct myself: We don’t even aspire to be funny. But we do want to be interesting to follow, and make it easy for you to keep watching – not switching off the MariaDB channel for something else.

And we do that by replicating the fast tempo of the comedy role model.

FOSDEM filming party

Dear FOSDEM fans! No f2f or even hybrid FOSDEM 2022 – we hear that with a combination of resigned sadness and understanding for those responsible of having 8000 people gather in one space. We would probably have come to the same conclusion, in their shoes.

At the same time, we keep hearing how so many good presenters suffer from online fatigue, and the lack of physical meetings. So we have a test balloon, that we’d like to launch – particularly into the MariaDB and database communities at FOSDEM.

What if MariaDB Foundation organised an informal f2f event two weeks prior to FOSDEM? …

MariaDB 10.7.1 RC, and MariaDB 10.6.5, 10.5.13, 10.4.22, 10.3.32 and 10.2.41 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.7.1, the first release candidate in the MariaDB 10.7 series, as well as MariaDB 10.6.5, MariaDB 10.5.13, MariaDB 10.4.22, MariaDB 10.3.32 and MariaDB 10.2.41, the latest stable releases in their respective series.

See the release notes and changelogs for details.

Download MariaDB 10.7.1

Release Notes Changelog What is MariaDB 10.7?


Download MariaDB 10.6.5

Release Notes Changelog What is MariaDB 10.6?

MariaDB & Python: A Match?

Python is my personal favourite programming language, at least this century. So when the opportunity presented itself to have a talk at PyConZA, off I went. Not to South Africa in person, for a 40 minute talk, though.

Technical challenges on Streamyard

It was a live presentation, streamed on Streamyard with chat on Discord. I complained of the bad connectivity I had in central Munich, much to the amusement of the South African audience, which evidently thought they were role models and market leaders when it comes to bad Internet.

Installing plugins in the MariaDB Docker Library Container

MariaDB plugins are software components that may be added to the core software without the need to rebuild the MariaDB Server. Plugins can be storage engines, additional security requirements, special log information about the server and others. MariaDB has a large number of built-in plugins which are permanently installed (listed in SHOW PLUGINS query). Plugins can be loaded at start-up, during initialization, or loaded dynamically when the server is running.

In this blog we are going to see how to list available plugins in the MariaDB container as well as the methods of installing plugins in a container.