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.

10.7 preview feature: InnoDB Bulk Insert

Everyone wants performance. Speeding up the insert into empty InnoDB tables and partitions is a common enough use case to optimize. Thirunarayanan Balathandayuthapani from the MariaDB Corporation wrote this improvement to the bulk inserting into InnoDB tables that is available as a preview for testing.

To achieve this, if the table is empty then InnoDB will pre-sort the records for each index, and build the indexes one page at a time. If the transaction does bulk insert operation then InnoDB should create buffer of size innodb_sort_buffer_size for each index.

If the buffer ran out of memory then InnoDB will create a temporary file for storing the data.

10.7 feature preview: Miscellaneous features

The “Misc features” preview includes all the other features that did not make it into a separate dedicated preview binary.

MariaDB Server 10.7 includes the JSON_EQUALS function, which compares inputs as JSON objects, regardless of whitespace, key order, or number format.


10.7 preview feature: Password Reuse Check plugin

By default, MariaDB does not check if a user reuses a password. Some security policies require users to choose a new password each time, and the Password Reuse Check plugin, available in a MariaDB 10.7.0 preview, enables this functionality.

Old passwords are stored in the mysql.password_reuse_check_history table, and the period they are retained for is determined by the password-reuse-check-interval system variable, which specifies a number of days. By default this is zero, meaning unlimited retention.

The password can be used in conjunction with other password validation plugins, such as the Simple Password Check plugin or the CrackLib Password Check plugin.

10.7 preview feature: CONVERT PARTITION

If you are using table partitioning, you have likely heard of the ALTER TABLE … EXCHANGE PARTITION … WITH TABLE … command. It existed in MariaDB since forever. But if you check the manual (any manual) or search the web, you will see that almost the only use case of it is converting a partition to a standalone non-partitoned table, or converting a standalone non-partitoned table into a partition.

And the usage was designed back then to be anything but obvious. To convert a partition to a table you need first to create an empty table with the same structure as a partition, then you exchange it with a partition, and then you drop the empty partition.