Delaying Server Fest until Wed 6 April 2022

Things happen, schedules change. I don’t want to bother you with details, so you’ll have to take my word for it: Events related to Russia invading Ukraine have caused us to delay our Security themed MariaDB Server Fest with a week, from Wed 30 March to Wed 6 April 2022.

This is probably the mildest of the consequences of the ongoing war. Nonetheless, we apologise for the inconvenience.

10.9 preview feature: JSON path expression and JSON_OVERLAPS()

The MariaDB 10.9 preview releases introduce a MySQL compatibility syntax extension, range notation. The ‘last’ keyword was added in JSON path expression, as requested in MDEV-22224 and MDEV-27911. Additionally, negative indexes are now also supported. Range notation, implemented using the ‘to’ keyword, and the ‘last’ keyword, is basically an array element selector.

Syntax:

Range notation:
[M to N] selects a range of elements starting from index M to N.
Last keyword:
[last-N] / [last] selects the Nth from last element, and last element, respectively.

MariaDB 10.9 preview releases now available

We are pleased to announce the third MariaDB series release under the new release model, MariaDB 10.9.0.

Maturing MariaDB more quickly

One of the purposes of the new model is to get features into the hands of users more quickly, in a form which supports stability by allowing the new feature to be more easily tested, separate from other new features being developed at the same time.

Candidate features for MariaDB 10.9

There are four separate preview releases, containing the following features under consideration for release in 10.9.1:

SHOW ANALYZE FORMAT=JSON

  1. Extend SHOW EXPLAIN to support SHOW ANALYZE [FORMAT=JSON] (MDEV-27021)
  2. Add EXPLAIN FOR CONNECTION syntax support to SHOW EXPLAIN (MDEV-10000)

JSON Range Notation

  1. Implement range notation for JSONPath (MDEV-27911)
  2. Support JSONPath negative index (MDEV-22224)
  3. JSON_OVERLAPS function (MDEV-27677)

Async redo log write

  1. Asynchronous redo log write (MDEV-26603)

Miscellaneous

  1. Implement the –do-domain-ids, –ignore-domain-ids, and –ignore-server-ids options for mysqlbinlog (MDEV-20119)
  2. information_schema.tables.table_type now shows TEMPORARY
    for local temporary tables.

Start MariaDB in K8s

This is the first in a series of blogs explaining how to use MariaDB in Kubernetes (K8s), as well as explaining some important concepts of K8s and of MariaDB.

This blog explains how to start MariaDB as a stateless application in K8s using the CLI and explores different commands you can run on your CLI.

The prerequisites are that you have installed kubectl (which will also install Docker runtime) and minikube (local K8s).

Let’s first start the minikube

$ minikube start && kubectl get nodes
NAME STATUS ROLES AGE VERSION
minikube Ready control-plane,master 104d v1.22.2

The Pod is a K8s resource and the smallest unit in K8s.

New Sponsor: Schaffhausen Institute of Technology

Good news from and for MariaDB Foundation: in Schaffhausen Institute of Technology (SIT), we have a new Platinum Sponsor. With the additional funds and with the insights provided by Serguei Beloussov, who will work with the MariaDB Foundation on the board level, we expect to improve our ability to further the MariaDB Foundation mission related to our values of Openness, Adoption, and Continuity.

Introducing SIT

This event marks a first in our work with sponsors, given that our top-level sponsor list has so far contained only names fairly familiar to industry players: DBS Bank, Visma, IBM, Microsoft, Alibaba, Tencent, and Service Now, not to mention the eponymous MariaDB Corporation.

We stand with Ukraine

This is a difficult blog entry to write. It involves war. But not a flame war. A real war where people are dying. Innocent people. You have all seen the pictures and videos, it is not my task to describe that.

MariaDB Foundation has been slow to react. This is because we have strong ties to both Ukrainian and Russian developers and we want to do the right thing, as individuals and as the Foundation. Let it be perfectly clear that MariaDB Foundation stands with Ukraine; that said, the rest of the blog is not written in first person plural.

Security: MariaDB Server MiniFest 30 March 2022 – CfP

Mark your calendars! On Wed 30 March 2022 Wed 6 April 2022, we will have the first MariaDB Server MiniFest of the year. The theme of the day is security, in all its shapes and forms – as long as it is relevant to the MariaDB Server user base.

Call for Papers

Submit your paper by 1 March 2022, if your work on security is of interest to the MariaDB ecosystem. We have ongoing discussions with a number of great presenters already, but submissions are welcome.

MariaDB 10.8.2 RC and MariaDB 10.7.3, 10.6.7, 10.5.15, 10.4.24, 10.3.34 and 10.2.43 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.2, a release candidate in the MariaDB 10.8 series, MariaDB 10.7.3, a Generally Available release in the MariaDB 10.7 series (maintained for one year), as well as MariaDB 10.6.7, MariaDB 10.5.15, MariaDB 10.4.24, MariaDB 10.3.34 and MariaDB 10.2.43, the latest stable releases in their respective series.

These primarily fix a problem in last week’s releases when manually running mariadb-upgrade. See MDEV-27789, and the release notes and changelogs for details. …